Support

Home Forums Event Espresso Premium Database size growing at an alarming rate

Database size growing at an alarming rate

Posted: November 19, 2019 at 12:49 pm

Viewing 5 reply threads


CVJS

November 19, 2019 at 12:49 pm

Database size is spiralling out of control.
One table – vdlrFUhhesp_line_item – is now 916mb in size.
The TXN_ID is being recorded 4 times every few seconds?
Any ideas why this might be happening? Any known plugin issues?
Many thanks 🙂


CVJS

November 19, 2019 at 2:12 pm

Rows: 3,918,780


CVJS

November 19, 2019 at 2:18 pm

And when I try to log into the Dashboard, I am faced with this error:

Fatal error: Uncaught Error: Call to a member function addTemplate() on null in /homepages/24/d697786276/htdocs/clickandbuilds/InspiredForestSchoolTraining/wp-content/plugins/eejs-api-example-simple-event-list-master/src/shortcodes/SimpleEvent.php:20 Stack trace: #0 /homepages/24/d697786276/htdocs/clickandbuilds/InspiredForestSchoolTraining/wp-content/plugins/eejs-api-example-simple-event-list-master/src/Loader.php(33): EEjsapi\shortcodes\SimpleEvent->registerScripts() #1 /homepages/24/d697786276/htdocs/clickandbuilds/InspiredForestSchoolTraining/wp-includes/class-wp-hook.php(288): Eejsapi\Loader->registerShortcodeScripts(”) #2 /homepages/24/d697786276/htdocs/clickandbuilds/InspiredForestSchoolTraining/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters(NULL, Array) #3 /homepages/24/d697786276/htdocs/clickandbuilds/InspiredForestSchoolTraining/wp-includes/plugin.php(478): WP_Hook->do_action(Array) #4 /homepages/24/d697786276/htdocs/clickandbuilds/InspiredForestSchoolTraining/wp-includes/script-loader.php(2667): do in /homepages/24/d697786276/htdocs/clickandbuilds/InspiredForestSchoolTraining/wp-content/plugins/eejs-api-example-simple-event-list-master/src/shortcodes/SimpleEvent.php on line 20


Josh

  • Support Staff

November 19, 2019 at 3:33 pm

Hi,

The last error you posted is from a proof of concept example that a developer wrote a while back. It wasn’t intended to be used on any real websites. If you’re not using that plugin it’s advised to deactivate it and delete it. If you are using it, you’re welcome to use it/modify it to suit your needs, but please note we do not support it.

With regards to the database table in question, that particular table is what handles all of the transactional-related data when someone registers for an event. Information that includes prices, number of tickets, taxes, surcharges, discounts, and anything that could end up contributing to the total price at checkout. So a lot of data is stored there.

There is what’s called a “Junk” transaction where a transaction is started but not finished (perhaps by selecting some tickets then abandoning the process before even filling out a registration form). Event Espresso has a mechanism that cleans these out on a schedule, and it relies on wp_cron for running that task on schedule.

You could check to see if your site’s scheduled tasks are working as expected by going to Tools > Site Health. After that page loads, it will check for the next scheduled task and display the results (either it worked or it didn’t). If the scheduled tasks are not working as expected, then that’s the next thing to troubleshoot.

One helpful tool that you can use to troubleshoot wp_cron is the WP Crontrol plugin. You can download it here:
https://wordpress.org/plugins/wp-crontrol/
I’ve seen it happen where wp_cron wasn’t working at all, then installing that plugin provided some error messages that helped troubleshoot the issue. For example, after you activate the Crontrol plugin then go to its Cron Schedules page, it might display a message that tells you to put:
define( 'ALTERNATE_WP_CRON', true );
into the site’s wp-config.php file. Which should fix things for you if that’s all that’s needed.


CVJS

November 21, 2019 at 1:37 am

Thanks Josh.

At the moment I am unable to log into my account to make any changes. I have tried all of the advised tips for getting back into wordpress listed online.

I can only assume that the database size is causing the issue, having checked everything else. Can I manually remove these ‘JUNK’ transactions to regain entry? How can I confirm that they are, indeed, JUNK 🙂


Tony

  • Support Staff

November 21, 2019 at 2:55 am

At the moment I am unable to log into my account to make any changes. I have tried all of the advised tips for getting back into wordpress listed online.

What happens when you view the dashboard? Whistsceen?

What error is being thrown when you get a whitescreen?

If it’s still this one:

Fatal error: Uncaught Error: Call to a member function addTemplate() on null

Then you need to disable the eejs-api-example-simple-event-list-master plugin, to do that use FTP and go to /wp-content/plugins/ find the above directory and rename it, just add -disabled to the end of the directory, or remove it completely if your not using it.

You may need to try loading /wp-admin/plugins.php although just loading /wp-admin/ should do it.

I can only assume that the database size is causing the issue, having checked everything else.

Afaik EE doesn’t just load every row from that table so I don’t think that’s causing the problem. Yes its large but that shouldn’t stop you logging in.

Viewing 5 reply threads

The support post ‘Database size growing at an alarming rate’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso