Forum Replies Created

Viewing 15 replies - 1 through 15 (of 17 total)
  • Thread Starter jstacklin

    (@jstacklin)

    Just as an update to you guys. It seems to be something with that backup in particular as sites from scratch have no issues even with all the same plugins. Thank you very much for your assistance

    Thread Starter jstacklin

    (@jstacklin)

    More information about the server. I am running MySQL version:

    mysqld Ver 5.7.30-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

    Thread Starter jstacklin

    (@jstacklin)

    Hey, @grigaswp I’m sorry for not having much experience within SQL. I ran the first command and got this as a return:

    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘0000-00-00 00:00:00’,
    log_date_local datetime NOT NULL default ‘0000-00-0’ at line 5

    I’m SSH’ed into my server and have the DB selected and am logged in as the user, however it happens if logged in as root as well.

    Again I am sorry for my incompetency. I have never had these issues before.

    Thread Starter jstacklin

    (@jstacklin)

    Also, in addition I think I miscommunicated earlier. This is the first time that Woo has been installed on this setup. Prior setups didn’t use Woo on this site template.

    I am willing to try building the tables manually. Can you advise of all table names needed for the process? Thank you again for your help @grigaswp

    Thread Starter jstacklin

    (@jstacklin)

    New Update!

    When trying to activate the Action Scheduler as a plugin, I get the following (which looks very similar to that of what I showed earlier):

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’action-scheduler-migration’

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/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/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/action-scheduler-3.1.6/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /home/admin/web/jtns.stacklinservices.net/pu in /home/admin/web/jtns.stacklinservices.net/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.

    Learn more about debugging in WordPress.

    Thread Starter jstacklin

    (@jstacklin)

    Another update. Just for fun (I have a backup of the site and a server snapshot so I really don’t care at this point) I deleted the database tables with the plugin active and got the following message:

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wpjs_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-connection’ ORDER BY note_id ASC

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wpjs_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-connection’ ORDER BY note_id ASC

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wpjs_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-subscription’ ORDER BY note_id ASC

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_wc_admin_notes

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    DELETE FROM wpjs_wc_admin_note_actions WHERE note_id = 0

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    SELECT action_id, name, label, query, status, is_primary FROM wpjs_wc_admin_note_actions WHERE note_id = 0

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wpjs_wc_admin_notes WHERE name = ‘wc-update-db-reminder’ ORDER BY note_id ASC

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_wc_admin_notes

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    DELETE FROM wpjs_wc_admin_note_actions WHERE note_id = 0

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    SELECT action_id, name, label, query, status, is_primary FROM wpjs_wc_admin_note_actions WHERE note_id = 0

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_notes’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_wc_admin_notes

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    DELETE FROM wpjs_wc_admin_note_actions WHERE note_id = 0

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_wc_admin_note_actions

    WordPress database error: [Table ‘admin_jt9677.wpjs_wc_admin_note_actions’ doesn’t exist]
    SELECT action_id, name, label, query, status, is_primary FROM wpjs_wc_admin_note_actions WHERE note_id = 0

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’action-scheduler-migration’

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

    Seems to be that Line 44 of Action Scheduler is always causing the issue on anything higher than Version 3.9.3 for me.

    Thread Starter jstacklin

    (@jstacklin)

    @grigaswp Another update for you.

    When installing version 4.0 I get the following:

    Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_actionscheduler_actions a INNER JOIN wpjs_actionscheduler_groups g ON g.group_id=a.group_id AND g.slug=’woocommerce-db-updates’ WHERE a.hook=’woocommerce_run_update_callback’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    When clicking on the “update database” option, it returns the following:

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’woocommerce-db-updates’

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/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.

    Learn more about debugging in WordPress.

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’action-scheduler-migration’

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(225): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

    Thread Starter jstacklin

    (@jstacklin)

    @grigaswp I also tried deactivating old plugins which are no longer supported in 4.2 and got this error:

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_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 ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM wpjs_actionscheduler_groups WHERE slug=’action-scheduler-migration’

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_groups

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpjs_actionscheduler_actions

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/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.

    Learn more about debugging in WordPress.

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT COUNT(DISTINCT claim_id) FROM wpjs_actionscheduler_actions WHERE claim_id != 0 AND status IN ( ‘pending’, ‘in-progress’)

    WordPress database error: [Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wpjs_actionscheduler_actions a WHERE 1=1 AND a.status=’pending’ AND a.scheduled_date_gmt <= ‘2020-06-17 14:24:44’ ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 5

    Thread Starter jstacklin

    (@jstacklin)

    Thank you @grigaswp for your comment!

    I was successfully able to get through the setup using Woo version 3.9.3 from Github. However upon updating the plugin in the WP updates section I now get this error:

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘admin_jt9677.wpjs_actionscheduler_actions’ doesn’t exist in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedu in /home/admin/web/jtns.stacklinservices.net/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/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.

    Thread Starter jstacklin

    (@jstacklin)

    Thank you! It must have been a bad copy/paste on my part (or an issue with my settings for the API key). Thank you so much for guiding me through my mistakes. I hope you have a great day!

    Thread Starter jstacklin

    (@jstacklin)

    AHH-HA!

    Not Responding: The Bitcoin on CoinPayments adapter failed on get_balance(): The API call returned error: Too many errors in the last two minutes from 107.150.18.3 - please fix your code and try again...

    This is the same for the other coins from CP.

    I have double checked the info and have pretty much everything checked in CP settings! The only issue was when I contacted them, Mr.Data said that I had to give an exact IPN return domain, not just the main domain! This is what he said:

    "Make sure to include your IPN script in the URL, ie. https://allcoininvesting.tk/ipn.php - If you don't have an IPN script then you don't need an IPN URL set."

    I hope this helps! Maybe I was just dumb and missed something in the tutorial!

    Thread Starter jstacklin

    (@jstacklin)

    Troubleshooting steps thusfar:

    Disabled CloudFlare traffic, disabled security software, disabled WP Fastest Cache (all now re-enabled). None of these worked.

    Thread Starter jstacklin

    (@jstacklin)

    Well.. Crap. Updated and it still only shows the white bars after a few seconds of loading. I’m in a separate browser, I have the perms set, and it’s updated to the WP Plugin Directory version 2.6.0.

    (sigh)

    Should I wipe the WPPD version and just use the one from the D-S website instead?

    Thread Starter jstacklin

    (@jstacklin)

    Uhh.. For updates in the WP directory 2.5.4 is the latest that is available. Should I try to get it from the d-s site and load it that way?

    Thanks.

    Sorry for the issues.

    Thread Starter jstacklin

    (@jstacklin)

    Further watching came up with this error:
    Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user’s experience. For more help https://xhr.spec.whatwg.org/ for file view-source:https://allcoininvesting.tk/wp-includes/js/jquery/jquery.js?ver=1.12.4

    but I don’t see how that would cause issues.

Viewing 15 replies - 1 through 15 (of 17 total)