help getting this error (just came on my site after someone did somin)

[honcho]

getting this error can someone tell me what to do to fix it

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(*)
FROM phpbb_userlist AS userlist
LEFT JOIN phpbb_userlist AS userlist_ignore ON (userlist_ignore.userid = 1 AND userlist_ignore.relationid = userlist.userid AND userlist_ignore.type = 'ignore')
WHERE userlist.relationid = 1
AND userlist.friend = 'pending' AND userlist_ignore.type IS NULL;

MySQL Error : Table 'web82-honcho.phpbb_userlist' doesn't exist
Error Number : 1146
Request Date : Saturday, November 15th 2008 @ 06:22:05 PM
Error Date : Saturday, November 15th 2008 @ 06:22:05 PM
Script :
Referrer :
IP Address :
Username :
Classname : vb_database
MySQL Version : 5.0.67-community

[Lynne]

Does the table userlist exist? Look in your list of tables in maintenance > repair/optimize tables and see if it's listed. If not, you will need to add it. I don't know what that query is, you may have to ask at vb.com for it.

[honcho]

its not there lynne but i have a bk up of my site in july where would ir be in there to reupload it

[Lynne]

You may use a backup, but then you will lose all your posts since then. I think the best thing to do is get the query to run to make a new userlist table. All it is is the list of buddies and ignored users for everyone. It's not a big loss if they have to redo that. I think it's better to have them redo that than lose all the posts since then.

[honcho]

yeah that sounds better to me how would i go about this please im new to all this

[Lynne]

You need to get the query to recreate that table. I don't know what it is. You will need to ask over at vb.com.

[honcho]

ok many thanx for your help

[honcho]

ok i have had no joy over there and now i have to reinstall vb and transfer databases so site will work again anyone help me with this as its a bit out of my league to be honest

i know its a bit cheeky to ask in here for this massive task but i have no other option my host have tryed to restore my site and this is what they have said ........

Thanks for your reply.

If you are still having some problems with the forum I would advise reinstalling vBulletin and importing the database that has been restored which should fix the problem for you.

You need to make sure you take a backup of the database before you reinstall the forum, either through vBulletin itself or from the database import/export tool in the eXtend control panel.

many thanx in advance

[Lynne]

Did you try putting in a support ticket and asking for the query to recreate that table? Or did you make a thread asking for the query? How long did you wait for an answer? I know they go through and try to answer every thread over there.

[honcho]

ok i decided ill just reinstall vb and import posts and users daya

how would i go about this any one know any gd posts for tutorials on how to install vb

pdf format ect ect

also what areas do i need to bk up for

1. posts
2. users

so i dont loose this info ,

sorry to be a pain if this already posted but i cant find it and am totaly new to this vb stuff
but am willing to learn as it will save me lots of hassle in long ru