Menu

Topic-icon Duplicate entry error upon upgrade to 3.4.5

  • azurelinksc
  • azurelinksc's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
1 month 2 weeks ago - 1 month 2 weeks ago #9148 by azurelinksc
Duplicate entry error upon upgrade to 3.4.5 was created by azurelinksc
Trying to upgrade to 3.4.5 and am getting this error:

Warning: Duplicate entry 'Not set' for key 'PRIMARY'

Tried to install again and got this:

Warning: Duplicate entry '212.237.3.30' for key 'PRIMARY'

If I'm not mistaken, these are apparently entries in the #_securitycheckpro_blacklist table. I tried deleting that record and reinstalling, but it just gave me another error with a new IP address.
Then I searched in the sql export file for the IP and found it in the #_securitycheckpro_storage table. I'm stuck.
Last edit: 1 month 2 weeks ago by azurelinksc.

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #9149 by Jose
Hi azurelink,

Yes, a couple of versions ago I completely redefine the way IPs were stored. Now each option have its own table and it's supposed there couldn't be duplicated values, and that's why you get the error.

Please, read this forum entry were I told about this:  securitycheck.protegetuordenador.com/for...in-update-3-4-5#9120

Regards,
Jose

Please Log in or Create an account to join the conversation.

  • azurelinksc
  • azurelinksc's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
1 month 2 weeks ago #9150 by azurelinksc
Replied by azurelinksc on topic Duplicate entry error upon upgrade to 3.4.5
Thanks Jose! As directed in that post, I exported the configuration in Tasks, and then uninstalled all of the Securitycheck Pro extensions. Then installed the 3.4.5 version and that was successful. I imported my config file and then reinstalled the spam protection and update database plugins. Also enabled the URL inspector plugin in this site (still have that issue in another site, btw.)

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #9151 by Jose
You're welcome!

If you send me administrative credentials to access to the site with the URL inspector issue I will check what's happening.

Regards,
Jose

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum

Login or Sign In