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