[borbole]

Originally Posted by mathforum

I ran the query and it affected over 1,000 rows, but no luck. Data is still there

I'm referring to the IP logs that you can see in the AdminCP. You search for a user and then in the drop-down box click "view IP addresses".

To remove it there run this query:

UPDATE vb_adminlog SET ipaddress = WHERE userid = 1;

2 things to note. First replace the standard vb_ prefix with whatever prefix you use for your db tables. And 1 with your user id if it is something else then 1. Hope it helped.