vBulletin 4.2.5 mysqli errors

[mscottralston]

Hey guys,

I recently followed the "mysql is deprecated, swap to mysqli already" warnings and did so, and now I get a few of these a day instead. I know error 28 is a space error, but out of space we aren't. Has this shown up for other people in the past?

Database error in vBulletin 4.2.5:

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb

FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 37433
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'

ORDER BY RAND()
LIMIT 0, 2;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Friday, September 22nd 2017 @ 12:30:07 PM
Error Date : Friday, September 22nd 2017 @ 12:30:07 PM
Script : http://redacted/member.php?37433-Wraithe&tab=activitystream&type=all&page=35
Referrer :
IP Address : 5.255.250.161
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
Server : (redacted)
User Agent :


Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 475
#2 vB_Database->query_read_slave() called in [path]/includes/class_profileblock.php on line 594
#3 vB_ProfileBlock_Friends->prepare_output() called in [path]/includes/class_profileblock.php on line 469
#4 vB_ProfileBlock_Friends->fetch_unwrapped() called in [path]/includes/class_profileblock.php on line 214
#5 vB_ProfileBlock->fetch() called in [path]/member.php on line 628

[Wayne Luke]

Error 28 means there is no storage space on the server. You need to contact your hosting provider or server administrator. Looking at the query, this could be in relation to the temporary storage on the server as MySQL builds temporary tables for the sort.