Someone Please help me!, My forum database crashed!

[richards112]

Someone who knows about php MySQL codes please help me!
I have just downloaded and installed a awards mod, can be found here:
https://vborg.vbsupport.ru/showthrea...94#post1532394

and i dont think i installed it right, and when i click on my member profiles this error code comes up

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT award_user.userawardid AS userawardid, award_user.userid AS userid, award_user.awardid AS awardid, award_user.dateline AS dateline, award_admin.title AS title, award_admin.description AS description, award_admin.image AS pic
FROM award_user AS award_user
LEFT JOIN award_admin AS award_admin ON ( award_user.awardid = award_admin.awardid )
WHERE award_user.userid = 1;

MySQL Error : Table 'ninchat.award_user' doesn't exist
Error Number : 1146


Any idea what to do? Please help! as i cannot use my forum until this is fixed

[veenuisthebest]

1. First, why did you installed a 3.5 mod directly in your 3.7 main board ??
2. Are you able to login to admincp ?? If yes, uninstall the awards system and delete all files that you just uploaded through FTP !!
3. If no, open your includes/config.php, and enter this right after <?php

PHP Code:

define('DISABLE_HOOKS', true); 


, save and upload/overwrite

[richards112]

Yes i have done that thank you so much!
but do ou please have any idea on how i may get my mods back???
Thanks

[snakes1100]

The error states the award_user dont exist, uninstall or re-install the hack that relates to the award system your using, you might have to manually remove any phrases the hack added, also make sure that you remove any xml file you might of uploaded to the /includes directory as well for that hack.

After doing so, remove the line you added to config.php of comment it out by adding // in front of it and re-save.

[richards112]

Thanks for quick reply.

And also, when you say phrases that the mod added.. do you mean in my database or config.php, because hen i read the installation, it says that it adds tables to the databaseAnd yes, i removed absolutely all xml and php files i uploaded through FTP and removed it from product manager
but i still get database error!
Any ideas please

[WEBDosser]

don't you have a backup of your site & database?.. if you do then use that.

[richards112]

No i dont, i backed it up, but that was when i was installing the mod
If only i backed it up 5 minutes earlier

[snakes1100]

Do as i suggested, that is a fixable issue with your db and there is no need to reload the database from a backup, the issue is related to the hack that you tried to install.

[richards112]

Ok, so i dont need to edit none of the tables in my database?
Just my config.php?

[snakes1100]

I never posted anything about editing a db table and you shouldnt be doing so anyway.

Follow the instructions in the previous post.