Export Shipping & Order Information

IF I select 1 order per row I am getting error ,how to fix ? version of zencart is 1.5.7c

PHP Fatal error: 1064: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 'ASC

ORDER BY max_num_of_products DESC
LIMIT 1' at line 4 :: SELECT COUNT( * ) AS max_num_of_products
FROM (orders o LEFT JOIN orders_products op ON o.orders_id = op.orders_id), orders_total ot
WHERE o.orders_id = ot.orders_id
AND ot.class = 'ot_shipping' AND date_purchased BETWEEN '2024-07-01 00:00' AND '2024-08-28 23:59' GROUP BY o.orders_id ASC
ORDER BY max_num_of_products DESC
LIMIT 1

Please provide some of the relevant information required when posting a problem

• What version of PHP and MySQL is your server using? (See Admin->Tools->Server Info)
• What version of "Export Shipping & Order Information" are you using? Top tight hand corner of the screen.

From memory, that error was corrected in v1.5.1

PHP 8.2
ZC 2.0.1
Version of Export Shipping is currently 1.5.2.

The plugin is working but I noticed it is creating many PHP Warning: Undefined array key in logs. I believe this because of PHP 8.2.

Here is one of the logs:

[18-Nov-2024 16:07:12 UTC] Request URI: /popadmin/index.php?cmd=shipping_export2, IP address: 104.153.39.18, Language id 1
#0 /public_html/zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php(139): zen_debug_error_handler()
#1 /public_html/popadmin/index.php(28): require('/home/customer/...')
--> PHP Warning: Undefined array key "dload_include" in /public_html/zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php on line 139.

Latest release is v1.5.3 which checks the array keys when a check box is unselected. Currently in mu GitHub https://github.com/OldNGreyBMR/export_shipping_information/releases/tag/ESIv1.5.3

Please use on a TEST version of ZC before committing to a production environment.

Finally had a chance to try 1.5.3. When I click on "Export to Excel" I get 504 - Gateway Timeout after a few minutes. No logs were generated.

As mentioned in other threads a 504 Gateway error is a server/hosting issue. Your server is contacting another server and waiting for a response.
See also 504 Gateway timeout https://www.zen-cart.com/showthread.php?223955-504-Gateway-Timeout

Have you disabled Zen Carts auto checking of version updates in Admin > Configuration > My Store > Show if version update available ?

OldNGrey:

Latest release is v1.5.3 which checks the array keys when a check box is unselected. Currently in mu GitHub https://github.com/OldNGreyBMR/export_shipping_information/releases/tag/ESIv1.5.3

Please use on a TEST version of ZC before committing to a production environment.
I stuffed up with that release.My apologies.

I have a corrected version in the GitHub which covers all combinations of tick boxes ; checks for orders with no products; and fixed the headers so zc2.x doesn't error. I have tested it on zc 158a and zc 2.1.0 with PHP up to 8.34.

Hi there,
I didn't pick up on a surname having " ó " inside it, and it seems to come out in excel as ' ół ' and therefore not importing into my mail software. I guess it is because locale is GB set, and this would only set on German locale? I will be more eagle eyed next time, but just wondered if I need to change charset / locale perhaps to include address components with these elements? Thanks in advance.

ZC 2.1.0
PHP8.2
Export Version 1.5.3

It appears I always download the full list of orders regardless if I uncheck "Include orders already downloaded" or enter a date?

Do you have the "Run in Test Mode" check box selected?

I do not. However I tried several ways and always get the full list. It does generate this error:

[07-Jan-2025 13:13:51 UTC] Request URI: /Admin/index.php?cmd=shipping_export2, IP address: xxx.xx.xx.xx, Language id 1
#0 /zc_plugins/ExportShippingInformation/v1.5.3/admin/shipping_export2.php(286): zen_debug_error_handler()
#1 /popadmin/index.php(28): require('/home/customer/...')
--> PHP Warning: Undefined array key "order_discount" in /zc_plugins/ExportShippingInformation/v1.5.3/admin/shipping_export2.php on line 286.

I do not select order discount when I export.

Thanks

I tried it again with Order Discount selected and got this error message:

[07-Jan-2025 13:23:58 UTC] Request URI: /Adminn/index.php?cmd=shipping_export2, IP address: xxx.xxx.xx.xx, Language id 1
#0 /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php(247): zen_debug_error_handler()
#1 /popadmin/index.php(28): require('/home/customer/...')
--> PHP Warning: Undefined array key "split_name" in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php on line 247

I also do not split the customer name.

Sorry to keep posting but i realized there was more to the log. Full log below:

