PHP Error crashing database

  • Add on suddenly crashing the database every time I try to export a report. I’m guessing it’s to do with the add on not being updated yet for WordPress 6.6 (released mid July), is that in the pipeline and if so when will the add on be made compatible with the current version of WordPress?

    Error from Server log:

    Got error ‘PHP message: PHP Fatal error: Uncaught TypeError: mysqli_get_server_info(): Argument #1 ($mysql) must be of type mysqli, null giv…………ailpoet/vendor/woocommerce/action-scheduler/classes/abstracts/ActionScheduler_Store.php(41): ActionScheduler_DBStore->query_actions()\n#4 /home/923254.cloudwaysapp…’, referer: https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export

    • This topic was modified 3 months, 3 weeks ago by cononew.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author algol.plus

    (@algolplus)

    hello

    Our plugin doesn’t use ActionScheduler module.
    Please, disable our plugin and check if you still see this error in logs.

    Or review webserver logs, we need full error message.

    Thread Starter cononew

    (@cononew)

    With your add-on disabled, I can’t get the error, as it only occurs when I click “Export” on the Export now tab of your add-on.

    Here’s the Apache Error logs from my server.

    Mon Aug 05 15:16:39.553536 2024

    [proxy_fcgi:error [pid 390925:tid 391145 [client 86.41.16.92:0 AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught TypeError: mysqli_get_server_info(): Argument #1 ($mysql) must be of type mysqli, null giv…………kages/action-scheduler/classes/abstracts/ActionScheduler_Store.php(118): ActionScheduler_DBStore->query_actions()\n#4 /home/923254.cloudwaysapps.com/ykjjajhreu/pub…’, referer: https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export

    Mon Aug 05 15:16:37.224794 2024

    [proxy_fcgi:error [pid 390828:tid 391068 [client 86.41.16.92:0 AH01071: Got error ‘PHP message: WordPress database error MySQL server has gone away for query SELECT session_value FROM wp_woocommerce_sessions WHERE…………on: MySQL server has gone awayPHP message: Caught exception while enqueuing action “woocommerce_cleanup_draft_orders”: Error saving action: MySQL server has gone away’, referer: https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export

    Here’s the Apache Access Logs for the same period:

    Aug 5 15:16:54

    86.41.xx.xx

    GET / HTTP/1.0" 500 2764 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:36

    161.35.xx.xx

    POST /wp-cron.php?doing_wp_cron=1722870996.0497360229492187500000 HTTP/1.0" 200 259 "-" "WordPress/6.6.1; https://ginkgotattoosupplies.ink

    Aug 5 15:16:34

    86.41.xx.xx

    GET /wp-admin/admin.php?page=wc-order-export&tab=tools HTTP/1.0" 500 3450 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Aug 5 15:16:34

    86.41.xx.xx

    POST /wp-admin/admin-ajax.php HTTP/1.0" 200 782 "https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36

    Here’s the PHP Access logs for the same time period:

    Aug 5 15:16:37

    86.41..xx.xx

    GET /wp-admin/admin.php?page=wc-order-export&tab=tools" 500 0 - 35423 515710 0.019 18874368 51.55% 0.00% "/wp-admin/admin.php?page=wc-order-export&tab=tools

    Aug 5 15:16:37

    86.41..xx.xx

    POST /wp-admin/admin-ajax.php" 200 129 - 35423 515710 0.007 10485760 0.00% 0.00% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    86.41..xx.xx

    POST /wp-admin/admin-ajax.php" 200 85 - 35423 515710 0.007 6291456 0.00% 147.38% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    86.41..xx.xx

    POST /wp-admin/admin-ajax.php" 200 85 - 35423 515710 0.007 4194304 0.00% 0.00% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    86.41..xx.xx

    POST /wp-admin/admin-ajax.php" 200 144 - 35423 515710 0.007 2097152 152.23% 0.00% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    86.41..xx.xx

    POST /wp-admin/admin-ajax.php" 200 126 - 35423 515710 0.007 2097152 0.00% 0.00% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    86.41..xx.xx

    POST /wp-admin/admin-ajax.php" 200 276 - 35423 515710 0.007 2097152 143.68% 0.00% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    86.41..xx.xx

    POST /wp-admin/admin-ajax.php" 200 152 - 35423 515710 0.007 2097152 0.00% 0.00% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    86.41..xx.xx

    POST /wp-admin/admin-ajax.php" 200 140 - 35423 515710 0.007 2097152 146.93% 0.00% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    86.41..xx.xx

    POST /wp-admin/admin-ajax.php" 200 90 - 35423 515710 0.007 2097152 0.00% 146.50% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    86.41.16.92

    POST /wp-admin/admin-ajax.php" 200 105 - 35423 515710 0.007 2097152 0.00% 0.00% "/wp-admin/admin-ajax.php

    Aug 5 15:16:37

    161.35..xx.xx

    POST /wp-cron.php?doing_wp_cron=1722870996.0497360229492187500000" 200 0 - 35423 515710 0.008 2097152 129.52% 0.00% "/wp-cron.php?doing_wp_cron=1722870996.0497360229492187500000

    Aug 5 15:15:29

    86.41.xx.xx

    GET /wp-admin/admin.php?page=wc-order-export&tab=tools" 500 0 - 35423 515676 106.915 37748736 0.18% 1.86% "/wp-admin/admin.php?page=wc-order-export&tab=tools

    So the exact process is , I open the Export Orders tab, set the date range, and click Export. The Database crashes, wordpress can’t access it. I log in to Cloudways and get it going again. So I don’t know if there’s any conflict there, are their any particular known conflicts? I have added no new add on to my site in over a year, just keep the ones on it up to date. Last time I ran this report was on July 22nd and it worked fine then.

    Plugin Author algol.plus

    (@algolplus)

    please, switch format from XLS to CSV and set small date range (1 day).
    press Preview — how many records(estimation) will you see ?

    press “Export [w/o progress]” – wIll you get data?

    Thread Starter cononew

    (@cononew)

    It worked as a CSV file with no issues, tried with a range of one day and then a range of 20 days, it had no issue producing the file. It seems to only have an issue with the xls format.

    Plugin Author algol.plus

    (@algolplus)

    please try XLS for one day now

    Thread Starter cononew

    (@cononew)

    The Preview works, shows 2 entries, the export causes the crash straight away.

    Error in Server Apache log below:

    [proxy_fcgi:error?[pid 390925:tid 391156?[client 86.41.16.92:0?AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught TypeError: mysqli_get_server_info(): Argument #1 ($mysql) must be of type mysqli, null giv…………ailpoet/vendor/woocommerce/action-scheduler/classes/abstracts/ActionScheduler_Store.php(41): ActionScheduler_DBStore->query_actions()\n#4 /home/923254.cloudwaysapp…’, referer: https://ginkgotattoosupplies.ink/wp-admin/admin.php?page=wc-order-export

    • This reply was modified 3 months, 3 weeks ago by cononew.
    Plugin Author algol.plus

    (@algolplus)

    This error message is too short .

    please, visit >WooCommerce>Status>Scheduled Actions and review jobs .
    Probably, you will figure which plugin added job which fails.

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.