
01-02-2004, 03:58 PM
|
|
|
Join Date: Oct 2002
Location: Indiana, USA
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I'm having a bit of problem. Everytime I access the portal I get this MySQL error. This has been happening off and on with no help from me. I just went to my site this morning and it was like this but was working fine last night. Any help would be nice. Here's the error:
Quote:
Invalid SQL: SELECT thread.threadid,thread.title,replycount,postuserna me,postuserid,thread.dateline,views,thread.iconid, votenum,votetotal,postid,pagetext,allowsmilie,show signature,signature,avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline AS avatardateline ,thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath
FROM thread
LEFT JOIN post ON (thread.threadid=post.threadid)
LEFT JOIN user ON (user.userid=post.userid)
LEFT JOIN avatar ON (avatar.avatarid=user.avatarid)
LEFT JOIN customavatar ON (customavatar.userid=user.userid)
LEFT JOIN icon ON icon.iconid=thread.iconid
WHERE forumid='4' AND isnews='Y' AND open<>10
GROUP BY thread.threadid
ORDER BY thread.threadid DESC LIMIT 10 mysql error: Got error 28 from table handler
mysql error number: 1030
|
|