PDA

View Full Version : Data base error


jamez
Tue 12th Jun '01, 11:14am
Does any know how to fix this error?

ok I guess I need to talk to my host provider as everyone says.


<!-- Database error in vBulletin: Invalid SQL:
SELECT
session.userid AS sessionuserid,
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
LEFT JOIN session ON (session.userid = user.userid
AND session.userid > 0

AND session.lastactivity>992353477)
WHERE
post.postid IN (0,111,117)
ORDER BY dateline

mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Tuesday 12th of June 2001 09:59:37 AM
Script: /showthread.php?s=&threadid=69
Referer: http://gardenforum.utahgardener.com/forumdisplay.php?s=&forumid=19
-->
</td></tr></table>
<p>There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:info@utahgardener.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

jamez
Tue 12th Jun '01, 2:28pm
I fixed my session table problem. I backed up the members info. Then deleted the newest members (only 2) before that database went bad. Added the 2 members back to the forums.
Works fine now..