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:

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

[Message index]

		SQL error on upgrade By: miknight on Sun, 31 October 2004 06:33
		Re: SQL error on upgrade By: Ilia on Sun, 31 October 2004 19:31

Previous Topic:	Confusion about Login Status
Next Topic:	Selected and Unselected mix-up?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 17 14:35:00 GMT 2024

Total time taken to generate the page: 0.05850 seconds