Database error in vBulletin 3.8.1:

[barbarb]

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN visitormessage AS visitormessage ON (visitormessage.vmid = moderation.primaryid)
WHERE moderation.type = 'visitormessage';

MySQL Error : Can't find file: 'visitormessage' (errno: 2)
Error Number : 1017
Request Date : Wednesday, February 25th 2009 @ 06:43:11 PM
Error Date : Wednesday, February 25th 2009 @ 06:43:11 PM

from admin cp
and

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid


FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 6 AND postparsed.languageid = 19)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 6 AND sigparsed.languageid = 19)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (0,8720)
ORDER BY post.dateline;

MySQL Error : Can't find file: 'spamlog' (errno: 2)
Error Number : 1017
Request Date : Wednesday, February 25th 2009 @ 06:56:24 PM
Error Date : Wednesday, February 25th 2009 @ 06:56:25 PM

from forum

HOw i will fix it?Please help me!

[Jake Bunce]

It looks like your visitormessage and spamlog tables have gone missing. Try running these queries to recreate them:

DROP TABLE visitormessage;

CREATE TABLE visitormessage (
vmid INT UNSIGNED NOT NULL auto_increment,
userid INT UNSIGNED NOT NULL DEFAULT '0',
postuserid INT UNSIGNED NOT NULL DEFAULT '0',
postusername VARCHAR(100) NOT NULL DEFAULT '',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
state ENUM('visible','moderation','deleted') NOT NULL default 'visible',
title VARCHAR(255) NOT NULL DEFAULT '',
pagetext MEDIUMTEXT,
ipaddress INT UNSIGNED NOT NULL DEFAULT '0',
allowsmilie SMALLINT UNSIGNED NOT NULL DEFAULT '0',
reportthreadid INT UNSIGNED NOT NULL DEFAULT '0',
messageread SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (vmid),
KEY postuserid (postuserid, userid, state),
KEY userid (userid, dateline, state)
);

DROP TABLE spamlog;

CREATE TABLE spamlog (
postid INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (postid)
);

[barbarb]

Hello!

