View Single Post
  #9  
Old 01-18-2013, 03:53 AM
 
sym0n sym0n is offline
 

Member
  
Join Date: Apr 2006
Posts: 25
 

Default Re: 4.5.0 Database upgrade packs released

Quote:
Originally Posted by sym0n
Now i am getting :

Applying table differences 4.2.3-4.4.0.
SQL error #1267 : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
SQL query: UPDATE xcart_customer_bonuses INNER JOIN xcart_customers ON xcart_customers.username=xcart_customer_bonuses.lo gin SET xcart_customer_bonuses.userid=xcart_customers.id


I fixed the above by restarting apache.

Now i am getting :

Creating a new tables definition for 4.2.3-4.4.0.
SQL error #1075 : Incorrect table definition; there can be only one auto column and it must be defined as a key
SQL query: ALTER TABLE xcart_customers DROP PRIMARY KEY
__________________
Gold 4.5.5 / UK
Reply With Quote