You may have edited my hack over another hack. The table 'award' has nothing to do with this hack.

I have this hack installed as well:

hxxp://www.vbulletin.org/forum/showthread.php?t=61108

I don't understand how yours could be installed 'over' this one. I had both installed and working perfectly before this upgrade, now I'm stranded with a shut board. :(

I have tried uninstalling the Thank You hack and reinstalling it from scratch (with the fix you added above). Result stays the same. Clicking on any post gives the error above. Creating a new post, clicking on submit gives the error, but the post DOES appear in the forum if I refresh the forum page, but clicking on the post goes back to this error.

Could you please take a look at the details of the awards hacks and determine if your installer is destroying anything unintentionally. I can't be the only one with both these hacks installed, and it's bound to create a compatibility problem for others too.

Please assist me further.

thanks you

-snake

I took a look. I think the best would be to get a fresh functions_showthread.php and do both of these hacks file edits. It seems that this error your getting is comming from the award not the thanks.

Nice work Abe. My members love the addition.

Glad to hear that. Just dont forget to click 'install'. Also, the best part about this update is the speed increase when viewing threads. On my forum, I cut the queries down from about 47 to about 15. The speed the page was created went down like 60-70%!

on doing so the thanked_postbit no longer shows, under the thanked post.

You have to edit in 3 spots. Make sure you did all 3.

Ok, I tried copying over a fresh copy and making the changes as specified, but it does not help at all, as I am still getting the same error each time.

I appreciate your help, but could you please suggest anything else I could try. I'm getting really despirate now :( I wish I had the php knowledge to be able to be of more help, but I don't know how to do much more than is specfied in the instructions.

Please help.

thank you

-snake

I hope this helps. Let me disect your error.

Invalid SQL: SELECT * FROM award AS award ORDER BY awardid ASC
mysql error: Unknown column 'awardid' in 'order clause'

Unknown column 'awardid' in 'order clause' can only mean that there is no column in the award table that is called awardid.

This seems to be a problem with the award system and you should try re-installing it or something like that. I'm sure if you remove the award hack code from the file you shouldn't get any errors. As you saw when you removed all of my hack you were still getting errors.

If you have phpmyadmin, I can look at your database at see what is missing fromt he award system. You'd have to send me a PM with the info on how to get in.

Other wise, there is nothing I can do.

thanks