Database error in vBulletin 5.2.5:

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pardeep Bagga
    Member
    • Dec 2011
    • 86
    • 4.1.x

    Database error in vBulletin 5.2.5:

    i am getting following data base errors

    Database error in vBulletin 5.2.5:

    Invalid SQL:
    SELECT * FROM routenew
    WHERE `prefix` IN ('forum/forums/indian-celebrities/6418-ranveer-singh-and-vaani-kapoor-on-harper’s-bazaar-bride-mag','forum/forums/indian-celebrities','forum/forums','forum');

    MySQL Error : Illegal mix of collations for operation ' IN '
    Error Number : 1271
    Request Date : Wednesday, November 30th 2016 @ 11:25:27 PM
    Error Date : Wednesday, November 30th 2016 @ 11:25:27 PM
    Script : http:///forum/forums/indian-celebrit...zaar-bride-mag
    Referrer :
    IP Address : 141.8.143.210
    Username : Guest
    Classname : vB_Database_MySQLi
    MySQL Version :
    Database error in vBulletin 5.2.5:

    Invalid SQL:
    SELECT * FROM routenew
    WHERE `prefix` IN ('forum/forums/indian-celebrities/5718-nargis-fakhri-on-juice-magazine’s-september-issue','forum/forums/indian-celebrities','forum/forums','forum');

    MySQL Error : Illegal mix of collations for operation ' IN '
    Error Number : 1271
    Request Date : Wednesday, November 30th 2016 @ 10:31:17 PM
    Error Date : Wednesday, November 30th 2016 @ 10:31:18 PM
    Script : http:///forum/forums/indian-celebrit...eptember-issue
    Referrer :
    IP Address : 141.8.143.210
    Username : Guest
    Classname : vB_Database_MySQLi
    MySQL Version :
    AND THESE ARE SO MANY
    our communities - www.filmy18.com
  • Necrophyte
    Member
    • Oct 2014
    • 58
    • 5.2.x

    #2
    Sounds like you have some special characters.
    Is your site setup for UTF-8? DataBase is UTF-8, and set the language to UTF-8?

    Comment

    Related Topics

    Collapse

    Working...