Database Error

[Virtualshiner]

Hi
I tried to get onto my site today and I got a database error.
This is the email I get:

Database error in vBulletin 3.7.0 Beta 6:

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,
                        
                        
                        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
                        , '' AS field6, '' AS field7
                        
                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 editlog AS editlog ON(editlog.postid = post.postid)
                LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1)
                LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 1)
                LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
                        
                WHERE post.postid IN (0,178,179,181,183,184,191,199,202,215,224)
                ORDER BY post.dateline;

MySQL Error   : Table 'disneyma_vb.user' doesn't exist
Error Number  : 1146
Date          : Friday, March 14th 2008 @ 12:41:11 PM
Script        : http://disneymagiconline.com/vbulletin/showthread.php?t=46
Referrer      : 
IP Address    : 74.6.19.134
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Any help?

[Opserty]

Have you (un)installed a modification recently?

[Virtualshiner]

Sorry, I updated the code.
That was an old error.

[Opserty]

MySQL Error : Table 'disneyma_vb.user' doesn't exist

Your user table doesn't exist. Are you using a prefix for your tables or anything? Have you made any changes to your board or database recently?

[Virtualshiner]

The only thing that has happened is the board moved servers. It is with the same host etc

[Opserty]

Have you checked the the database (and table) exist? (Via. your hosting Control Panel)

[Virtualshiner]

Yep
I can see disneyma_vb

[Lynne]

And can you see the user table?

Have you tried to run repair/optimize on the table?

[Virtualshiner]

I dont know what you mean

I cant access anything on my site and I have looked to repair/optimize the table but I dont know where that is.

Edit: In the cPanel, I clicked Repair db but the error is still there.

[Lynne]

If you are in cPanel and using phpMyAdmin, can you see the user table?

Also, sometimes you need to repair the table more than once.