[Abe1]

Originally Posted by BANDiT600

I got this error when I push the link "Find all posts groaned by ..." on profile page in Statistics.

Database error in vBulletin 3.7.2:

Invalid SQL:

                        SELECT post_groan.postid AS postid
                        FROM post_groan AS post_groan
                        LEFT JOIN post AS post USING (postid)
                        INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
                        WHERE post_thanks.userid = 2055
                                AND thread.forumid IN(1,40,80,2,8,59,78,69,36,44,41,23,74,76,77,71,72,75,6,34,35,7,60,28,54,55,56,61,63,62,64,20,73,19,21,25,26,79,46,17,67,57,58,70,68)
                        ORDER BY post.dateline DESC
                        LIMIT 600;

MySQL Error   : Unknown column 'post_thanks.userid' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, October 23rd 2008 @ 02:03:50 AM
Error Date    : Thursday, October 23rd 2008 @ 02:03:50 AM
Script        : http://site.com/post_groan.php?do=findgroans_user_gave&u=2055
Referrer      : http://site.com/member.php?u=2055
IP Address    : ***.***.***.***
Username      : BANDiT600
Classname     : vB_Database
MySQL Version : 5.0.51-log

Please download the latest zip file and over right post_groan.php in the root dir.