Edit Orders v4.0 Support Thread

[swguy]

You might be able to use OT Edit to modify the COD fee.

https://www.zen-cart.com/downloads.php?do=file&id=2245

[Reesy]

Thanks for the replies, it used to be possible in the Diva Vocals version.
I will check the Order Total mod out, thanks kindly.

[wyliecoyoteuk]

ZC 2.0.1, EO 5.0.1, PHP 8.3.6, MySQL 8.0.42, Ubuntu Linux 24.04.3 LTS, Kernel Linux 6.8.0-71-generic

Can't add products to order, I can edit product totals, but if I try to add a product, I can select it, but the choose button does nothing.
This probably something I have done, just need a clue.
Sorry, but not sure if this happened when I upgraded to the new server a few months ago, or since then (this is not a busy site, it is just for my daughter's shop stockists).

Getting this error.

#0 [internal function]: zen_debug_error_handler()
#1 /var/www/html/wsgd.co.uk/includes/classes/db/mysql/query_factory.php(733): trigger_error()
#2 /var/www/html/wsgd.co.uk/includes/classes/db/mysql/query_factory.php(678): queryFactory->show_error()
#3 /var/www/html/wsgd.co.uk/includes/classes/db/mysql/query_factory.php(307): queryFactory->set_error()
#4 /var/www/html/wsgd.co.uk/zc_plugins/EditOrders/v5.0.1/admin/includes/classes/EoAttributes.php(66): queryFactory->Execute()
#5 /var/www/html/wsgd.co.uk/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php(510): Zencart\Plugins\Admin\EditOrders\EoAttributes->__construct()
#6 /var/www/html/wsgd.co.uk/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php(466): zcAjaxEditOrdersAdmin->getNewProductDefaultAttributes()
#7 /var/www/html/wsgd.co.uk/ajax.php(77): zcAjaxEditOrdersAdmin->newProductChosen()
#8 /var/www/html/wsgd.co.uk/shopmanager/ajax.php(17): require('...')
--> PHP Fatal error: MySQL error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'Zencart.po.products_options_sort_order' which is not in SELECT list; this is incompatible with DISTINCT :: SELECT DISTINCT po.products_options_id AS `id`, po.products_options_name AS `name`,
                    po.products_options_type AS `type`, po.products_options_length AS `length`,
                    po.products_options_size AS `size`, po.products_options_rows AS `rows`
               FROM products_attributes pa
                    INNER JOIN products_options po
                        ON po.products_options_id = pa.options_id
                       AND po.language_id = 1 
              WHERE pa.products_id = 322 ORDER BY LPAD(po.products_options_sort_order, 11, '0'), po.products_options_name ==> (as called by) /var/www/html/wsgd.co.uk/zc_plugins/EditOrders/v5.0.1/admin/includes/classes/EoAttributes.php on line 66 <== in /var/www/html/wsgd.co.uk/includes/classes/db/mysql/query_factory.php on line 733.

[lat9]

ZC 2.0.1, EO 5.0.1, PHP 8.3.6, MySQL 8.0.42, Ubuntu Linux 24.04.3 LTS, Kernel Linux 6.8.0-71-generic

Can't add products to order, I can edit product totals, but if I try to add a product, I can select it, but the choose button does nothing.
This probably something I have done, just need a clue.
Sorry, but not sure if this happened when I upgraded to the new server a few months ago, or since then (this is not a busy site, it is just for my daughter's shop stockists).

Getting this error.

#0 [internal function]: zen_debug_error_handler()
#1 /var/www/html/wsgd.co.uk/includes/classes/db/mysql/query_factory.php(733): trigger_error()
#2 /var/www/html/wsgd.co.uk/includes/classes/db/mysql/query_factory.php(678): queryFactory->show_error()
#3 /var/www/html/wsgd.co.uk/includes/classes/db/mysql/query_factory.php(307): queryFactory->set_error()
#4 /var/www/html/wsgd.co.uk/zc_plugins/EditOrders/v5.0.1/admin/includes/classes/EoAttributes.php(66): queryFactory->Execute()
#5 /var/www/html/wsgd.co.uk/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php(510): Zencart\Plugins\Admin\EditOrders\EoAttributes->__construct()
#6 /var/www/html/wsgd.co.uk/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php(466): zcAjaxEditOrdersAdmin->getNewProductDefaultAttributes()
#7 /var/www/html/wsgd.co.uk/ajax.php(77): zcAjaxEditOrdersAdmin->newProductChosen()
#8 /var/www/html/wsgd.co.uk/shopmanager/ajax.php(17): require('...')
--> PHP Fatal error: MySQL error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'Zencart.po.products_options_sort_order' which is not in SELECT list; this is incompatible with DISTINCT :: SELECT DISTINCT po.products_options_id AS `id`, po.products_options_name AS `name`,
                    po.products_options_type AS `type`, po.products_options_length AS `length`,
                    po.products_options_size AS `size`, po.products_options_rows AS `rows`
               FROM products_attributes pa
                    INNER JOIN products_options po
                        ON po.products_options_id = pa.options_id
                       AND po.language_id = 1 
              WHERE pa.products_id = 322 ORDER BY LPAD(po.products_options_sort_order, 11, '0'), po.products_options_name ==> (as called by) /var/www/html/wsgd.co.uk/zc_plugins/EditOrders/v5.0.1/admin/includes/classes/EoAttributes.php on line 66 <== in /var/www/html/wsgd.co.uk/includes/classes/db/mysql/query_factory.php on line 733.

Change line 47 of /zc_plugins/EditOrders/v5.0.1/admin/includes/classes/EoAttributes.php from

        $sql =
            "SELECT DISTINCT po.products_options_id AS `id`, po.products_options_name AS `name`,
                    po.products_options_type AS `type`, po.products_options_length AS `length`,
                    po.products_options_size AS `size`, po.products_options_rows AS `rows`
               FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa
                    INNER JOIN " . TABLE_PRODUCTS_OPTIONS . " po
                        ON po.products_options_id = pa.options_id
                       AND po.language_id = :language_id 
              WHERE pa.products_id = :products_id";

to

        $sql =
            "SELECT DISTINCT po.products_options_id AS `id`, po.products_options_name AS `name`,
                    po.products_options_type AS `type`, po.products_options_length AS `length`,
                    po.products_options_size AS `size`, po.products_options_rows AS `rows`,
                    po.products_options_sort_order
               FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa
                    INNER JOIN " . TABLE_PRODUCTS_OPTIONS . " po
                        ON po.products_options_id = pa.options_id
                       AND po.language_id = :language_id 
              WHERE pa.products_id = :products_id";

When you view the admin's Tools / Server/Version Info, what displays for the MySQL Mode?

GitHub tracking issue created: https://github.com/lat9/edit_orders/issues/330

[wyliecoyoteuk]

MySQL Mode: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION

[wyliecoyoteuk]

Made that change, fixed it, thank you!

[lat9]

MySQL Mode: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION

Made that change, fixed it, thank you!

Thanks for both updates; I'll be getting EO v5.0.2 released sometime this week and it'll contain this correction.

[lat9]

v5.0.2 of Edit Orders is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2400

This release contains changes associated with these GitHub issues:

#325: Correct constant misspelling for read-only attributes (causing PHP missing-constant error).
#326: Correct PHP notice when flushing empty output-buffer.
#328: Correct PHP warnings when editing a product with read-only attributes.
#330: Correct MySQL 8.0 ORDER BY clause not in SELECT list.

[swguy]

Checking if you have seen these Debug Logs. ZC 2.1.0, EO 5.0.1.

[02-Sep-2025 17:28:00 America/New_York] Request URI: /admin/ajax.php?act=ajaxEditOrdersAdmin&method=getChangesModal, IP address: 142.112.72.55, Language id 1
#0 /home/client/public_html/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php(171): zen_debug_error_handler()
#1 /home/client/public_html/ajax.php(77): zcAjaxEditOrdersAdmin->getChangesModal()
#2 /home/client/public_html/admin/ajax.php(17): require('/home/client/pu...')
--> PHP Warning: Undefined array key "eoChanges" in /home/client/public_html/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php on line 171.

----

[02-Sep-2025 17:30:04 America/New_York] Request URI: /admin/ajax.php?act=ajaxEditOrdersAdmin&method=newProductChosen, IP address: 142.112.72.55, Language id 1
#0 /home/client/public_html/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php(459): zen_debug_error_handler()
#1 /home/client/public_html/ajax.php(77): zcAjaxEditOrdersAdmin->newProductChosen()
#2 /home/client/public_html/admin/ajax.php(17): require('/home/client/pu...')
--> PHP Warning: Undefined array key "eoChanges" in /home/client/public_html/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php on line 459.
---

[03-Sep-2025 10:30:37 America/New_York] Request URI: /admin/ajax.php?act=ajaxEditOrdersAdmin&method=addNewProductStart, IP address: 70.55.17.45, Language id 1
#0 /home/client/public_html/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php(625): zen_debug_error_handler()
#1 /home/client/public_html/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php(399): zcAjaxEditOrdersAdmin->getModalContent()
#2 /home/client/public_html/ajax.php(77): zcAjaxEditOrdersAdmin->addNewProductStart()
#3 /home/client/public_html/admin/ajax.php(17): require('/home/client/pu...')
--> PHP Warning: Undefined array key "eoChanges" in /home/client/public_html/zc_plugins/EditOrders/v5.0.1/catalog/includes/classes/ajax/zcAjaxEditOrdersAdmin.php on line 625.

[dbltoe]

Using 5.02. here, and no such array key found with Developer's Tool Kit.