Edit Orders v4.0 Support Thread

[lat9]

Had a search through the thread and couldnt find anything so excuse me for asking.
Is there any easy way to edit the COD fees that result of using that module?
Thanks

Since the output of the built-in ot_cod_fee.php module is automatically calculated (i.e. not a user-input), the answer is "No".

[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.