database deletation

[Dans34]

hi,

is there a problem with mysql  , i was on my forum i refreshed the page and it says

mySQL error: 1146
Table 'trionite_forum.mybb_users' doesn't exist
Query: SELECT u.*, f.*, COUNT(pms.pmid) AS pms_total, SUM(IF(pms.dateline>u.lastvisit AND pms.folder='1','1','0')) AS pms_new, SUM(IF(pms.status='0' AND pms.folder='1','1','0')) AS pms_unread, b.dateline AS bandate, b.lifted AS banlifted, b.oldgroup AS banoldgroup FROM mybb_users u LEFT JOIN mybb_privatemessages pms ON (pms.uid=u.uid) LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_banned b ON (b.uid=u.uid) WHERE u.uid='1' GROUP BY u.uid

its like the table has just been deleted  (also i didnt have a backup , do freepgs.com have a backup i could use ?)

[Dans34]

my website url is freepgs.com/dans34

the affected forum  url is freepgs.com/dans34/trionite/forum

[admin]

Please try to repair the table via phpMyAdmin (and/or check if the table exists there).

[Dans34]

the table is missing from the database

how do i repair the table ?

[webzone (archived)]

the table is missing from the database

how do i repair the table ?

You can't repair a missing table. You need to restore it from a backup, if you have any.

[Dans34]

thats the problem , i dont

do you know why a table just went missing ?

[sixthcrusifix]

thats the problem , i dont

do you know why a table just went missing ?

best I can say is, crap happens. you must have a basic back up didn't you install forum software?

[Dans34]

i have a backup of the forum  files but not the mysql

but it dosnt matter now as i have reinstalled anyway

thanks for all your help

[admin]

Login to phpMyAdmin, see if the table is listed but has crashed.

If you see the table, click the checkbox and select "Repair Table" option and click "Go"

If you do not see the table listed, you must restore it as the other user had suggested.  Be sure your forum software is using the correct prefix for the tables that exist in your database.

Thank you,
FreePgs.com Admin