Error duplicate entry for key primary
By Fortius on Monday, 20 November 2017
Posted in JEvents (Free Access)
Replies 26
Likes 1
Views 4.6K
Votes 0
Hi,

Using jevents for a while for our website and are quite happy with it. Since a few weeks however it isn't possible anymore to create new events. As soon as we try to save a new events a duplicate entry error pos up.

Duplicate entry '330' for key 'PRIMARY'

Tried everything including an uninstall but nothing seems to work. Any ideas on how to solve this?

Thank you in advance.
Hello Peter,

I have fixed this for you on your site now. I suspect your host had a crash and restored some tables but leaving the old auto-incremental value behind, I've increased this now and all is well.

Many thanks
Tony
tonyp
·
7 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Hello,

Uninstalling wouldn't touch the database since we leave this behind for scenarios like this.

So it is saying it's trying to insert an event and the primary key is already taken. Can you please provide your JEvents Support Info from your JEvents Control Panel?

Many thanks
Tony
tonyp
·
7 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Hi Tony,

Thanks for your quick reply. Herewith the support info:



PHP Version : 7.1.11-1+ubuntu16.04.1+deb.sury.org+1

MySQL Version : 5.5.5-10.2.9-MariaDB-10.2.9+maria~trusty

Server Information : Linux web01.vmm10.vhosting.pcextreme.nl 4.4.0-98-generic #121-Ubuntu SMP Tue Oct 10 14:24:03 UTC 2017 x86_64

Fix jQuery? : Yes

Load JEvents Bootstrap CSS? : Yes

Max Input Vars ? : 1000

Club code set? : No  

User Agent : Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36  

Joomla : 3.8.2

component_com_jevents : 3.4.43

component_com_jce : 2.6.20

component_com_acymailing : 5.8.1

module_mod_acymailing : 3.7.0

module_mod_jevents_cal : 3.4.43

module_mod_jevents_custom : 3.4.43

module_mod_jevents_filter : 3.4.43

module_mod_jevents_latest : 3.4.43

module_mod_jevents_legend : 3.4.43

module_mod_jevents_switchview : 3.4.43

plugin_acymailing_contentplugin : 3.7.0 (not enabled)

plugin_acymailing_managetext : 1.0.0

plugin_acymailing_online : 3.7.0

plugin_acymailing_share : 1.0.0

plugin_acymailing_stats : 3.7.0

plugin_acymailing_tablecontents : 1.0.0

plugin_acymailing_tagcontent : 3.7.0

plugin_acymailing_tagsubscriber : 5.8.1

plugin_acymailing_tagsubscription : 5.8.1

plugin_acymailing_tagtime : 5.8.1

plugin_acymailing_taguser : 5.8.1

plugin_acymailing_template : 5.8.1

plugin_content_jevents : 3.4.43

plugin_editors_acyeditor : 5.8.1

plugin_finder_jevents : 3.4.43 (not enabled)

plugin_installer_jeventsinstaller : 3.4.43

plugin_search_eventsearch : 3.4.43

plugin_system_gwejson : 3.4.43
Fortius
·
7 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Hello,

It should be fine, given the complexity of the issue can you provide me super user and phpmyadmin logins so I can take a look at resolving this for you?

Many thanks
Tony
tonyp
·
7 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Thanks, that sounds good and hopeful .

I've sent you the required details in a PM.

Regards,
Peter
Fortius
·
7 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Hi Tony,

Thank you very much for solving the problem!

Regards,
Peter
Fortius
·
7 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
We are having this exact same issue. Worked fine for years, but suddenly can't add new event.

0 Duplicate entry '375' for key 'PRIMARY'
umbrella
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Sorry, this is on https://www.AllenCC.edu site.
umbrella
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Here is our data...



PHP Version : 7.1.23

MySQL Version : 5.5.5-10.2.18-MariaDB

Server Information : Linux elite2033.inmotionhosting.com 2.6.32-754.el6.x86_64 #1 SMP Tue Jun 19 21:26:04 UTC 2018 x86_64

Fix jQuery? : Yes

Load JEvents Bootstrap CSS? : Yes

Max Input Vars ? : 1000

Club code set? : No  

User Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15  

Joomla : 3.9.0

component_com_jevents : 3.4.48

component_com_jce : 2.6.33

module_mod_jevents_cal : 3.4.48

module_mod_jevents_custom : 3.4.48

module_mod_jevents_filter : 3.4.48

module_mod_jevents_latest : 3.4.48

module_mod_jevents_legend : 3.4.48

module_mod_jevents_switchview : 3.4.48

plugin_content_jevents : 3.4.48

plugin_finder_jevents : 3.4.48

plugin_installer_jeventsinstaller : 3.4.48 (not enabled)

plugin_search_eventsearch : 3.4.48

plugin_system_gwejson : 3.4.44
umbrella
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Is this something I can fix in phpmyadmin?
umbrella
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Hello,

Yes it is. Please provide super user logins and PhpMyAdmin logins into the site details tab and I'll take a look for you.

Many thanks
Tony
tonyp
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
I PM'd you. (Couldn't find the "site details tab"...
umbrella
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Did you get my pm okay?
umbrella
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Just checking in to see if anything has been fixed. Thanks!
umbrella
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
That's now been fixed for you now. Sorry I was dealing with club support, we have been quite busy this week!

Many thanks
Tony
tonyp
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Thank you. We'll check it out.

I didn't get a notification in email, so I just saw this.
umbrella
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
No problem at all!
tonyp
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Yes, all seems well now.

Can you tell me what you did in case I get stuck again (we use JEvents on a TON of sites)? I'm pretty good with phpmyadmin. Thanks!
umbrella
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Hello,

I just increase the autoincremental value to a higher number than what it was trying to assign..

Many thanks
Tony
tonyp
·
6 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Hello,

I just increase the autoincremental value to a higher number than what it was trying to assign..

Many thanks
Tony


I'm experiencing this issue, but do not have authority to give out DB usernames and passwords at the moment, can you explain what needs to be done to remedy it, it sounds fairly simple?
Many thanks
pedders
·
5 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
Got the same, i send you a PM.
Better would be if you could explain the solution here in forum :-)
Thanks
rolig
·
5 years ago
·
1 Likes
·
0 Votes
·
0 Comments
·
View Full Post