
12-14-2006, 10:05 PM
|
|
|
Join Date: Nov 2005
Posts: 84
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Searched this forum but didn't find a solution or hint on an error.
When trying to access ldm I will get this error message:
Quote:
Datenbankfehler in vBulletin 3.6.4:
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.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,
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
, COUNT(lhits.linkid) AS linkrecenthits
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_linksdownloads AS lhits
ON link.linkid = lhits.linkid
WHERE lhits.usertime>=1163547774
GROUP BY linkid, linkcatid
ORDER BY linkhits DESC;
MySQL-Fehler : Got error 28 from storage engine
Fehler-Nr. : 1030
Datum : Thursday, December 14th 2006 @ 06:42:54 PM
Skript : http://www.*****.com/forum/local_links.php?
Referrer : http://www.*****.com/forum/showthrea...3082#post13082
IP-Adresse : **.***.***.***
Benutzername : ******
Klassenname : vb_database
|
ldm version: 2.2.6
MySQL: 4.1.10a
PHP: 4.4.3
Changing MySQL or PHP is not possible,
Any suggestions how to solve this problem?
#################
EDIT: OK, Problem solved by repairing tables...
|