pruneipaddress task stuck

[David..]

After the 4.7.16 update I am getting this error:

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

 

What's the solution to this?

[Marc Stridgen]

Please visit the support area of your admin CP and apply the patch shown which resolves this issue