Log in

View Full Version : Database problems after uninstalling a plugin


Sherrie
03-08-2009, 11:07 PM
Hello

I am having problems with censorship not working and not being able to turn my forum off. Anyway I tried to troubleshoot this by uninstalling a few plugins I had installed and upon uninstalling the post thank you hack (https://vborg.vbsupport.ru/showthread.php?t=165673) I can no longer view threads and am now getting a database error when trying to do so. I have posted in the appropriate thread for this product but the coder doesn't appear to be active for the last couple of weeks so thought perhaps I should post here in case anyone knows how I could fix this:

Invalid SQL:
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0,185459,185460,185477,185488,185509,185522) ORDER BY post_thanks.username ASC;

I would really appreciate it any help.

snakes1100
03-08-2009, 11:23 PM
remove any files related to your un-installed hacks from /includes/xml

Sherrie
03-08-2009, 11:32 PM
Thanks, I just did that but still no good.

snakes1100
03-08-2009, 11:34 PM
Remove any template changes related to the post thank you hack.

Check the postbit or postbit_legacy template.

Sherrie
03-08-2009, 11:43 PM
No templates have been edited.

Lynne
03-09-2009, 12:27 AM
How about posting the full database error.

Also, go read the install instructions for that hack and then undo everything they say to do - all files to edit or upload, all template edit, everything.

Sherrie
03-09-2009, 12:53 AM
Thanks :)

I have restored my database for now as it had been down for a few hours but will need to try again soon as I am still experiencing the problems that prompted me to uninstall everything.