Bug SQL Errors

[KrUsTyX]

I received multiple SQL errors by email

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT postid
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
WHERE post.userid = 38470
AND post.post_thanks_amount != 0
AND thread.forumid IN(328,226,237,239,356,247,357,252,358,254,359,255,360,327,361,269,420,270,363,271,364,257,365,287,366,235,273,368,296,369,291,370,293,371,292,372,294,373,227,240,289,241,290,375,305,377,262,244,304,228,298,253,260,272,250,256,355,225,238,302,374,265,286,288,230,274,261,245,246,249,380,381,383,395,396,384,397,398,385,399,400,386,401,402,387,403,404,388,405,406,390,407,408,389,409,410,393,413,414,391,411,412,419,382,416,415,417,429,418,394,392)
ORDER BY post.dateline DESC
LIMIT 1000;

MySQL Error : Unknown column 'post.post_thanks_amount' in 'where clause'
Error Number : 1054
Request Date : Sunday, April 7th 2013 @ 08:59:07 AM
Error Date : Sunday, April 7th 2013 @ 08:59:07 AM

 

[KrUsTyX]

http://www.vwquebec.ca/forum/post_thanks.php?do=findthanks&u=38470

 

[Ozzy47]

That 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, after doing the import, if you un-installed it.

 

[KrUsTyX]

Yeah, i just realized that... i uninstalled this 6 months ago I think... i guess it didnt uninstall properly... sorry about that

 

[Ozzy47]

Not a problem, glad to help.