| Author |
 Topic  |
|
|
Etymon
Advanced Member
United States
2385 Posts |
 Posted - 11 May 2007 : 13:51:48
|
I'm working on an older forum. The forum was previously upgraded from 3.3.xx to 3.4.xx. The last major upgrade was done in December 2006.
Several of the database field definitions have not been updated. For instance, in FORUM_TOPICS the field T_IP is nvarchar(50) instead of nvarchar(15).
In Visual Studio 2005 I've been running some tests against the data length before converting the field definitions. I found 46 instances of IP addressses where two IP Addresses were inserted into the field separated by a comma. Out of over 4,000 members there were only 4 members in 4 forums where this occurred. The members ip addresses have not been banned (Ban MOD). The members are not moderators. And 3 of them have over 1,000 posts over the past several years. The message board gets 75-100 posts a day. The ip problem looks like this (I omitted the ip addresses in this example to protect the innocent  ):
000.000.000.000, 000.000.000.000
All of these occurrences have happened in 2007.
The queries I have been running are like this (the table is the only thing I change between each query):
SELECT FORUM_ID, TOPIC_ID, T_AUTHOR, T_DATE, T_IP, COUNT(T_IP) AS T_IP_NumOccurrences
FROM FORUM_TOPICS
WHERE (LEN(T_IP) > 15)
GROUP BY FORUM_ID, TOPIC_ID, T_AUTHOR, T_DATE, T_IP
-----------------------------
Any idea what can cause a double ip address? |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 11 May 2007 : 13:59:54
|
I seem to remember Shaggy talking about this a while back, something about the list of IP addresses and the routing... the specifics escape me at the moment. If I get a chance I'll see if I can dig up that topic.
Edit: This is the topic I was thinking of. Different issue, but related. |
Edited by - AnonJr on 11 May 2007 14:03:43 |
 |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 11 May 2007 : 16:41:46
|
quote:
Originally posted by AnonJr
I seem to remember Shaggy talking about this a while back, something about the list of IP addresses and the routing... the specifics escape me at the moment. If I get a chance I'll see if I can dig up that topic.
Edit: This is the topic I was thinking of. Different issue, but related.
Thanks AnonJr! That's the ticket! |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 11 May 2007 : 16:42:39
|
Your welcome. Most productive thing I've done all day.  |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 21 May 2007 : 08:12:36
|
Note that my fix isn't an official one as the Dev Team haven't yet decided how to handle multiple IP addresses. As you can see in that topic, another suggestion was to increase the size of the IP fields.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 24 May 2007 : 16:26:02
|
quote:
Originally posted by Shaggy
Note that my fix isn't an official one as the Dev Team haven't yet decided how to handle multiple IP addresses. As you can see in that topic, another suggestion was to increase the size of the IP fields.
Thanks Shaggy. It seems to be isolated to just a few members. Have you noticed a trend in multiple IP addresses becoming increasingly more commonplace? |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 25 May 2007 : 04:26:07
|
No, just a handful here and there since v3.4.06 was released and we started using HTTP_X_FORWARDED_FOR instead of REMOTE_ADDR.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
| |
Topic |
|
Topic Locked
