0
Undo
Votes
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.
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
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
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
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
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
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
Hi Tony,
Thanks for your quick reply. Herewith the support info:
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
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
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
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
.
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
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
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
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
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
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
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
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
Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
No problem at all!
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
Hello,
I just increase the autoincremental value to a higher number than what it was trying to assign..
Many thanks
Tony
I just increase the autoincremental value to a higher number than what it was trying to assign..
Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
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
- Page :
- 1
- 2
There are no replies made for this post yet.
Members Area
Show your support
Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons
Your membership will ensure that JEvents continues to be the best events calendar for Joomla.