id by ip address leads to bugs -- should use account name instead

Post Reply
floss2

Post by floss2 »

hi,

i was wondering why i kept seeing problems that i had seen before, despite cookies being enabled and "logical search" set to unsolved.

then i found out why -- thanks to a bug on the problems page. here is the bug:

"Table 'go.tries' doesn't exist, qry: SELECT COUNT(*) FROM tries WHERE problem = '9555' AND ip = 'w.x.y.z'"

(where w.x.y.z is one of the many ip addresses that my connection shows up as.)

this suggests that the reason i kept seeing the same problems is that the goproblems db thinks that i am my ip address. but i am not an ip address. i am a free man. (reference to british tv, never mind.)

many users are behind rotating proxies, dhcp, or otherwise have no control over what ip addresses they show up as. but their account names (mine is floss, or floss2 if i forget a password) are unique. this can be managed by cookies or even get method.

have i correctly diagnosed the problem and suggested the correct solution?

thanks as always.

p.s. the bug still persists; the problem and logical search pages do not work at all. but i assume you already know that. if not, i'm on linux with mozilla and a recent sun java.


{Posted by floss2}
admin

Post by admin »

thanks -- that is, indeed, a bug. i fixed it, though of course there are larger issues now...

adum

{Posted by admin}
floss2

Post by floss2 »

i imagine changing ip to account name would be sufficient?


{Posted by floss2}
Field Mouse

Post by Field Mouse »

Unregistered users would have no chance to influence the stats then?

~~~(___*>
Field Mouse

{Posted by Field Mouse}
Post Reply