[Forum] error database

[xony]

Hello, I changed tables latin1_swedish_ci to latin1_spanish_ci, and gives me some errors, for example when entering the admincp gives me this error:

Database error in vBulletin 4.2.2:

Invalid SQL:

    SELECT adminmessage.adminmessageid
    FROM vb3adminmessage AS adminmessage
    INNER JOIN vb3adminlog 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 (latin1_swedish_ci,IMPLICIT) and (latin1_spanish_ci,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Monday, July 7th 2014 @ 11:57:45 PM
Error Date    : Monday, July 7th 2014 @ 11:57:45 PM
Script        : xxxxx.com/admincp/index.php?do=home
Referrer      : xxxx.com/admincp/index.php?do=nav
IP Address    : 37.15.196.28
Username      : 3dpoder
Classname     : vB_Database
MySQL Version : 5.5.36-cll

And then secondly, to make the switch from latin1_swedish_ci to latin1_spanish_ci in vbpost table, I get this one:

[COLOR=#000000][FONT=arial]Database error in vBulletin 4.2.2:[/FONT][/COLOR]

[COLOR=#000000][FONT=arial]Invalid SQL:[/FONT][/COLOR]

[COLOR=#000000][FONT=arial]               SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]               FROM vb3post AS post[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]               LEFT JOIN vb3user AS user ON (user.userid = post.userid)[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]               WHERE threadid = 62687[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]                       AND visible = 1[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]                       AND post.userid NOT IN (49778,118559,125587)[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]               ORDER BY dateline ASC[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]               LIMIT 0,15;[/FONT][/COLOR]

[COLOR=#000000][FONT=arial]MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_spanish_ci,IMPLICIT) for operation 'ifnull'[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]Error Number  : 1267[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]Request Date  : Tuesday, July 8th 2014 @ 12:03:31 AM[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]Error Date    : Tuesday, July 8th 2014 @ 12:03:31 AM[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]Script        : [/FONT][/COLOR][URL="http://www.foro3d.com/archive/index.php/t-62687.html"]xxxxx.com/archive/index.php/t-62687.html[/URL]
[COLOR=#000000][FONT=arial]Referrer      : [/FONT][/COLOR][URL]https://www.google.es/[/URL]
[COLOR=#000000][FONT=arial]IP Address    : 78.136.70.220[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]Username      :[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]Classname     : vB_Database[/FONT][/COLOR]
[COLOR=#000000][FONT=arial]MySQL Version :[/FONT][/COLOR]

Thanks for the help.

[Lynne]

You may have changed the table collations, but you also need to go through and make sure to change all table field collations if they were specified and the error is saying you did not do that.