Error Database error in vBulletin 5.4.0: Invalid SQL

[xony]

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}

[Wayne Luke]

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/en/charset-table.html

https://stackoverflow.com/questions/742205/how-to-change-the-default-collation-of-a-table

[Rob-H]

I'm having the same error and all of my table collations are latin1_swedish_ci and all of my engine settings = InnoDB

[Wayne Luke]

Please open a new topic and paste the actual error into the topic starter.