Someone Please help me!, My forum database crashed!
 

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 :(

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
, save and upload/overwrite

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

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.

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 :(

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

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

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.

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

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

Follow the instructions in the previous post.

No i didn't even think about touching my database.
And yes i did what you told me: I uninstalled the plugins, removed ALL the xml and PHP files
and added the extra // quotes at the beginning <?php but still no luck.
Please tell me if im doing this wrong.
Thanks

Did you remove the templates & phrases that it added as well?

No.
Ithink it removes it automatically?
Seeming as when i installed it, it created the templates itself

You need to check the system, that is why i asked, the hack isnt designed for 3.7.0 and may not install/uninstall correctly itself.

Ohh, Isee but i thought it would be Ok since it instaled in product manager.
Could you please give me a list of things or templates i should check , so i may do it right away, as my forum is almost useless if i dont get it done.
Also thanks alot for your help and quick reply

Edit the product in something like editplus or wordpad, i dont have a list, its in the product file.

What do you mean by edit the product?:confused:
As in vbulletin product file or award product file.
Can you please explain it a bit more better please
Thanks

edit the product file for the hack you used, what other product would there be to edit?

Ok if you mean the product file that you use to upload into vbulletin plugin manager, i found it.
I see a long list of codes but what do i edit???
Il wait for a reply before i edit, incase i mess anything else up =/

edit the file to find out what it added to your forum, templates, phrases etc.

Ok i found a list of all the phrases it adds, heres a quick example of what it says
<phrasetype name="GLOBAL" fieldname="global">
followed by a list of award phrases
where do i go to edit my vbulletin phrases?

In you admincp under the phrase manager, do a search for the word "award", would be easier.

Ohh, so when i search the word "award" all phrases under it would come out...
Ill try it now, ill get back to you in 15 minutes
Thanks


--------------- Added [DATE]1211892713[/DATE] at [TIME]1211892713[/TIME] ---------------

No all i found were the awards of my previous plugin :(
i dont understand... i uninstalled EVERYTHING but i still have database error

Your previous plugin, what are you talking about exactly?

Did you check the templates as well, something is still calling for the award system on your site, that is why your getting the error.

And yes, i had a previous awards mod
found here: http://www.vbnova.com/showthread.php?t=172

So its not the database thats calling it, its something on the forum...
Could i send you the product file, so you could have a quick look and tell me what needs to be done, Itl be helpful

Ive told you already in the post, you need to make sure everything that has to do with either of those hacks are removed, that includes files that you ftp'd php/xml, phrases & templates changes or additions.

Ok im going to go through all my files now, and make sure theyre all gone

--------------- Added [DATE]1211900149[/DATE] at [TIME]1211900149[/TIME] ---------------

All of them are gone but still same issue.
i might be wondering if its my previous version aswell
because i had them both installed
i found the phrase for the previous award, where do i go to delete them?

--------------- Added [DATE]1211903528[/DATE] at [TIME]1211903528[/TIME] ---------------

I found an awards template, but how do i delete templates?