Help: database Error

[AJ Blacklisted]

Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid, user.lastvisit,
session.userid, session.inforum, session.lastactivity, session.badlocation,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

FROM vb_session AS session
LEFT JOIN vb_user AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1305602783

ORDER BY username ASC;

MySQL Error : Out of memory (Needed 1677696 bytes)
Error Number : 5
Request Date : Tuesday, May 17th 2011 @ 06:41:23 AM
Error Date : Tuesday, May 17th 2011 @ 06:41:23 AM
Script : http://devilarts.info/gfx/
Referrer : http://devilarts.info/
IP Address : 117.196.160.14
Username : Unregistered
Classname : vB_Database
MySQL Version :

recieving this error to my email.
any help ? I recently changed the data from domain to a subdomain.

 

[bmoeller]

I would bet That

ORDER BY username ASC;

is using all your allotted memory
you can increase your memory usage in your php.ini file

 

[Piracy King]

you need to change your my sql memory limit.

change the mysql packet size (max_allowed_packet) to some what higher value.. ( 10mb + current value).