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.

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.

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.

Thanks for the info. That kinda sucks. At least I know why it doesn’t work now.