Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when editing child split order #18

Open
donwi opened this issue Sep 16, 2019 · 0 comments
Open

Error when editing child split order #18

donwi opened this issue Sep 16, 2019 · 0 comments

Comments

@donwi
Copy link

donwi commented Sep 16, 2019

I have a store running ZC 1.5.5e, with Edit Orders 4.4.2 and Super Orders installed. If an order is split and the child order is opened in EO and anything to do with pricing is edited, then updated, the a blank page coating an error message is generated. The log file shows the following:

[02-Sep-2019 15:27:59 Australia/Sydney] Request URI: /zc_admin/edit_orders.php?page=1&oID=6554&action=update_order, IP address: xxx.xxx.xxx.xxx
#1 trigger_error() called at [/home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/xxxxxx/public_html/zc_admin/includes/classes/editOrders.php:273]
#5 editOrders->initializeOrderShippingTax() called at [/home/xxxxxx/public_html/zc_admin/includes/classes/editOrders.php:155]
#6 editOrders->eoInitializeShipping() called at [/home/xxxxxx/public_html/zc_admin/edit_orders.php:359]

[02-Sep-2019 15:27:59 Australia/Sydney] 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 'WHERE orders_id = 6554
LIMIT 1' at line 3 :: UPDATE zen_orders
SET shipping_tax_rate =
WHERE orders_id = 6554
LIMIT 1 ==> (as called by) /home/xxxxxx/public_html/zc_admin/includes/classes/editOrders.php on line 273 <== in /home/xxxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 167

If an additional product is added to the child order, or removed, then editing pricing works correctly.

I have been in contact with the author of Edit Orders (lat9), who has determined that:
"the generation of an order without an 'ot_shipping' component on a site that has
'ot_shipping' enabled is non-standard." lat9 has also raised an issue against Edit Orders.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant