FUDforum: Bug Reports » SQL error on upgrade

Home » FUDforum Development » Bug Reports » SQL error on upgrade

Show: Today's Messages :: Polls :: Message Navigator

SQL error on upgrade [message #20862]

Sun, 31 October 2004 06:33

miknight

Messages: 5
Registered: April 2004
Location: Sydney, Australia

Karma: 0

Junior Member

I have MySQL 4.1.7 and when trying to upgrade from 2.6.6 to 2.6.7 or 2.6.8rc2 I get an error. The error is different depending on which of the two versions I am upgrading to.

For 2.6.7 it is:

MySQL Error: #1273 (Unknown collation: 'utf8'): ALTER TABLE fud26_action_log CONVERT TO CHARACTER SET utf8 COLLATE utf8

For 2.6.8rc2 it is:

MySQL Error: #1270 (Illegal mix of collations (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'replace'): UPDATE fud26_ses SET action=REPLACE(action, 'http://bb.prohost.org/mm/', '')

Report message to a moderator