First try failed

[Sergio68]

Yesterday I tried to upgrade to Beta 2 but at the 11th step of beta 1 everything hang for a mixed collation error :(

I'll try again now :)

[Floris]

Ok.. how can we help?

[Sergio68]

That's today, same as yesterday, any suggestments ?


Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT atype.extension, atype.thumbnail, atype.newwindow, aperm.usergroupid,
atype.height AS default_height, atype.width AS default_width, atype.size AS default_size,
aperm.height AS custom_height, aperm.width AS custom_width, aperm.size AS custom_size,
aperm.attachmentpermissions AS custom_permissions
FROM attachmenttype AS atype
LEFT JOIN attachmentpermission AS aperm USING (extension)
WHERE enabled = 1
ORDER BY extension;

MySQL Error : Illegal mix of collations (utf8_bin,IMPLICIT) and (latin1_bin,IMPLICIT) for operation '='
Error Number : 1267
Date : Sunday, June 18th 2006 @ 01:43:09 AM
Script : http://www.vbulletin.it/forums/install/upgrade_360b1.php?step=11
Referrer : http://www.vbulletin.it/forums/install/upgrade_360b1.php?step=10
IP Address : 81.174.32.193
Username :
Classname : vb_database

[Sergio68]

I forgot, PHP 4.4.0 , MySql 4.1.13

[Floris]

Maybe the info here helps debug it:

http://www.vbulletin.com/forum/showthread.php?t=182933

[Sergio68]

I manually modified altering the collation of a couple of table with mysqladministrator and now it's working.

[Sergio68]

Maybe the info here helps debug it:

http://www.vbulletin.com/forum/showthread.php?t=182933

I said too early :D Now I got that problem too, in the admin panel, I'll try to alter some other tables .

[Sergio68]

:confused:
Now I got this :

Database error in vBulletin 3.6.0 Beta 2:

Invalid SQL:

SELECT adminmessage.adminmessageid
FROM adminmessage AS adminmessage
INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
WHERE adminmessage.status = 'undone'
AND adminmessage.script <> ''
AND adminlog.dateline > adminmessage.dateline
GROUP BY adminmessage.adminmessageid;

MySQL Error : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Sunday, June 18th 2006 @ 02:28:44 AM
Script : http://www.vbulletin.it/forums/admincp/index.php?do=home
Referrer : http://www.vbulletin.it/forums/admincp/index.php?do=nav
IP Address : 81.174.32.193
Username : Sergio
Classname : vb_database

But adminlog and adminmessage are latin1, not UTF8 :confused: I just altered both.

[Floris]

Freddie posted in another thread about this, you can send him a PM I believe and he will look into it. You can find his profile by going to the www.vbulletin.com/forum/showgroups.php (http://www.vbulletin.com/forum/showgroups.php) page

[Sergio68]

Ok, thx, I hope they do not answer me "Hey this is not 3.6 forum" :D

[Colin F]

You need to set the collation for the database tables and also for the database rows.

[Sergio68]

You need to set the collation for the database tables and also for the database rows.
Ok, so once I set that I must use one collation OR the other but not both, that's my problem, my DB seems mixed up.

[Colin F]

Exactly, it can't compare values if they're not encoded using the same method.

[Sergio68]

Ok, thx, now it's clear.
That's bad, I hope I do not damage anything by altering all the tables.