Log in

View Full Version : Mysql Error


goshalim
03-17-2010, 05:32 AM
Hi,

Since yesterday when iam in the admincp and trying to delete a user this message is coming and i cant do anything .

Any ideas please what is this and how can be fixed



Invalid SQL:

DELETE FROM fnewgroupread
WHERE userid = 3938;

MySQL Error : Table 'canarybr_canary.fnewgroupread' doesn't exist
Error Number : 1146
Request Date : Wednesday, March 17th 2010 @ 01:29:18 AM
Error Date : Wednesday, March 17th 2010 @ 01:29:18 AM
Script : http://canarybreeder.net/up/forum/admincp/user.php?do=kill
Referrer : http://canarybreeder.net/up/forum/admincp/user.php?do=remove&u=3938

Speysider
03-17-2010, 07:41 AM
canarybr_canary.fnewgroupread
Clearly states that this table does not exist anywhere on your forum's database.

You will need to use phpMyAdmin to create the fnewgroupread table in your forum db.

goshalim
03-17-2010, 08:04 AM
Its not the only one problem that i have.

Since last night when i have upload new clear original files of Vb ( beacuse my web site was hacked ) some function are not working showing that there is error in sql as above.

Why is that ?

Marco van Herwaarden
03-17-2010, 10:53 AM
Most likely caused by an installed modification, and i guess you did not re-upload all the files needed for these modifications.

Turn off the plugin system until you find the culprit.

goshalim
03-17-2010, 01:06 PM
Hi MArco

I havent uploaded any new modificaition . The only thing i did was to uploald all Vb files to public_html path.

Nothing else.

Exept from the above also the social groups are not working at all and also recieving hundreds of e-mail of databease error

Shall i try to re upload them all again !!!

Marco van Herwaarden
03-20-2010, 12:37 PM
You will need to either re-install the modification or completly remove it.

goshalim
03-20-2010, 05:46 PM
exellent , working now , thanks marco