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.
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`[B],
po.products_options_sort_order[/B]
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>
