• Hello, I’ve been getting errors with my website for a while.
    When I try to add or delete a plugin, a critical error occurred in the website frontend. Email goes to admin mail, restore admin link does not open admin panel (same critical error message appears).

    The last email was as follows:
    ——-

    Hi!
    
    In this case, WordPress caught an error in one of your plugins, WooCommerce.
    
    First, visit your website (https://****/) and check for any visible issues. Next, visit the page where the error occurred (https://*****/wp-admin/plugins.php?deactivate=true&plugin_status=all&paged=1&s=) and check if there are any visible problems.
    
    Please contact your hosting company for assistance in further investigating this issue.
    
    ******
    
    If you seek help with this issue, you may be asked for some of the following information:
    WordPress version 5.9.3
    Active theme: mt (version 1.0.0)
    Current plugin: WooCommerce (version 6.4.1)
    PHP version 8.0.17
    
    Error Details
    ==============
    An error of type E_ERROR was detected in line 44 of file /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration /ActionScheduler_DBStoreMigrator.php. Error message: Uncaught RuntimeException: Error saving action: Error saving action: INSERT command denied to user 'o1972279'@'ivmiss.swh.1u1.it' for table 'jpsn_actionscheduler_actions' in /mnt/web123/c3/34/ 51234634/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
    Stack trace:
    #0 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action()
    #1 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action ()
    #2 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store ()
    #3 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single()
    #4 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/Scheduler.php(89): as_schedule_single_action( )
    #5 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/Controller.php(119): Action_Scheduler\ Migration\Scheduler->schedule_migration()
    #6 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-includes/class-wp-hook.php(307): Action_Scheduler\Migration\Controller->schedule_migration()
    #7 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters()
    #8 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-includes/plugin.php(474): WP_Hook->do_action()
    #9 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-settings.php(609): do_action()
    #10 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-config.php(111): require_once('...')
    #11 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-load.php(50): require_once('...')
    #12 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-admin/admin.php(34): require_once('...')
    #13 /mnt/web123/c3/34/51234634/htdocs/STRATO-apps/wordpress_01/app/wp-admin/plugins.php(10): require_once('...')
    #14 {main}
      thrown
    
    -------
    In a previous issue with WooCommerce, the site gave the same error. I solved this by deleting the plugins/woocommerce file via FTP and re-downloading and installing it from the store. Could the plugin be corrupt at this point?
    -----
    
    This problem also affects my backup of my site via a plugin.
    The files are copied successfully, but when it comes to the database, it gets stuck at 0%.
    
    Thinking it was a database related error, I ran database repair and got this error report:
    
    jpsn_woocommerce_gzd_dhl_labelmeta: Table 'dbs1972279.jpsn_woocommerce_gzd_dhl_labelmeta' doesn't exist
    jpsn_woocommerce_gzd_dhl_labels: Table 'dbs1972279.jpsn_woocommerce_gzd_dhl_labels' doesn't exist
    
    These two tables appear when I check from phpmyadmin.

    Thanks in advance

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hello @dbe01

    This issue is documented on the Action Scheduler GitHub page and related to an internal DB migration and missing table.

    The is a solution in the issue thread.

    https://github.com/woocommerce/action-scheduler/issues/631

    In most of the single installations, all the tables were present, but for some reason, value for this option schema-ActionScheduler_StoreSchema was not updating to the latest AS version, so please use this one-time code:

    add_action( 'init', function() { delete_option( 'schema-ActionScheduler_StoreSchema' ); } );

    You can put this snippet in your theme’s functions.php, visit the site and delete it when the error has gone

    Thanks

    • This reply was modified 4 years, 1 month ago by Aezaz Shekh.
    Thread Starter dbe01

    (@dbe01)

    Hello, I added the code you said to the last line of functions.php. But there still seems to be a problem with the database. For example, my backup plugin scans the files without any problems, but when it comes to the database, it gets stuck at 0%. The site is active now, but can crash at any plugin status change (it’s happened many times before).

    I am not an expert in these matters, but I think I can achieve it with guidance.

    Thank you in advance for your response.

    Thread Starter dbe01

    (@dbe01)

    hello, I just realized that my database is pretty bloated with these two records.
    Any idea what’s going on?

    jpsn_actionscheduler_actions 944 mb
    jpsn_actionscheduler_logs 670 mb

    Thanks in advance.

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

The topic ‘Error : Your website has a technical problem’ is closed to new replies.