[AndrewD]

Originally Posted by sparklywater

Again my visitors are getting database error messages when trying to access LDM pages. I'm convinced this has something to do with LDM because it almost invariably gives error-messages on access to LDM pages. Here is an example:

Database error in vBulletin 3.7.2:
 
Invalid SQL:
 
		SELECT
			link.linkid AS linkid, link.linkname AS linkname, link.linkdoi AS linkdoi,
			link.linkuserid AS linkuserid, link.linkusername AS linkusername,
			link.linkurl AS linkurl, link.linkimg AS linkimg,
			link.linkimgthumb AS linkimgthumb, link.linkimgthumbsize AS linkimgthumbsize, link.linkforum AS linkforum,
			link.linkdesc AS linkdesc, link.numrate AS numrate, link.totrate AS totrate,
			link.linkhits AS linkhits, link.linksize AS linksize, link.linkstatus AS linkstatus,
			link.linkdate AS linkdate, link.linkmoderate AS linkmoderate, link.linkmoddate AS linkmoddate,
			link.linkreviewfreq AS linkreviewfreq,
			ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder
			, user.*, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
			
			
			, lkeys.keyword AS linkkey
			FROM local_linkslink AS link
			LEFT JOIN local_linksltoc AS ltoc ON link.linkid = ltoc.linkid
			LEFT JOIN user AS user ON (user.userid = link.linkuserid)
			LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
			LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
	
			LEFT JOIN local_linksltok AS ltok
			ON link.linkid = ltok.linkid
			LEFT JOIN local_linkskeys AS lkeys
			ON ltok.keyid = lkeys.keyid
		 WHERE link.linkforum NOT IN (0)  AND ltoc.catid = '15'  AND link.linkmoderate = 0 
			ORDER BY linkdorder ASC,   linkdate ASC,  linkname ASC, linkcatid ASC;
 
MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Saturday, April 25th 2009 @ 10:53:30 AM
Error Date    : Saturday, April 25th 2009 @ 10:53:30 AM
Script        : http://www.sparklywater.com/category/15.html
Referrer      : http://www.sparklywater.com/
IP Address    : 83.101.150.115
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

MySQL error 28 means "No space left on device". I.e. your server has a close-to-full disk, or something similar.