Добрый Вечер.
Имеется vBulletin 5.6.0 Обновился с 3.8.6 по глупости.
При попытке посмотреть любого пользователя выдает
Это действие не может быть выполнено. Пожалуйста, попробуйте снова. Если эта проблема повторяется, то, пожалуйста, свяжитесь с администрацией, сообщив им, какие именно действия приводят к этой ошибке.
На почту приходят ошибки вида
Database error in vBulletin 5.6.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 node AS follow
INNER JOIN contenttype AS type ON type.contenttypeid = follow.contenttypeid
INNER JOIN subscribediscussion AS sd ON sd.discussionid = follow.nodeid AND sd.userid = 13388
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 user AS follow
INNER JOIN userlist AS ul ON ul.relationid = follow.userid AND ul.userid = 13388
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, April 19th 2020 @ 12:07:42 AM
Error Date : Sunday, April 19th 2020 @ 12:07:42 AM
Script :
https://www.i.org/member/13388-fatca
Referrer :
https://www.i.org/online
IP Address :
Username : FatCa
Classname : vB_Database_MySQLi
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 576
#3 vB_Database->query_read() called in [path]/vb/db/result.php on line 144
#4 vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 68
#5 vB_dB_Result->__construct() called in [path]/packages/vbforum/db/mysql/querydefs.php on line 6739
#6 vBForum_dB_MYSQL_QueryDefs->getUserFollowing() called in [path]/vb/db/query/method.php on line 175
#7 vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 293
#8 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 641
#9 vB_dB_Assertor->getRows() called in [path]/vb/api/follow.php on line 406
#10 vB_Api_Follow->getFollowing() called in [path]/vb/api/user.php on line 164
#11 vB_Api_User->fetchProfileInfo() called in [path]/vb5/route/profile.php on line 98
#12 vB5_Route_Profile->setBreadcrumbs() called in [path]/vb5/route.php on line 418
#13 vB5_Route->getBreadcrumbs() called in [path]/vb/api/route.php on line 315
#14 vB_Api_Route->getRoute() called in [path]/vb/api/wrapper.php on line 201
#15 vB_Api_Wrapper->__call() called in /home/1111/public_html/includes/api/interface/collapsed.php on line 101
#16 Api_Interface_Collapsed->callApi() called in /home/1111/public_html/includes/vb5/frontend/routing.php on line 121
#17 vB5_Frontend_Routing->setRoutes() called in /home/1111/public_html/includes/vb5/frontend/application.php on line 21
#18 vB5_Frontend_Application::init() called in /home/1111/public_html/index.php on line 48