• Resolved eriem

    (@eriem)


    Hello,

    after moving my db from a server to another, I encountered a critical error on my website.
    Via ftp I deactivated all the plugins finding that the problem was Woocommerce.

    This is the error

    Un errore di?E_ERROR?è stato causato nella linea?126?del file?/web/htdocs/www.teodoribrothers.it/home/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php. Messaggio di errore:?Uncaught RuntimeException: Errore durante il salvataggio dell'azione: Duplicate entry '0' for key 'PRIMARY' in /web/htdocs/www.teodoribrothers.it/home/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:126 Stack trace: #0 /web/htdocs/www.teodoribrothers.it/home/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(69): ActionScheduler_DBStore->save_action_to_db() #1 /web/htdocs/www.teodoribrothers.it/home/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(327): ActionScheduler_DBStore->save_action() #2 /web/htdocs/www.teodoribrothers.it/home/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(315): ActionScheduler_ActionFactory->store() #3 /web/htdocs/www.teodoribrothers.it/home/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(175): ActionScheduler_ActionFactory->create() #4 /web/htdocs/www.teodoribrothers.it/home/wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/Domain/Services/DraftOrders.php(65): as_schedule_recurring_action() #5 /web/htdocs/www.teodoribrothers.it/home/wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/Domain/Services/DraftOrders.php(57): Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->maybe_create_cronjobs() #6 /web/htdocs/www.teodoribrothers.it/home/wp-includes/class-wp-hook.php(310): Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->install() #7 /web/htdocs/www.teodoribrothers.it/home/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters() #8 /web/htdocs/www.teodoribrothers.it/home/wp-includes/plugin.php(517): WP_Hook->do_action() #9 /web/htdocs/www.teodoribrothers.it/home/wp-admin/admin.php(175): do_action() #10 /web/htdocs/www.teodoribrothers.it/home/wp-admin/plugins.php(10): require_once('...') #11 {main} thrown

    I already read all the topics here but I can’t manage by myself the db tables and I also don’t know which plugins installed using “scheduled actions”.

    I also can’t provide the woo status because I can’t activate woocommerce in any way.

    After that I also tried to downgrade my php version, delete woocommerce and instal it again, but it hasn’t work.

    Please can someone help me to fix this issue?

    very big thanks

Viewing 1 replies (of 1 total)
  • Plugin Support katerinaz – a11n

    (@katerinaz)

    ?Hi there @eriem !
    It appears that you are encountering a database error which is preventing the WooCommerce plugin from initiating and restricting your access to the dashboard.
    The error message suggests a duplicate entry ‘0’ for the key ‘wphe_actionscheduler_actions.PRIMARY’. Generally, this signals potential corruption in your database, likely as a result of multiple actions possessing an identical ID of 0.
    Since you recently migrated your website, it could be beneficial to rerun the migration or database import to rectify the problem.
    If the issue persists after that, then the root may also lie in your database’s auto-increment function not operating correctly.
    If this is the situation, it would be beneficial to communicate with your hosting provider and request an assessment of your database.
    I hope you find the above helpful!

Viewing 1 replies (of 1 total)
  • The topic ‘?Uncaught RuntimeException’ is closed to new replies.