I experienced a MYSQL error during my upgrade from EC-6.x-beta5 to EC-6.x-dev, looks like some index changes didn't work:
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE ec_customer DROP PRIMARY KEY in C:\wamp\www\skywyatt\includes\database.mysql-common.inc on line 386.
* user warning: Multiple primary key defined query: ALTER TABLE ec_customer CHANGE ecid `ecid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (ecid) in C:\wamp\www\skywyatt\includes\database.mysql-common.inc on line 520.
* warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\skywyatt\includes\database.mysql.inc on line 321.
Doesn't otherwise affect my site however and since my site is small I'm not expecting any performance penalties.
Comments
Comment #1
gordon commentedI have now fixed this. It had some other side effects.
Gordon.