Database problems after uninstalling a plugin

[Sherrie]

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 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]

remove any files related to your un-installed hacks from /includes/xml

[Sherrie]

Thanks, I just did that but still no good.

[snakes1100]

Remove any template changes related to the post thank you hack.

Check the postbit or postbit_legacy template.

[Sherrie]

No templates have been edited.

[Lynne]

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]

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.