Try running the delete query separately?

that didnt work either ted i tried them both separately :(

what should i do now?

Okay on my 3rd try I was able to get this query to run
But I still couldn't get this to run
I keep getting this error
And if the Helpful answers are enabled then after clicking thumbs up, I get this error

Parse error: syntax error, unexpected '<' in /home/myaccount/public_html/helpfulanswers.php on line 522

The first error is because that query is really really old.

Should be: UPDATE helpfulpost SET goodrank = '', totalrank = ''

The second error is something in your script. Reupload.

thanks Ted, I was using the old query found inside the read me, your updated query fixed it :p

Great mod, nominated, we will use it in all our forums :)

Thanks for the heads up. I'll have to fix that!

Very nice! Installed and working marvelously! :up:

Update

Ted, I found a very annoying error with this mod that would cause double posts / duplicate posts of the first topic on a thread. Meaning the topic creators first post will be shown at the bottom of his post as the second post.

I will be sending you the details of this 'Error" in a PM.

Is this happening on EVERY post? Or just a few posts?

If it's across the board it's something in your particular install [otherwise this would obviously not be used by anyone] and more tricky to trace down. How much activity do you have in the system? Have you made any changes to the template or code beyond resetting the query?

P.S. I handle all support via the public posts so other users can chime in and benefit from answers.

No Ted, its not happening across the board, otherwise you would see it on other posts, only happens in a couple posts that probably got affected when I had accedentally turned on and off the top ten thing and then went on and clicked "thumbs up" on a few posts which gave me the error ("Parse error: syntax error, unexpected '<' in /home/myaccount/public_html/helpfulanswers.php on line 522"). So only those few posts are affected. Have I had the updated query then this probably wouldnt have happened. So I think it might be some kind of a query, table or something small gone bad(cache or database related?) that could be easily fixed, since the problem goes away if the mod is disabled. BTW. Did you login with the details and had a good look around yet?

P.S. Thats perfectly fine since others might be able to chime in, so we'll discuss it here. I just PMed you since I didn't want to share my boards URL or anything publicly. :)