Cannot Delete Threads Any More. Big Problem. Please Help me out.

[BigJohnson]

Ok I am not to sure what my last couple of hacks I installed were but Now I try to delete my threads and I cannot. This is a big problem for me due to the amount of space I have left on my server. When i go to a post and i click on EDIT button on the first post of the thread. There is a box above saying do you want to delete this thread. And then you check the box and click UPDATE or what ever. I get this error after updating

Database error in vBulletin 2.2.5:

Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0) AND postid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

I am not to sure what it means. I went to my PHPMYADMIN and went to searchindex and I just see 3 columns that say wordid, postid, and intitle. I am not to sure what the error is but does anyone think they can help me out. I believe my last hack i installed was the Custom Post Prefixes But i deleted it to see if that was the problem and it wasn't. PLease help me out someone. I am desparate for your skill. Thanks.

[Xenon]

perhaps your host has upgraded to php42x
vb225 isn't compatible with this version, you should upgrade to vb228.

also because of some security fixes you should really upgrade

[BigJohnson]

Nope this is not the propblem. I am running ona 2.2.5 and I installed 2.2.4 just to make sure and that works fine when i make a post and delete. IT has to be something else. Can someone maybe help me out please. Or can somoene tell me how the process of deletin a thread goes so I can fix the problem myself maybe.

This is what i have so far. When u click edit and delete it says u have an SQL error in your edit.php

When i go to admin options down below and delete thread there it says there is a sql error but for the postings.php file. What is up.

[Bison]

Make a Backup of those two files and replace them with the original files ...

if the delete process works, there might be a compatibility problem with a applied hack. Compare the two files to see the diference between the two files. Re-appy each change you made to the old version (one at a time and save) to the original version to locate the source error.

Test each sequence (creating test threads to delete) untill you find the root of your problem ...

Hope this helps! :)

[BigJohnson]

Nope because I still get this error when i replace the files. Damn. This sucks

[BigJohnson]

I have fixed the problem. Thanks for your help.