Press this button to manually run the report not working:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

I left them at the defaults:

How Many Days Back To Check? (Posts) = 7
Enter the number of days of previous posts to search for this report. Set to 0 to disable this report.

How Many Days Back To Check? (Users) = 30
Enter the number of days of previous registrations to search for this report. Set to 0 to disable this report.

Records Limit = 500
This is the absolute max number of IP Addresses that will be returned in any report. Even on large forums this usually would not be a very large number, this limit is like a safety check- if your reports return anywhere near this limit there are probably bigger issues.

Note that this was a manual run. The full output says this:

Thank you very much, works great with vBulletin 4.1.12 Patch Level 1 :)

What values are you setting for days back? Try setting them low- really low, like 1 and 1, and see if it works. It will give me an idea of the issue.

Are you familiar with running manual SQL queries if I gave you a couple to run?

Please "Mark It as Installed" :up:

Yes. Fire away.

#1)

That is the code for the 7 day look back of the posts table. You will have to put a table prefix in front of "post" if you use them.

#2)

That's the 30 day look back of the User table.

I'm curious if either of these produce any results (return any rows.)?

If they don't, let me know. if they do maybe you can PM me what it returns, you can edit/mess up the IP addresses for privacy if need be.

SELECT ipaddress, GROUP_CONCAT(DISTINCT userid) AS userid, GROUP_CONCAT(DISTINCT postid) AS postid
FROM post
WHERE dateline > 1335925435 AND userid > 0 AND ipaddress != ''
GROUP BY ipaddress
HAVING COUNT(DISTINCT userid) > 1
ORDER BY COUNT(DISTINCT userid) DESC
LIMIT 500;

Result: MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0026 sec )

SELECT ipaddress, GROUP_CONCAT(DISTINCT userid) AS userid
FROM user
WHERE joindate > 1333938235 AND userid > 0 AND ipaddress != ''
GROUP BY ipaddress
HAVING COUNT(DISTINCT userid) > 1
ORDER BY COUNT(DISTINCT userid) DESC
LIMIT 500;

Result: MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0030 sec )

OK. Well the good news is you don't have any duplicates in your forum.

The bad news is... I have to fix my code to deal with that situation- it was the one situation I couldn't test because I was always seeing duplicates in one or the other.

I'll probably release a fix later today. I'm confident that if you did have a duplicate the report would run as expected.

Thanks BOP5.

Awesome mod! Something that I've been looking for. Many IP/multiple accounts reporting mods really only check on registering, and not posts, which is just as vital.