Log in

View Full Version : VB Error Issue?


CaIum
10-26-2012, 11:15 PM
Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount, post.userid, user.userid,
user.username, user.lastpostid, user.posts, user.usergroupid,
IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid,
NOT ISNULL(customprofilepic.userid) AS haspic, customprofilepic.width, customprofilepic.height
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
LEFT JOIN customprofilepic AS customprofilepic ON (customprofilepic.userid = user.userid)



WHERE post.dateline > 1351210492
GROUP BY post.userid
ORDER BY postcount DESC
LIMIT 6;

MySQL Error : Out of memory (Needed 1677600 bytes)
Error Number : 5
Request Date : Saturday, October 27th 2012 @ 01:14:52 AM
Error Date : Saturday, October 27th 2012 @ 01:14:52 AM
Script : http://discusshabbo.com/index.php
Referrer : http://discusshabbo.com/showthread.php?p=1115
IP Address : 86.130.212.196
Username : Kevin
Classname : vB_Database
MySQL Version : 5.1.65-cll

This is the error that keeps showing on my forum, any fixes?

ForceHSS
10-26-2012, 11:36 PM
Out of memory

Lynne
10-27-2012, 01:08 AM
The fix is to talk to your host and have them fix it.