0
Undo
Votes
Hi,
at present time we are unable to make a backup of our website and the issiue seems to be that 3 of the JEV tables are absolutely massive and nothing seems to reduce the. THe tables are
JEV_usereventsmap
JEV_agendaminutes
JEV_customfields
THe first two are at over 12 million rows and tlast over 5 million rows. these take up 1.6gb og the 1.7gb database.
Deleteing any event entries has not hade any difference even one that had a recurrence of 9999 times by accidendt.
It seems that once entries are created they are not deleted at all.
We need to get these down to a manageable level or just leave these tables out the backup entirely.
Any advice or guidance would be really helpfull as this just seems wrong.
Thanks
Tony
at present time we are unable to make a backup of our website and the issiue seems to be that 3 of the JEV tables are absolutely massive and nothing seems to reduce the. THe tables are
JEV_usereventsmap
JEV_agendaminutes
JEV_customfields
THe first two are at over 12 million rows and tlast over 5 million rows. these take up 1.6gb og the 1.7gb database.
Deleteing any event entries has not hade any difference even one that had a recurrence of 9999 times by accidendt.
It seems that once entries are created they are not deleted at all.
We need to get these down to a manageable level or just leave these tables out the backup entirely.
Any advice or guidance would be really helpfull as this just seems wrong.
Thanks
Tony
Hi Tony,
That seems extremely strange. What version of JEvents are you using? can you post your JEvents Support Info?
Have you deleted all past events?
How many future events do you have? for the first two to have 12 million rows is crazy, do you have tens of thousands of events?
Many thanks
Tony
That seems extremely strange. What version of JEvents are you using? can you post your JEvents Support Info?
Have you deleted all past events?
How many future events do you have? for the first two to have 12 million rows is crazy, do you have tens of thousands of events?
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,
no we have not deleted all past events as we want to keep the history of some, a good number were set to 999 repeat and one was set to 9999 repeat but these have now been reduced (not deleted anrecreated just the repeat reduced.. Here is the file you asked for:
I need to know what we can do to reduce these table to a sensible size, or i just leave them out the back and face the consequences if we ever restore
thanks
Tony
no we have not deleted all past events as we want to keep the history of some, a good number were set to 999 repeat and one was set to 9999 repeat but these have now been reduced (not deleted anrecreated just the repeat reduced.. Here is the file you asked for:
PHP Version : 5.5.38
MySQL Version : 5.7.23
Server Information : Linux web1.uk.cloudlogin.co 4.4.182-xeon-hst #4 SMP Wed Jun 19 20:26:04 UTC 2019 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/70.0.3538.102 Safari/537.36 Edge/18.18362
Joomla : 3.6.5
component_com_jevents : 3.4.4
component_com_jevlocations : 3.4.3
component_com_jce : 2.3.4.4
module_mod_jevents_cal : 3.4.4
module_mod_jevents_custom : 3.4.4
module_mod_jevents_filter : 3.4.10
module_mod_jevents_latest : 3.4.4
module_mod_jevents_legend : 3.4.4
module_mod_jevents_switchview : 3.4.4
module_mod_jevlocations : 3.4.3
plugin_content_jevents : 3.4.4
plugin_content_jevlocation_embed : 3.4.3
plugin_content_jevpeople : 3.0.35 (not enabled)
plugin_finder_jevents : 3.4.4 (not enabled)
plugin_jevents_agendaminutes : 3.1.9
plugin_jevents_jevcalendar : 3.0.5
plugin_jevents_jevcustomfields : 3.1.23
plugin_jevents_jevfacebook : 3.0.5 (not enabled)
plugin_jevents_jevfacebooksocial : 3.0.8 (not enabled)
plugin_jevents_jevlocations : 3.4.3
plugin_jevents_jevpeople : 3.0.35 (not enabled)
plugin_jevents_jevtimelimit : 3.4.0
plugin_jevents_jevusers : 3.2.2
plugin_search_eventsearch : 3.4.4
plugin_search_jevlocsearch : 3.4.3 (not enabled)
plugin_search_jevpeoplesearch : 3.0.35 (not enabled)
plugin_system_gwejson : 3.4.4
I need to know what we can do to reduce these table to a sensible size, or i just leave them out the back and face the consequences if we ever restore
thanks
Tony
Hello,
First and foremost update Joomla!! You are extremely out of date. Same with JEvents.
Then can you provide us with super user and phpmyadmin/database access so we can do an events audit?
Many thanks
Tony
First and foremost update Joomla!! You are extremely out of date. Same with JEvents.
Then can you provide us with super user and phpmyadmin/database access so we can do an events audit?
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,
sorry for the delay. it is unlikely that the customer will allow the upgrade of joomla or jevents as there is to much cost involved in paying for all the additional joomla and jevent modules again and retesting all customisation. THis is always an issue with customer sites they assume fire and forget not that it could cost them serveral 100 per year to maintain because of the options they wanted an customizations.
Is there any way of getting a script so i could just drop those 3 tables and recreate them? THe agend minutes they are not even using in any event anyway so no idea why it has created so many records. Would uninstalling that option enpty that table?
Thabnks
Tony
sorry for the delay. it is unlikely that the customer will allow the upgrade of joomla or jevents as there is to much cost involved in paying for all the additional joomla and jevent modules again and retesting all customisation. THis is always an issue with customer sites they assume fire and forget not that it could cost them serveral 100 per year to maintain because of the options they wanted an customizations.
Is there any way of getting a script so i could just drop those 3 tables and recreate them? THe agend minutes they are not even using in any event anyway so no idea why it has created so many records. Would uninstalling that option enpty that table?
Thabnks
Tony
Hello,
Everything that is on J3.6 should really work with J3.9, very few exceptions causes a BC break on the .x releases.
So Agenda and minutes is for the links to and from Joomla! Articles. You can uninstall Agenda/Minutes plugin or disable it and test the event creation if it looks the same you can uninstall it the remove the data table completely.
Many thanks
Tony
Everything that is on J3.6 should really work with J3.9, very few exceptions causes a BC break on the .x releases.
So Agenda and minutes is for the links to and from Joomla! Articles. You can uninstall Agenda/Minutes plugin or disable it and test the event creation if it looks the same you can uninstall it the remove the data table completely.
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!
- Page :
- 1
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.