hi,
is there a problem with mysql , i was on my forum i refreshed the page and it says
QuotemySQL 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 ?)
my website url is freepgs.com/dans34
the affected forum url is freepgs.com/dans34/trionite/forum
Please try to repair the table via phpMyAdmin (and/or check if the table exists there).
the table is missing from the database
how do i repair the table ?
Quotethe 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.
thats the problem , i dont
do you know why a table just went missing ?
Quote from: Dans34 on April 21, 2006, 07:30:16 AM
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?
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
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