Fatal error

  • Resolved wpkiller

    (@wpkiller)


    5 years, 10 months ago

    Hi there,

    Just wanted to let you know I’ve might found the reason people are getting the following error (taken from another post here):

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table 'squisitodev.wp_actionscheduler_actions' doesn't exist in /var/www/html/squisitodev.com/public/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /var/www/html/squisitodev.com/public/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /var/www/html/squisitodev.com/public/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /var/www/html/squisitodev.com/public/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /var/www/ht in /var/www/html/squisitodev.com/public/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

    It happened to me too, but when I’ve tried to track my steps back, I remembered I was running WP-Optimize and it advised me to remove tables which according to it, weren’t in use. Well… it seems WP-Optimize advises to remove actionscheduler’s tables. Unfortunately, I allowed it to remove the tables and then I got the same error.

    When I’ve reinstalled actionscheduler, the error was gone.

    Here’s a screenshot from within WP-Optimize. Maybe you can contact WP-Optimize author and ask him/them to change their advise for these tables…

    View post on imgur.com

    You’ll see that “WP Mail SMTP” is not mentioned as a plugin using actionscheduler, and as all those that are recognized to use it are not installed on my site, it lets me remove the table (button on the right).

    • This topic was modified 5 years, 10 months ago by wpkiller.
Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Author Gregor Capuder

    (@capuderg)

    5 years, 10 months ago

    Hi,

    thank you for sharing this with us. We’ll contact the WP Optimize support and ask to add us to the list of plugins using Action Scheduler.

    Have a nice day!

    Plugin Author Gregor Capuder

    (@capuderg)

    5 years, 10 months ago

    Somebody already posted a question about this in their support forum. I’ve just added an additional request: https://ww.wp.xz.cn/support/topic/database-table-association/

    I hope they can add our plugin to the list on their next plugin update.

    Thread Starter wpkiller

    (@wpkiller)

    5 years, 10 months ago

    Oh, sorry I didn’t check there before posting.
    Actually, I have this screenshot open on my PC for over a week, I was just too lazy to open a support thread for it. Today I’ve stumbled upon the screenshot and I decided I must let you know, as I’m enjoying your great plugin for free. This would be the least I can do to help.

    I hope things will turn for the best.
    Continue the great work!

    Plugin Author Gregor Capuder

    (@capuderg)

    5 years, 10 months ago

    Hi,

    oh, no problem at all. We’re glad you let us know and hope this will be resolved soon, so others don’t delete these DB tables as well.

    Thank you and have a nice day!

    Plugin Author Gregor Capuder

    (@capuderg)

    5 years, 10 months ago

    Hi,

    oh, no problem at all. We’re glad you let us know and hope this will be resolved soon, so others don’t delete these DB tables as well.

    Thank you and have a nice day!

    Nicholas Elpidorou

    (@nicholaselp)

    5 years, 10 months ago

    Hi I hope you are all well!

    I have the same issue I must have deleted the tables when using WP Optimization. How exactly will I recover the tables? I found a github link to the action-scheduler plugin (https://github.com/woocommerce/action-scheduler/releases/tag/3.1.6) but when I uploaded it and activated it i got the same error. @wpkiller you said you have reinstalled actionscheduler, how did you do that? Also adding my error below.

    Looking forward for a reply.

    ===================================================================
    ===================================================================

    WordPress database error: [Table ‘dbxqgud48byut6.7Ew_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM 7Ew_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘dbxqgud48byut6.7Ew_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM 7Ew_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress database error: [Table ‘dbxqgud48byut6.7Ew_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM 7Ew_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘dbxqgud48byut6.7Ew_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM 7Ew_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress database error: [Table ‘dbxqgud48byut6.7Ew_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM 7Ew_actionscheduler_groups WHERE slug=’action-scheduler-migration’

    WordPress database error: [Table ‘dbxqgud48byut6.7Ew_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM 7Ew_actionscheduler_groups

    WordPress database error: [Table ‘dbxqgud48byut6.7Ew_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM 7Ew_actionscheduler_actions

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘dbxqgud48byut6.7Ew_actionscheduler_actions’ doesn’t exist in /home/customer/www/staging2.offsethairindustry.com/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/customer/www/staging2.offsethairindustry.com/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/customer/www/staging2.offsethairindustry.com/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/customer/www/staging2.offsethairindustry.com/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /home/c in /home/customer/www/staging2.offsethairindustry.com/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
    There has been a critical error on your website. Please check your site admin email inbox for instructions.

    Sanjeev Aryal

    (@sanzeeb3)

    5 years, 10 months ago

    Hi @nicholaselp,

    Please follow the instructions in the tutorial here. If you’re still getting issue, contact your hosting provider to create the required tables. It could be due to some database misconfiguration.

    I hope this helps!

    Nicholas Elpidorou

    (@nicholaselp)

    5 years, 10 months ago

    Hi Sanjeev and thanks for the reply!

    I have followed the instructions in the tutorial you gave me but once I upload and install the plugin I get the same error again.

    Also contacted my host provider and because I deleted the tables a long time ago we could not find the table in the backups we had in order to import them back in. Is there another way to add the tables?

    Plugin Author Gregor Capuder

    (@capuderg)

    5 years, 10 months ago

    Hi Nicholas,

    I think your site has the wp option action_scheduler_migration_status set to “complete” and this is what prevents your site from trying to recreate the DB tables.

    You could try to delete the action_scheduler_migration_status option in the wp_options DB table, but you should only do that if you know what you are doing and are comfortable with editing databases. You could also ask your hosting support to do that for your site.

    Once that option is deleted, try to follow the tutorial above again.

    Let me know how it goes.

    Take care!

    Nicholas Elpidorou

    (@nicholaselp)

    5 years, 10 months ago

    Hi Gregor and thanks for the reply!

    I contacted my hosting support and assisted me on searching in my database. In my table 7Ew_options I only had these

    action_scheduler_hybrid_store_demarkation
    action_scheduler_lock_asynch-request-runner

    which both have been deleted. I searched everywhere for action-scheduler but I could not find anything in any table.

    Issue still exists when I activate action-scheduler plugin.

    Plugin Author Gregor Capuder

    (@capuderg)

    5 years, 10 months ago

    Hi Nicholas,

    thank you for letting us know.

    I have found this Action Scheduler GH issue: https://github.com/woocommerce/action-scheduler/issues/587 that might be what you are experiencing.

    Maybe try to test this out first: https://github.com/woocommerce/action-scheduler/issues/587#issuecomment-658168773

    And see if you get the same error as the other user did: https://github.com/woocommerce/action-scheduler/issues/587#issuecomment-658466188

    Let me know how it goes.

    Have a nice day!

    Nicholas Elpidorou

    (@nicholaselp)

    5 years, 10 months ago

    Hi Gregor thank you for reaching out and sorry for the late reply,

    I have followed the post you have sent me and I have added the actionscheduler_actions table successfully.

    When I go back to the tutorial (https://wpmailsmtp.com/docs/how-to-troubleshoot-action-scheduler-issues-wp-mail-smtp-2-1-1/) I downloaded and installed the action scheduler plugin and thankfully the website does not crash but It seems I am still missing a table (actionscheduler_groups) .

    This is the error I have now.

    [Table ‘dbszwp6gn7z8aj.7Ew_actionscheduler_groups’ doesn’t exist]
    SELECT a.*, g.slug AS group FROM 7Ew_actionscheduler_actions a LEFT JOIN 7Ew_actionscheduler_groups g ON a.group_id=g.group_id WHERE a.action_id=1

    I have searched for the insert statement of this table but I was unable to find it.
    Would love to hear back from you!
    In the mean time I will be searching for the INSERT statement of the table.

    Nicholas Elpidorou

    (@nicholaselp)

    5 years, 10 months ago

    Hi,

    Please ignore my previous message. After downloading and installing the plugin once I opened it it successfully inserted the missing table that I mentioned above. Now I was able to update the plugin and the website is working perfectly now!!

    I appreciate all your help and contribution to finding a solution on my problem.
    Thank you all and I hope you have a good day !

    Plugin Author Gregor Capuder

    (@capuderg)

    5 years, 10 months ago

    Hi Nicholas,

    that’s great!

    Do you remember what kind of error the SQL returned when you tried to execute this query: https://github.com/woocommerce/action-scheduler/issues/587#issuecomment-658168773 ?

    Have a nice day!

Viewing 14 replies - 1 through 14 (of 14 total)

The topic ‘Fatal error’ is closed to new replies.