[mtha]

Originally Posted by masons

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7

Originally Posted by toucan42

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,11332,11334,11336,11337,11338) GROUP BY post.postid

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 11:04:22 PM
Script : http://www.talkwhatever.com/showthread.php?p=11338
Referrer : http://www.talkwhatever.com/index.php
IP Address : 72.92.141.48
Username : admintw42
Classname : vb_database

For me this occurs when I turn ON postbit - assuming it is the double GROUP BY but not sure how to fix that in the product.

Do you have some other hack that replace the $postids value and add a GROUP BY post.postid ?


please check what's other hacsk using this hook location: showthread_query