Mysql error number: 1146 "_forum.user" doesnt exist

[Jinovich]

I keep on getting this error message, what puzzles me is that the forum was working absolutly perfectly unti a few days ago

I have tried repairing the tables in Cpanel and using tools.php mysql repair function but still doesnt work.



Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
session.location, IF(displaygroupid=0, user.usergroupid,
displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1123751097
ORDER BY username ASC

mysql error: Table 'hxforus_forum.user' doesn't exist

mysql error number: 1146

[Steve Machol]

This means you aare missing your user table. What does the database show?

[Jinovich]

These are my all my tables in the database 2 of the tables listed below are from a Hack all in all totalling up to 83 tables of which 81 is the original Vbulletin tables.



access
adminhelp
administrator
adminlog
adminutil
announcement
attachment
attachmenttype
attachmentviews
avatar
bbcode
calendar
calendarcustomfield
calendarmoderator
calendarpermission
cpsession
cron
cronlog
customavatar
customprofilepic
datastore
deletionlog
editlog
event
faq
forumpermission
holiday
icon
imagecategory
imagecategorypermission
language
mailqueue
moderation
moderator
moderatorlog
passwordhistory
phrase
phrasetype
pm
pmreceipt
pmtext
poll
pollvote
posthash
postindex
post_parsed
profilefield
ranks
regimage
reminder
reputation
reputationlevel
search
session
setting
settinggroup
smilie
stats
strikes
style
subscribeevent
subscribeforum
subscribethread
subscription
subscriptionlog
template
thread
threadrate
threadviews
upgradelog
useractivation
userban
userfield
usergroup
usergroupleader
usergrouprequest
usernote
userpromotion
usertextfield
usertitle
vbchat_datastore
vbchat_store
word

[Steve Machol]

You are missing the user table. Also the default vB3 has 84 tables, not 82 - and a couple of those tables are from hacks you've installed.

Therefore it looks like you are missing about 5 vB tables. Unfortunately there is no way to fix this with the current database. You will need to restore a backup of your database.