
10-12-2012, 10:51 AM
|
 |
Senior Member
|
|
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by Hostboard
Fresh install on 4.2.0pl2
Ran the report after configuring it.
Report generated and posted but also got:
Code:
Post Check SQL:
SELECT mmpost.ipaddress, GROUP_CONCAT(DISTINCT mmpost.userid) AS userid, GROUP_CONCAT(DISTINCT mmpost.postid) AS postid, mmuser.usergroupid FROM mmpost LEFT JOIN mmuser ON mmuser.userid = mmpost.userid WHERE mmpost.dateline > 1349176946 AND mmpost.userid > 0 AND mmpost.ipaddress != '127.0.0.1' AND mmpost.ipaddress != '' GROUP BY mmpost.ipaddress HAVING COUNT(DISTINCT mmpost.userid) > 1 ORDER BY COUNT(DISTINCT mmpost.userid) DESC LIMIT 500
User Check SQL:
SELECT ipaddress, GROUP_CONCAT(DISTINCT userid) AS userid, usergroupid FROM mmuser WHERE joindate > 1347189746 AND userid > 0 AND ipaddress != '127.0.0.1' AND ipaddress != '' GROUP BY ipaddress HAVING COUNT(DISTINCT userid) > 1 ORDER BY COUNT(DISTINCT userid) DESC LIMIT 500
|
Where did you "get" that code? If you manually run the report that is completely normal debug info that is output.
|