Home » Other » Suggestions & Feedback » double listing for IP addresses
double listing for IP addresses [message #273708] Thu, 11 October 2007 08:05 Go to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I have noticed when clicking on many members' IP address, a single member is listed twice. It seems to be occurring on new newer members or members with few messages.
Re: double listing for IP addresses [message #273710 is a reply to message #273708] Thu, 11 October 2007 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This may be linked to http://www.orafaq.com/forum/t/90687/102589/

Regards
Michel
Re: double listing for IP addresses [message #273806 is a reply to message #273710] Thu, 11 October 2007 14:10 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Interesting - I'll look into it over the weekend.
Re: double listing for IP addresses [message #274861 is a reply to message #273806] Wed, 17 October 2007 07:55 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I don't know if this helps, but I tried to scan another IP address today and there was a big list of users with this IP address but only one of them was duplicated (the last one?), so it looks as if maybe it started duplicating as of a certain date (maybe since the new changes were implemented?)
Re: double listing for IP addresses [message #274938 is a reply to message #274861] Wed, 17 October 2007 14:53 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Quote:

...only one of them was duplicated (the last one?)


Look like this is a feature - not a bug. The first set of IPs are from the messages table (IPs used while posting); the last IP is the user's registration IP.

The logic is:

SELECT DISTINCT(ip_address) FROM messages WHERE user_id = ...
SELECT registration_ip FROM users WHERE user_id = ...


Hence, the last IP may be listed twice.
Previous Topic: Change contents of posts
Next Topic: Wiki ideas for people who wants to contribute
Goto Forum:
  


Current Time: Thu Mar 28 17:37:02 CDT 2024