Nathan Explosion

Don't use the auto uograder.

Manually upgrade...download the files, upload them to your site, change the PHP version (after ensuring that the ips4.php checker says all OK) and go directly to /admin/upgrade, or whatever it is.

Are you definitely using PHP 8.0 for your site? Go to the support page in the ACP and confirm what version of PHP your site is running under, then come back and advise.

https://invisioncommunity.com/clientarea/

Go to the support page and install any pending patches.

https://www.ynwa.tv/files/file/20-ne-emoji-enhancements/

Delete the database

Delete the files

Reupload the files

Install the software.

Seeing as there were some other people who reported this and were actually running an unsupported version of PHP...what version of PHP do you currently have in use? (view it on the Support page in the ACP)

If it is NOT 8.0 or 8.1, and is 8.2 or 8.3 then drop down to a support version (8.0 & 8.1)

44 minutes ago, MediaDiGi said:

I want to know if IPS offers the tools so I can do it myself

Crack on!

https://invisioncommunity.com/services/convert/

Confirmed as resolving the issue.

19 minutes ago, Stuart Silvester said:

I cannot reproduce any issues with these being pruned. The IPs are being removed as expected.

But they may not, if the task is erroring out...

6 minutes ago, Marc Stridgen said:

Simply click the "Enabled" link, which will switch it to disabled 🙂 

Where's that? Happy to be blind on this one.

Anyway...simply change the "Available for..." field so that it's only available to those you want to see it:

Here are your reproduction steps...

1. Login to a site
2. Logout
3. Change your IP address
4. Login to the site again, ensuring same browser and account
5. Set the "Remove IP addresses after" setting to whatever you want (I believe the minimum is 1 day)
6. Wait that amount of time, then run the task.

To reproduce it quicker, you're going to need to manipulate database records to change the last_seen value to meet the criteria.

Potential fix: modify that primary key to include the last_seen value.

Reporting it as it just occurred on my live site...

UPDATE `core_members_known_ip_addresses` `core_members_known_ip_addresses`  SET `ip_address`='' WHERE ip_address != '' AND last_seen <1709136738
IPS\Db\Exception: Duplicate entry '0138fdaa72c8135e62b3487f5be7b11d-2970-' for key 'PRIMARY' (1062)
#0 /home/fbaeefdf/live.ynwa.tv/system/Db/Db.php(1159): IPS\_Db->preparedQuery()
#1 /home/fbaeefdf/live.ynwa.tv/applications/core/extensions/core/IpAddresses/Logins.php(33): IPS\_Db->update()
#2 /home/fbaeefdf/live.ynwa.tv/system/Member/Member.php(6504): IPS\core\extensions\core\IpAddresses\_Logins->pruneIpAddresses()
#3 /home/fbaeefdf/live.ynwa.tv/applications/core/tasks/pruneipaddresses.php(43): IPS\_Member::pruneAllLoggedIpAddresses()
#4 /home/fbaeefdf/live.ynwa.tv/system/Task/Task.php(281): IPS\core\tasks\_pruneipaddresses->execute()
#5 /home/fbaeefdf/live.ynwa.tv/applications/core/modules/admin/settings/advanced.php(751): IPS\_Task->run()
#6 /home/fbaeefdf/live.ynwa.tv/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\settings\_advanced->runTask()
#7 /home/fbaeefdf/live.ynwa.tv/applications/core/modules/admin/settings/advanced.php(38): IPS\Dispatcher\_Controller->execute()
#8 /home/fbaeefdf/live.ynwa.tv/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\settings\_advanced->execute()
#9 /home/fbaeefdf/live.ynwa.tv/admin/index.php(13): IPS\_Dispatcher->run()
#10 {main}

I believe this is a knock-on effect of it NOT having been pruning the IP addresses correctly previously - the issue you'll have is that there could be multiple entries for a specific device_key and member_id, but with different IP addresses. Now that task has been fixed to do the pruning, when it tries to remove the IP address on those multiple entries, the PRIMARY key for each row will end up being the same as the key is made up of device_key, member_id, IP address (which is now blank)

Sample content attached:core_members_known_ip_addresses.sql

When the query in the task runs against that data, the error occurs:

UPDATE `core_members_known_ip_addresses` `core_members_known_ip_addresses`  SET `ip_address`='' WHERE ip_address != '' AND last_seen <1709135288

If you are using Windows Defender then report it as a false positive back to Microsoft:

https://www.microsoft.com/en-us/wdsi/filesubmission/

I'll be disabling that functionality until this is resolved then...just been alerted to a data leak (title of a private topic being visible) which is going to cause a few problems now that it's been seen.

Test of a topic in a private forum, viewable by a normal member...

You pay for a new license, and then the renewals.

3 minutes ago, marco2306 said:

the upload image item doesn't show me anything that allows me to upload an image.

Do you mean that you don't see these options?

Go into the ACP and type delete into the search bar and click on the Permanently delete content result.

Windows Snipping Tool

Lightshot

2 minutes ago, LiamH said:

but somehow we are recently getting exactly that.

It's designed to allow them...they can "Post before registering" as your members group has permissions to do so...

If someone in your members group can post in a location where guests cannot, then guests will be able to post.