Announcement

Collapse
No announcement yet.

Error Database error in vBulletin 5.4.0: Invalid SQL

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error Database error in vBulletin 5.4.0: Invalid SQL

    several problems

    Error Database error in vBulletin 5.4.0: Invalid SQL: ### Channels ### SELECT follow.title AS title, follow.nodeid AS keyval, 'node' AS sourcetable, IF(follow.lastcontent = 0, follow.lastupdate, follow.lastcontent) AS lastactivity, follow.totalcount AS activity, type.class AS type, (follow.nodeoptions & 512) AS noUnsubscribe FROM vb3node AS follow INNER JOIN vb3contenttype AS type ON type.contenttypeid = follow.contenttypeid INNER JOIN vb3subscribediscussion AS sd ON sd.discussionid = follow.nodeid AND sd.userid = 1 UNION ALL ### Users ### SELECT follow.username AS title, follow.userid AS keyval, 'user' AS sourcetable, IFNULL(follow.lastpost, follow.joindate) AS lastactivity, follow.posts as activity, 'Member' AS type, 0 AS noUnsubscribe FROM vb3user AS follow INNER JOIN vb3userlist AS ul ON ul.relationid = follow.userid AND ul.userid = 1 WHERE ul.type = 'follow' AND ul.friend = 'yes' ORDER BY title ASC LIMIT 100; MySQL Error : Illegal mix of collations for operation 'UNION' Error Number : 1271 Request Date : Sunday, March 25th 2018 @ 03:28:05 PM Error Date : Sunday, March 25th 2018 @ 03:28:05 PM Script : https://www.foro3d.com/admincp/user.php?do=edit&u=1 Referrer : https://www.foro3d.com/admincp/user.php?do=modify& IP Address : 37.14.211.196 Username : 3dpoder Classname : vB_Database_MySQLi MySQL Version : 10.2.12-MariaDB

    Traza excepción:
    ## /home/poder/public_html/foro3d.com/core/vb/database.php(1189) Exception Thrown
    #0 /home/poder/public_html/foro3d.com/core/vb/database/mysqli.php(201): vB_Database->halt()
    #1 /home/poder/public_html/foro3d.com/core/vb/database.php(557): vB_Database_MySQLi->execute_query(true, Object(mysqli))
    #2 /home/poder/public_html/foro3d.com/core/vb/db/result.php(126): vB_Database->query_read('Invalid SQL:\r\n\n...')
    #3 /home/poder/public_html/foro3d.com/core/vb/db/result.php(63): vB_dB_Result->rewind()
    #4 /home/poder/public_html/foro3d.com/core/packages/vbforum/db/mysql/querydefs.php(6471): vB_dB_Result->__construct(Object(vB_Database_MySQLi), '\n\t\t\t\t\t### Chann...')
    #5 /home/poder/public_html/foro3d.com/core/vb/db/query/method.php(175): vBForum_dB_MYSQL_QueryDefs->getUserFollowing(Array, Object(vB_Database_MySQLi), false, false)
    #6 /home/poder/public_html/foro3d.com/core/vb/db/assertor.php(304): vB_dB_Query_Method->execSQL()
    #7 /home/poder/public_html/foro3d.com/core/vb/db/assertor.php(653): vB_dB_Assertor->assertQuery('vBForum:getUser...', Array, false)
    #8 /home/poder/public_html/foro3d.com/core/vb/api/follow.php(387): vB_dB_Assertor->getRows('vBForum:getUser...', Array)
    #9 /home/poder/public_html/foro3d.com/core/vb/api/user.php(192): vB_Api_Follow->getFollowing(1)
    #10 /home/poder/public_html/foro3d.com/core/vb/api/wrapper.php(199): vB_Api_User->fetchProfileInfo(1)
    #11 /home/poder/public_html/foro3d.com/core/admincp/user.php(218): vB_Api_Wrapper->__call('fetchProfileInf...', Array)
    #12 /home/poder/public_html/foro3d.com/includes/api/interface/collapsed.php(142): require_once('/home/poder/pub...')
    #13 /home/poder/public_html/foro3d.com/includes/vb5/frontend/controller/relay.php(39): Api_Interface_Collapsed->relay('admincp/user.ph...')
    #14 /home/poder/public_html/foro3d.com/index.php(74): vB5_Frontend_Controller_Relay->admincp('user.php')
    #15 {main}

  • #2
    Illegal mix of collations for operation 'UNION'

    You need to make sure that all tables use the same collation. Most likely, you're mixing a latin1 and a UTF-8 collation. They should all be the same.

    https://dev.mysql.com/doc/refman/5.7...set-table.html
    https://stackoverflow.com/questions/...ion-of-a-table
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.

    Comment

    Related Topics

    Collapse

    Working...
    X