access Check Status: OK access Optimize Status: Table is already up to date adminhelp Check Status: OK adminhelp Optimize Status: Table is already up to date administrator Check Status: OK administrator Optimize Status: Table is already up to date adminlog Check Status: OK adminlog Optimize Status: Table is already up to date adminmessage Check Status: OK adminmessage Optimize Status: Table is already up to date adminutil Check Status: OK adminutil Optimize Status: Table is already up to date album Check Error: Can't find file: 'album' (errno: 2) album
albumpicture Check Error: Can't find file: 'albumpicture' (errno: 2) albumpicture
albumupdate Check Status: OK albumupdate Optimize Status: Table is already up to date announcement Check Status: OK announcement Optimize Status: Table is already up to date announcementread Check Status: OK announcementread Optimize Status: Table is already up to date attachment Check Status: OK attachment Optimize Status: Table is already up to date attachmentpermission Check Status: OK attachmentpermission Optimize Status: Table is already up to date attachmenttype Check Status: OK attachmenttype Optimize Status: Table is already up to date attachmentviews Check Status: OK attachmentviews Optimize Status: Table is already up to date avatar Check Status: OK avatar Optimize Status: Table is already up to date bbcode Check Status: OK bbcode Optimize Status: Table is already up to date bookmarksite Check Error: Can't find file: 'bookmarksite' (errno: 2) bookmarksite
calendar Check Status: OK calendar Optimize Status: Table is already up to date calendarcustomfield Check Status: OK calendarcustomfield Optimize Status: Table is already up to date calendarmoderator Check Status: OK calendarmoderator Optimize Status: Table is already up to date calendarpermission Check Status: OK calendarpermission Optimize Status: Table is already up to date color_groups Check Status: OK color_groups Optimize Status: Table is already up to date cron Check Status: OK cron Optimize Status: Table is already up to date cronlog Check Status: OK cronlog Optimize Status: Table is already up to date customavatar Check Status: OK customavatar Optimize Status: Table is already up to date customprofilepic Check Status: OK customprofilepic Optimize Status: Table is already up to date datastore Check Status: OK datastore Optimize Status: OK deletionlog Check Status: OK deletionlog Optimize Status: Table is already up to date discussion Check Status: OK discussion Optimize Status: Table is already up to date discussionread Check Status: OK discussionread Optimize Status: Table is already up to date editlog Check Status: OK editlog Optimize Status: Table is already up to date event Check Status: OK event Optimize Status: Table is already up to date externalcache Check Status: OK externalcache Optimize Status: Table is already up to date faq Check Status: OK faq Optimize Status: Table is already up to date forum Check Status: OK forum Optimize Status: Table is already up to date forumpermission Check Status: OK forumpermission Optimize Status: Table is already up to date forumprefixset Check Error: Can't find file: 'forumprefixset' (errno: 2) forumprefixset
forumread Check Status: OK forumread Optimize Status: Table is already up to date groupmessage Check Status: OK groupmessage Optimize Status: Table is already up to date groupmessage_hash Check Error: Can't find file: 'groupmessage_hash' (errno: 2) groupmessage_hash
groupread Check Status: OK groupread Optimize Status: Table is already up to date holiday Check Status: OK holiday Optimize Status: Table is already up to date humanverify Check Error: Can't find file: 'humanverify' (errno: 2) humanverify
hvanswer Check Error: Can't find file: 'hvanswer' (errno: 2) hvanswer
hvquestion Check Error: Can't find file: 'hvquestion' (errno: 2) hvquestion
icc_queue Check Status: OK icc_queue Optimize Status: Table is already up to date icon Check Status: OK icon Optimize Status: Table is already up to date imagecategory Check Status: OK imagecategory Optimize Status: Table is already up to date imagecategorypermission Check Status: OK imagecategorypermission Optimize Status: Table is already up to date infraction Check Status: OK infraction Optimize Status: Table is already up to date infractionban Check Status: OK infractionban Optimize Status: Table is already up to date infractiongroup Check Status: OK infractiongroup Optimize Status: Table is already up to date infractionlevel Check Status: OK infractionlevel Optimize Status: Table is already up to date language Check Status: OK language Optimize Status: Table is already up to date mailqueue Check Status: OK mailqueue Optimize Status: Table is already up to date moderation Check Status: OK moderation Optimize Status: Table is already up to date moderator Check Status: OK moderator Optimize Status: Table is already up to date moderatorlog Check Status: OK moderatorlog Optimize Status: Table is already up to date notice Check Error: Can't find file: 'notice' (errno: 2) notice
noticecriteria Check Error: Can't find file: 'noticecriteria' (errno: 2) noticecriteria
noticedismissed Check Status: OK noticedismissed Optimize Status: Table is already up to date passwordhistory Check Status: OK passwordhistory Optimize Status: Table is already up to date paymentapi Check Status: OK paymentapi Optimize Status: Table is already up to date paymentinfo Check Status: OK paymentinfo Optimize Status: Table is already up to date paymenttransaction Check Status: OK paymenttransaction Optimize Status: Table is already up to date phrase Check Status: OK phrase Optimize Status: Table is already up to date phrasetype Check Status: OK phrasetype Optimize Status: Table is already up to date picture Check Error: Can't find file: 'picture' (errno: 2) picture
picturecomment Check Error: Can't find file: 'picturecomment' (errno: 2) picturecomment
picturecomment_hash Check Error: Can't find file: 'picturecomment_hash' (errno: 2) picturecomment_hash
plugin Check Status: OK plugin Optimize Status: Table is already up to date pm Check Status: OK pm Optimize Status: Table is already up to date pmreceipt Check Status: OK pmreceipt Optimize Status: Table is already up to date pmtext Check Status: OK pmtext Optimize Status: Table is already up to date pmthrottle Check Status: OK pmthrottle Optimize Status: Table is already up to date podcast Check Status: OK podcast Optimize Status: Table is already up to date podcastitem Check Status: OK podcastitem Optimize Status: Table is already up to date poll Check Status: OK poll Optimize Status: Table is already up to date pollvote Check Status: OK pollvote Optimize Status: Table is already up to date post Check Status: OK post Optimize Status: Table is already up to date post_thanks Check Status: OK post_thanks Optimize Status: Table is already up to date postedithistory Check Error: Can't find file: 'postedithistory' (errno: 2) postedithistory
posthash Check Status: OK posthash Optimize Status: Table is already up to date postindex Check Status: OK postindex Optimize Status: Table is already up to date postlog Check Error: Can't find file: 'postlog' (errno: 2) postlog
postparsed Check Status: OK postparsed Optimize Status: Table is already up to date prefix Check Error: Can't find file: 'prefix' (errno: 2) prefix
prefixpermission Check Status: OK prefixpermission Optimize Status: Table is already up to date prefixset Check Error: Can't find file: 'prefixset' (errno: 2) prefixset
product Check Status: OK product Optimize Status: Table is already up to date productcode Check Status: OK productcode Optimize Status: Table is already up to date productdependency Check Status: OK productdependency Optimize Status: Table is already up to date profileblockprivacy Check Status: OK profileblockprivacy Optimize Status: Table is already up to date profilefield Check Status: OK profilefield Optimize Status: Table is already up to date profilefieldcategory Check Status: OK profilefieldcategory Optimize Status: Table is already up to date profilevisitor Check Error: Can't find file: 'profilevisitor' (errno: 2) profilevisitor
ranks Check Status: OK ranks Optimize Status: Table is already up to date reminder Check Status: OK reminder Optimize Status: Table is already up to date reputation Check Status: OK reputation Optimize Status: Table is already up to date reputationlevel Check Status: OK reputationlevel Optimize Status: Table is already up to date rssfeed Check Status: OK rssfeed Optimize Status: Table is already up to date rsslog Check Status: OK rsslog Optimize Status: Table is already up to date search Check Status: OK search Optimize Status: Table is already up to date setting Check Status: OK setting Optimize Status: Table is already up to date settinggroup Check Status: OK settinggroup Optimize Status: Table is already up to date sigparsed Check Status: OK sigparsed Optimize Status: Table is already up to date sigpic Check Status: OK sigpic Optimize Status: Table is already up to date smilie Check Status: OK smilie Optimize Status: Table is already up to date socialgroup Check Status: OK socialgroup Optimize Status: Table is already up to date socialgroupcategory Check Status: OK socialgroupcategory Optimize Status: Table is already up to date socialgroupicon Check Status: OK socialgroupicon Optimize Status: Table is already up to date socialgroupmember Check Error: Can't find file: 'socialgroupmember' (errno: 2) socialgroupmember
socialgrouppicture Check Error: Can't find file: 'socialgrouppicture' (errno: 2) socialgrouppicture
spamlog Check Error: Can't find file: 'spamlog' (errno: 2) spamlog
stats Check Status: OK stats Optimize Status: Table is already up to date strikes Check Status: OK strikes Optimize Status: Table is already up to date style Check Status: OK style Optimize Status: Table is already up to date subscribediscussion Check Status: OK subscribediscussion Optimize Status: Table is already up to date subscribeevent Check Status: OK subscribeevent Optimize Status: Table is already up to date subscribeforum Check Status: OK subscribeforum Optimize Status: Table is already up to date subscribegroup Check Status: OK subscribegroup Optimize Status: Table is already up to date subscribethread Check Status: OK subscribethread Optimize Status: Table is already up to date subscription Check Status: OK subscription Optimize Status: Table is already up to date subscriptionlog Check Status: OK subscriptionlog Optimize Status: Table is already up to date subscriptionpermission Check Status: OK subscriptionpermission Optimize Status: Table is already up to date tachyforumcounter Check Error: Can't find file: 'tachyforumcounter' (errno: 2) tachyforumcounter
tachyforumpost Check Status: OK tachyforumpost Optimize Status: Table is already up to date tachythreadcounter Check Error: Can't find file: 'tachythreadcounter' (errno: 2) tachythreadcounter
tachythreadpost Check Status: OK tachythreadpost Optimize Status: Table is already up to date tag Check Error: Can't find file: 'tag' (errno: 2) tag
tagsearch Check Error: Can't find file: 'tagsearch' (errno: 2) tagsearch
tagthread Check Error: Can't find file: 'tagthread' (errno: 2) tagthread
template Check Status: OK template Optimize Status: Table is already up to date templatehistory Check Status: OK templatehistory Optimize Status: Table is already up to date thread Check Status: OK thread Optimize Status: Table is already up to date threadrate Check Status: OK threadrate Optimize Status: Table is already up to date threadread Check Status: OK threadread Optimize Status: Table is already up to date threadredirect Check Status: OK threadredirect Optimize Status: Table is already up to date threadviews Check Status: OK threadviews Optimize Status: Table is already up to date upgradelog Check Status: OK upgradelog Optimize Status: Table is already up to date user Check Status: OK user Optimize Status: Table is already up to date useractivation Check Status: OK useractivation Optimize Status: Table is already up to date userban Check Status: OK userban Optimize Status: Table is already up to date userchangelog Check Error: Can't find file: 'userchangelog' (errno: 2) userchangelog
usercss Check Error: Can't find file: 'usercss' (errno: 2) usercss
usercsscache Check Error: Can't find file: 'usercsscache' (errno: 2) usercsscache
userfield Check Status: OK userfield Optimize Status: Table is already up to date usergroup Check Status: OK usergroup Optimize Status: Table is already up to date usergroupleader Check Status: OK usergroupleader Optimize Status: Table is already up to date usergrouprequest Check Status: OK usergrouprequest Optimize Status: Table is already up to date userlist Check Status: OK userlist Optimize Status: Table is already up to date usernote Check Status: OK usernote Optimize Status: Table is already up to date userpromotion Check Status: OK userpromotion Optimize Status: Table is already up to date usertextfield Check Status: OK usertextfield Optimize Status: Table is already up to date usertitle Check Status: OK usertitle Optimize Status: Table is already up to date visitormessage Check Error: Can't find file: 'visitormessage' (errno: 2) visitormessage
visitormessage_hash Check Error: Can't find file: 'visitormessage_hash' (errno: 2) visitormessage_hash
word Check Status: OK word Optimize Status: Table is already up to date




i try to optimization and these are missing tables i think it is from hosting.
Thanks for help

[Jake Bunce]

You are missing a lot of tables. You need to restore a database backup from before you had this problem. If you don't have a recent backup then you should ask your host if they have one.