SQL_MODE. I guess I should have realized that the following two lines from my
my.cnfoption file would probably not be liked by Wordpress either:
default-storage-engine=InnoDB #Set the default storage engine (table type) for tables.
init-connect="set autocommit=0" #set autocommit off on connect
So, I went back and hacked
wp-includes/wp-db.phpagain. Now the fix read:
// fix sql_mode
mysql_query("SET SESSION SQL_MODE := ''",$this->dbh);
mysql_query("SET SESSION AUTOCOMMIT=ON",$this->dbh);
// end fix sql_mode
Let's hope this was the last one ....