Export Shipping & Order Information

[diptimoy]

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

[OldNGrey]

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

[n8pbm]

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.

[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/expor.../tag/ESIv1.5.3

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

[n8pbm]

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.

[OldNGrey]

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....ateway-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/expor.../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.

[HeathenMagic]

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.

[n8pbm]

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?

[OldNGrey]

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