- Posts: 71
- Thank you received: 3
- Home
- /
- Forum
- /
- Securitycheck Pro
- /
- Bug report
- /
- Duplicate entry error upon upgrade to 3.4.5
Duplicate entry error upon upgrade to 3.4.5
- azurelinksc
-
Topic Author
- Offline
- Senior Member
-
Less
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.
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.
- Jose
-
- Offline
- Moderator
-
Less
More
- Posts: 4492
- Thank you received: 332
1 month 2 weeks ago #9149
by Jose
Replied by Jose on topic Duplicate entry error upon upgrade to 3.4.5
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
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
-
Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 71
- Thank you received: 3
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.
- Jose
-
- Offline
- Moderator
-
Less
More
- Posts: 4492
- Thank you received: 332
1 month 2 weeks ago #9151
by Jose
Replied by Jose on topic Duplicate entry error upon upgrade to 3.4.5
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
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