• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Deleting an IP address from the DB

Alfa1

Well-known member
#1
During an import process, the admin IP address was erroneously added to the accounts of a number of users.
This would create significant problems as soon as a multiple accounts checker is activated.
How can I query the DB for this IP address and remove all instances of it?

I see the IPs are in binary format, but for soem reason when I search for the binary I get no results.
 

Alfa1

Well-known member
#3
How weird. I get this when running the select version:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM xf_ip WHERE ip = UNHEX(LPAD(HEX(INET_ATON('1.2.3.4')), 8, '0')) LIMIT' at line 1