Hello
When i select bank transfer as payment method during check out, order is successfully placed but on back end, same order is repeated several times with order ID " 0 " and product is displayed multiples times.
see attachment, what could be the possible error? I have set order status correctly every where.
No OC version posted. No attachment posted as indicated above.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Which payment provider are you using?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Are you noticing the order ID of 0 from the admin API or from checkout?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I see these order ID in admin panel under orders. It only happens when i select Bank transfer as payment method.
Order is submitted successfully after pressing confirm button but no order confirmation email comes through to store email address.
I have even created new order status and applied this to Bank Transfer but it doing same.
Order is submitted successfully after pressing confirm button but no order confirmation email comes through to store email address.
I have even created new order status and applied this to Bank Transfer but it doing same.
OC v2.0.3.0 is rather old. I would suggest to upgrade to a higher version to solved most of the encountered issues that were reported in the past; at least to v2.3.0.2 release.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Im using 2.0.3.2
Found one more bug.. when i register as a customer and try to login, it says Warning: No match for E-Mail Address and/or Password.
When i see this newly created account in admin side, under the address, its showing 6 different addresses of all those accounts which were created recently by different users.
Found one more bug.. when i register as a customer and try to login, it says Warning: No match for E-Mail Address and/or Password.
When i see this newly created account in admin side, under the address, its showing 6 different addresses of all those accounts which were created recently by different users.
Consider the above suggestion. Most of the issues will already be fixed in anyhow.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
More problems do not explain in details what are the actual issues to those problems. Create a new topic in the v3.x releases section of the forum (general support) so for supporters to assist you with those encountered issues.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
here is the error log from admin folder
[22-Mar-2018 22:01:56 UTC] PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT *, (SELECT CONCAT(c.firstname, ' ', c.lastname) FROM oc_customer c WHERE c.customer_id = o.customer_id) AS customer, (SELECT os.name FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS order_status FROM `oc_order` o WHERE o.order_id = '4683'' in /home/xxx/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/xxx/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT *, (SELE...', Array)
#1 /home/xxx/public_html/admin/model/sale/order.php(19): DB->query('SELECT *, (SELE...')
#2 [internal function]: ModelSaleOrder->getOrder('4683')
#3 /home/xxx/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(193): call_user_func_array(Array, Array)
#4 [internal function]: Loader->{closure}(Array, Array)
#5 /home/xxx/public_html/system/engine/proxy.php(25): call_user_func_array(Object(Clos in /home/xxx/public_html/system/library/db/mysqli.php on line 40
[22-Mar-2018 22:01:56 UTC] PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT *, (SELECT CONCAT(c.firstname, ' ', c.lastname) FROM oc_customer c WHERE c.customer_id = o.customer_id) AS customer, (SELECT os.name FROM oc_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS order_status FROM `oc_order` o WHERE o.order_id = '4683'' in /home/xxx/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/xxx/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT *, (SELE...', Array)
#1 /home/xxx/public_html/admin/model/sale/order.php(19): DB->query('SELECT *, (SELE...')
#2 [internal function]: ModelSaleOrder->getOrder('4683')
#3 /home/xxx/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(193): call_user_func_array(Array, Array)
#4 [internal function]: Loader->{closure}(Array, Array)
#5 /home/xxx/public_html/system/engine/proxy.php(25): call_user_func_array(Object(Clos in /home/xxx/public_html/system/library/db/mysqli.php on line 40
The database queries from the core were mostly re-worked on the more recent OC versions. This error shows a conflict or subqueries.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: No registered users and 66 guests
