|
oncue1a
|
April 29, 2024 at 2:00 am
Good morning,
We are having trouble with a couple Event Espresso components. What would you recommend ? Thank you.
a) Download Registration Error
Generating file event-espresso-registrations-2024-04-29-17-45-21.csv…
….
While running BatchRunner::continueJob() the following EventEspresso\core\libraries\batch\Helpers\BatchRequestException occurred:
Could not retrieve valid data for job VaR6AR84bFOKLot from the WordPress options table. The WordPress option was ee_job_parameters_VaR6AR84bFOKLot
#0 /home/oncuetalentcom/public_html/wp-content/plugins/event-espresso-core-reg/core/libraries/batch/BatchRequestProcessor.php(89): EventEspresso\core\libraries\batch\Helpers\JobParameters::load(‘VaR6AR84bFOKLot’)
#1 /home/oncuetalentcom/public_html/wp-content/plugins/event-espresso-core-reg/core/libraries/batch/BatchRequestProcessor.php(150): EventEspresso\core\libraries\batch\BatchRequestProcessor->initializeJobHandler(‘VaR6AR84bFOKLot’)
#2 /home/oncuetalentcom/public_html/wp-content/plugins/event-espresso-core-reg/modules/batch/EED_Batch.module.php(373): EventEspresso\core\libraries\batch\BatchRequestProcessor->continueJob(‘VaR6AR84bFOKLot’)
#3 /home/oncuetalentcom/public_html/wp-content/plugins/event-espresso-core-reg/modules/batch/EED_Batch.module.php(383): EED_Batch->runBatchRunnerJob(‘continueJob’)
#4 /home/oncuetalentcom/public_html/wp-includes/class-wp-hook.php(287): EED_Batch->continueBatchJob(”)
#5 /home/oncuetalentcom/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(”, Array)
#6 /home/oncuetalentcom/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
#7 /home/oncuetalentcom/public_html/wp-admin/admin-ajax.php(176): do_action(‘wp_ajax_espress…’)
#8 {main}
b) We are not able to register for an event as well. We receive an error message
“Nothing in your Event Queue
You need to select at least one event before you can proceed with the registration process.”
Our website support found some log error messages reading
oncuetal_db5/bzzu7_options.MYI is corrupt; try to repair it for query INSERT INTO ‘bzzu7_options(‘option name’, ‘option value’, autoload) VALUES(‘cron’….
|
|
Tony
|
April 29, 2024 at 3:42 am
Hi there,
The error with the CSV shows:
“Could not retrieve valid data for job VaR6AR84bFOKLot from the WordPress options table.”
So EE is having an issue access your options table.
—-
That ties into the nothing in your event queue error you are getting as the checkout page uses transients which are also stored in the options table.
Both of those then tie into this:
Our website support found some log error messages reading
So it sounds like there is an issue with the options table within the database, which would then break both of the features you’ve mentioned.
Did your support run a check/repair on the database to fix the error?
Backup the full database now before moving forward, then have them run a replied on the options table.
|
|
oncue1a
|
April 29, 2024 at 4:25 am
Thank you, I Repaired the three databases under the “My SQL Databases” menu, and it has fixed the issue. For future reference, how would you recommend backing up the databases ? Thank you very much.
|
|
Tony
|
April 29, 2024 at 4:57 am
Awesome, I’m glad its working for you again 🙂
A lot of hosts have an option built into their control panel, that’s often the ‘best’ method to use as it’s usually a one click backup/restore option that runs outside of your WordPress install (that’s important for later).
You can export the Database using PHPMyAdmin (which most hosts will have available) and usually your host will have documentation on how.
Or… the plugin method, there plenty available (Have a look through THESE) but ‘Updraft’ is a popular option. You can create full site or database backups through it.
The problem with using a plugin is if you can’t load the WP Admin, you can’t restore the backup (you can, but takes more effort and file access, which you may not have).
|
