Bug DB Errors everyday

[truckmount]

Here is the error i pretty much get on a daily basis couple x a day:
Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT postid
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
WHERE post.userid = 3
AND post.post_thanks_amount != 0
AND thread.forumid IN(154,118,140,23,141,104,89,28,133,2,79,120,74,137,81,77,10,103,121,139,138,122,155,76,12,88,82,43,44,73,42,45,46,68,48,40,50,49,14,4,87,8,128,153,142,143,145,146,144,147,148,149,150,151,152,15,11,111,59,61,129,115,17,93,5,30,69,21,99,29,35)
ORDER BY post.dateline DESC
LIMIT 1500;

MySQL Error : Unknown column 'post.post_thanks_amount' in 'where clause'
Error Number : 1054
Request Date : Tuesday, December 20th 2011 @ 03:44:52 PM
Error Date : Tuesday, December 20th 2011 @ 03:44:52 PM
Script : http://www.truckmountforums.com/post_thanks.php?do=findthanks&u=3
Referrer :
IP Address : 66.249.71.17
Username : Unregistered
Classname : vB_Database
MySQL Version :

 

[Ozzy47]

That looks like it is from the, Post Thanks mod from Abe, do you have that mod installed also?

Or did you have it installed previously, if so make sure you removed all the files that came with that product, if you un-installed it.

 

[truckmount]

Ah ok, yea i had it before this mod and imported all the likes etc from that plugin.

 

[Ozzy47]

Ok I thought so, you just need to remove the files from that product, and the emails should stop.

 

[truckmount]

I think that fixed it, BTW I see there is a Test the custom button feature, is this feature already enabled in the Likes system so maybe I can put something custom in there ? I have had a lot of requests for a LOL to be one of the options haha

 

[Ozzy47]

Cool, glad it worked. you can check out the manual for the product here, it should answer any questions you have:

DragonByte Tech Documentation