[07-Jan-2025 13:23:18 UTC] Request URI: /admin/index.php?cmd=shipping_export2, IP address: xx.xx.xx.xx, Language id 1
#0 /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php(247): zen_debug_error_handler()
#1 /popadmin/index.php(28): require('/home/customer/...')
--> PHP Warning: Undefined array key "split_name" in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php on line 247.

[07-Jan-2025 13:23:18 UTC] Request URI: /admin/index.php?cmd=shipping_export2, IP address: xx.xx.xx.xx, Language id 1
#0 /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php(285): zen_debug_error_handler()
#1 /popadmin/index.php(28): require('/home/customer/...')
--> PHP Warning: Undefined array key "order_subtotal" in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php on line 285.

[07-Jan-2025 13:23:18 UTC] Request URI: /admin/index.php?cmd=shipping_export2, IP address: xx.xx.xx.xx, Language id 1
#0 /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php(529): zen_debug_error_handler()
#1 /popadmin/index.php(28): require('/home/customer/...')
--> PHP Warning: Undefined variable $orders_subtotal in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php on line 529.

[07-Jan-2025 13:23:18 UTC] PHP Fatal error: Uncaught Error: Call to a member function RecordCount() on null in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php:529
Stack trace:
#0 /admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php on line 529

[07-Jan-2025 13:23:18 UTC] Request URI: /admin/index.php?cmd=shipping_export2, IP address: xx.xx.xx.xx
--> PHP Fatal error: Uncaught Error: Call to a member function RecordCount() on null in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php:529
Stack trace:
#0 /popadmin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php on line 529.

[07-Jan-2025 13:23:18 UTC] Request URI: /admin/index.php?cmd=shipping_export2, IP address: xx.xx.xx.xx
--> PHP Fatal error: Uncaught Error: Call to a member function RecordCount() on null in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php:529
Stack trace:
#0 /popadmin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php on line 529.

In posting #511 your have an error in zc_plugins/ExportShippingInformation/v1.5.3/admin/shipping_export2.php

but in postings #512 and #513 your errors are in zc_plugins/ExportShippingInformation/v1.5.2/admin/shipping_export2.php

Which version are you really running?

Under the zc_plugins > ExportShippingInformation folder what folders are shown?

There should only be one folder named "v1.5.3"
Somehow you seem to have two version mixed together.

Sorry for the confusion. I went back to V1.5.2 to see if the issue was still present. It was. So both versions I could not filter the download.

I have gone back to V1.5.3.

You have mixed together the files from v152 and v153.

From the console Admin > Modules > Plugin Manager Un-Install all versions of ExportShippingInformation that are listed

Please download a fresh copy of v1.5.3 from the GitHub.

With file manager delete ***all ***files in the "/zc_plugins/ExportShippingInformation/" folder
then copy the v1.5.3 folder from your download to the /zc_plugins/ExportShippingInformation folder

From the Console use Admin > Modules > Plugin Manager to Install ExportShippingInformation and retest.

uninstalled and Deleted all versions of the plugin. Removed the plugin from the files directory, downloaded the plugin from GitHub and reinstalled. It still downloads the complete list of orders.

Attached is the selections I have checked and the error logs:

28-Jan-2025 12:31:31 UTC] Request URI: /admin/index.php?cmd=shipping_export2, IP address: 104.153.39.18, Language id 1
#0 /zc_plugins/ExportShippingInformation/v1.5.3/admin/shipping_export2.php(295): zen_debug_error_handler()
#1 /admin/index.php(28): require('/home/customer/...')
--> PHP Warning: Undefined array key "payment_method" in /zc_plugins/ExportShippingInformation/v1.5.3/admin/shipping_export2.php on line 295.

Zen ver 2.10
Fresh Install but using Updated Database from 1.57 to 2.10..

I'm getting no errors in my log, but it's outputting only the header to a csv file. There are plenty of orders within date range to export.
I've tried removing and adding options.

I was using a version for 1.57 that worked fine..

Not sure where to look??

I just installed ESIVERSION_II: 1.5.3 from the GitHub into a test system ZC2.1.0 with data imported from zc158a and not changing any default settings and all orders are exported from the system.

If you have exported the orders in v1.5.7 they will remain marked as exported when you import the database.

If you ensure "Include orders already downloaded in export." is ticked it will ignore the database settings and export all records that match your selection criteria.

If "Run In Test Mode" is ticked it will not change the database settings.

I just added a pull request on GitHub that modifies installer to automatically install table column 'downloaded_ship' in orders table.
There should be no more need to manually run an sql file before installing.
Please have a look.