XF 1.4 Cleaning up incorrect IP addresses from user profiles

[Mr Lucky]

I have recently found that a user welcome add-on I was using seemed to be incorrectly assigning IP addresses from new users to the admin member who was assigned to be sending an automated email.

So what I want to do is cleanse all the bogus IP addresses from that user's ACP profile.

I have very little knowledge about mySql, in fact it scares me a bit messing with the database, can anyone give me some info, tips etc. on how to remove these?

Is it an easy matter or something that needs to be approached with caution.

TIA for any help.

 

[Paul B]

Other than purging all stored IP addresses, there isn't much more you can do.

You should contact the developer of the add-on to advise them of the problem and obtain a possible solution.

 

[Mr Lucky]

Aha:

https://xenforo.com/community/threads/how-can-stored-ip-addresses-be-deleted.27471/#post-612192

UPDATE xf_ip
SET ip = INET_ATON('12.34.56.78')
WHERE user_id = 1

This seems to work.

 

[Mr Lucky]

You should contact the developer of the add-on to advise them of the problem and obtain a possible solution.

I did, but no reply. Which is very bad IMO as it's a paid addon.

 

[Amaury]

I did, but no reply. Which is very bad IMO as it's a paid addon.

People have busy lives and can't always respond quickly, etc.

 

[Mr Lucky]

People have busy lives and can't always respond quickly, etc.

Or even slowly. Still no response.

 

[Paul B]

There is nothing we can do with regards to third party developers and add-ons.

It is their responsibility to support their products and advise of fixes for bugs introduced by them.

 

[Mr Lucky]

There is nothing we can do with regards to third party developers and add-ons.

Yes, I agree totally (in most instances) I wasn't trying to imply you should in this case.

I started the thread to find a solution, not to attempt to instigate any action against the developer.