quick reply is throwing a mysql error, but a standard reply isn't..

[andrewjs18]

this is what my host, host monster, sent me in an email after I opened up a ticket with them:

In reviewing the error and the debug information from your mybb forum, I discovered that two of your tables appear to be having a problem:


mybb_modtools & mybb_threadsubscriptions appear to be empty when they shouldn't be.

here are the queries that are attempting to execute which i believe are causing the mysql problem:



#18 - Select Query
SELECT tid, name, type FROM mybb_modtools WHERE CONCAT(',',forums,',') LIKE '%,6,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums=''
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 6.48498535156E-5

#19 - Select Query
SELECT tid FROM mybb_threadsubscriptions WHERE tid='4' AND uid='7' LIMIT 1
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 6.38961791992E-5

Please check with the mybb support and see if you can get a copy of the two tables with default data intact. That should resolve the database problem.

---

You have the wrong password for your mysql database defined, in your case, you have not defined one.

Open ./inc/config.php and edit the entry for $config['database']['password'] to be your database password.

that is not true..the password is defined in inc/config.php

I just checked.