[michelle86]

Can anyone tell me how to fix this? It looks like it has to do with the albums.

If you can fix it, I pretty much will owe you my life. I've been getting these errors a lot.


Database error in vBulletin 4.1.2:

Invalid SQL:

SELECT alb.albumid, att.attachmentid, att.userid, att.caption, att.dateline, att.state, fdt.filesize, IF(fdt.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fdt.thumbnail_dateline, fdt.thumbnail_width, fdt.thumbnail_height, u.username
FROM album AS alb
LEFT JOIN attachment AS att ON alb.albumid = att.contentid
LEFT JOIN filedata AS fdt ON att.filedataid = fdt.filedataid
LEFT JOIN user AS u ON att.userid = u.userid
WHERE alb.state = 'public' AND att.contenttypeid = '8'
ORDER BY rand(430580)
LIMIT 6;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Wednesday, May 4th 2011 @ 08:15:26 AM
Error Date : Wednesday, May 4th 2011 @ 08:17:10 AM
Script : http://members.lovingfromadistance.com/index.php
Referrer : http://members.lovingfromadistance.com/index.php
IP Address : 82.193.101.31
Username : Unregistered
Classname : vB_Database
MySQL Version :