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

gordon’s picture

Component: new module » ec_customer
Status: Active » Fixed

I have now fixed this. It had some other side effects.

Gordon.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.