[mgcom]

Originally Posted by TurkYasam

Thanks for this great hack..
After succesfull instalition and usergroup permissions set up, I wanted to check it on frond-end but I got this error..

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT *, COUNT(marketid) FROM market_transactions
    GROUP BY marketid ORDER BY COUNT( marketid ) DESC LIMIT 0 , 1;

MySQL Error   : Invalid use of group function
Error Number  : 1111

I was also wondering how to integrate the point market system with vBActivity v1/ Pro

Regards..

I am getting the same error

Invalid SQL:
SELECT *, COUNT(marketid) FROM market_transactions
GROUP BY marketid ORDER BY COUNT( marketid ) DESC LIMIT 0 , 1;

MySQL Error : Invalid use of group function
Error Number : 1111
Request Date : Wednesday, April 21st 2010 @ 10:00:31 PM
Error Date : Wednesday, April 21st 2010 @ 10:00:31 PM
Script : http://www.dyp.ie/forums/market.php
Referrer : http://www.dyp.ie/forums/market.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 4.1.22-Max-log