UBB.Developers Forums UBB.threads 7 Development How Do I? SQL Errors: Table doesn't exist

Out of the blue, our message board began displaying this error message when a user clicks "Post" in a forum" or actually makes a post. The post goes through successfully, but this error continues to show up:

SQL ERROR: Unable to do_query: SELECT B_Hostname,B_Uid,B_Reason FROM w3t_Banned WHERE B_Uid='4' OR '68.40.200.13' LIKE B_Hostname
Table 'passport.w3t_banned' doesn't exist

I tried repairing the tables but it doesn't seem to have helped.

Our board is at http://www.passporterboards.com and we're running UBB threads 6.3.2.

Does anyone have any ideas?

Thanks so much!

sounds like you have a froaked table try running

REPAIR TABLE w3t_Banned

in your admin menu SQL command box OR better use phpMyAdmin to run that command.

Thank you, scroungr, but running that SQL command didn't effect anything. I closed the forums, input the command, and was told that 3 rows were affected. I opened the forums back up and tried to post, and I get the same exact error message:

SQL ERROR: Unable to do_query: SELECT B_Hostname,B_Uid,B_Reason FROM w3t_Banned WHERE B_Uid='4' OR '68.40.200.13' LIKE B_Hostname
Table 'passport.w3t_banned' doesn't exist

Any other ideas?

Thanks,

Hmmm and you nor your host made any changes recently?

IF the banned table is really missing - you'll have to recreate it (and you won't have a record of anyone you banned before).

But this query will recreate the table:

CREATE TABLE w3t_Banned(
B_Uid INT(9) UNSIGNED NOT NULL,
B_Hostname varchar(60) NOT NULL,
B_Reason text
)";

Thanks Josh -- when I tried the SQL command I got this error:

SQL ERROR: Unable to do_query: CREATE TABLE w3t_Banned( B_Uid INT(9) UNSIGNED NOT NULL, B_Hostname varchar(60) NOT NULL, B_Reason text )";
You have an error in your SQL syntax near '"; ' at line 5 row(s) affected by your query.

I copied and pasted it from your message. Not sure what could be wrong with the syntax.

I think you need to drop the "; off the end of that query.

yeah so command should be

CREATE TABLE w3t_Banned( B_Uid INT(9) UNSIGNED NOT NULL, B_Hostname varchar(60) NOT NULL, B_Reason text )

Yes, my bad. Copied it from the createtable.php script.

Thank you so much! The error is now gone.

so somehow the Banned Table got deleted? Hmmm sounds like maybe a future MYSQL problem or someone hit the wrong key