Helllllp

for some reason every thread that i open at sg online gets the following error

i checked that file and the database and they both seem to be fine. i was getting the error with 2.2.6 so i upgraded it to 2.2.8 but it's still there all of it

i reverted the templates (well i just turned the other one off and got template 0

there are zero file hacks installed other than me editing the admin/index.php before it went up with the tbs and query links

Warning: MySQL: Unable to save result set in /home/hsphere/local/home/deaswood/forums.sg-online.net/admin/db_mysql.php on line 93



There seems to have been a slight problem with the The Stargate Online Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.



Database error in vBulletin 2.2.8:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,3212,3216,3217)
ORDER BY dateline

mysql error: Got error 134 from table handler

mysql error number: 1030

Date: Saturday 02nd of November 2002 07:02:47 AM
Script: http://www.forums.sg-online.net/show...p?threadid=373
Referer: http://forums.sg-online.net/forumdisplay.php?forumid=4

[Gaffer]

ok i don't get that on every thread just threads that have replies and are older than the board upgrade

even annoucements have this error

[Gaffer]

ok WHAT THE HELL happened to all my members


http://forums.sg-online.net/memberlist.php

[Gaffer]

*mumbles something*

never mind i was looking threw the database and hit optimise in the user table and it fixed it

can someone do something with this thread like delete it or close it or something