Page 7 of 7

Re: [MOD/vQmod] - Only Generate Single Temp Order Id

Posted: Sat Jul 20, 2019 10:00 pm
by valdas
hi Q

I have installed this oc2.3.0.2 and after second time coming to step 6 I am getting the following error.

Fatal error: Uncaught Exception: Error: Unknown column 'order_id' in 'where clause'<br />Error No: 1054<br />DELETE FROM `vp_order_status_auto` WHERE order_id = '615' in /home/vpflower/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/vpflower/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_db.php(110): DB\MySQLi->query('DELETE FROM `vp...', Array) #1 /home/vpflower/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_checkout_order.php(87): DB->query('DELETE FROM `vp...') #2 /home/vpflower/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(178): ModelCheckoutOrder->addOrder(Array) #3 /home/vpflower/public_html/system/engine/proxy.php(25): Loader->{closure}(Array, Array) #4 /home/vpflower/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_checkout_confirm.php(328): Proxy->__call('addOrder', Array) #5 /home/vpflower/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_action.php(51): Cont in /home/vpflower/public_html/system/library/db/mysqli.php on line 40

Can you advise how to fix this? Thanks

Re: [MOD/vQmod] - Only Generate Single Temp Order Id

Posted: Tue Jul 23, 2019 5:43 pm
by cedcommerceteam
Hi Valdas,

Please check whether `order_id` exist in `vp_order_status_auto` table, if yes than add a check for `order_id` > 0 then Delete that order otherwise do not delete & show a message order doesn't exist.

I hope this will help you, if not then explain us l'll bit more.

Thanks & Regards :

Re: [MOD/vQmod] - Only Generate Single Temp Order Id

Posted: Wed Aug 07, 2019 3:13 am
by rlasmar
Sometimes I get this error, only sometimes. I mean between 50 orders, I receive this error one or two times.

Code: Select all

PHP Notice:  Undefined variable: order_id
File: catalog/model/checkout/order.php


Re: [MOD/vQmod] - Only Generate Single Temp Order Id

Posted: Sat Dec 14, 2019 10:47 pm
by rlasmar
Hi I am having problem using this extension with fields custom field. Opencart

In the checkout, When I choose to register a new shipping address, it changes the address correctly and shows everything right in front of the store.
I move on to finalize the order, so far so good.

however, within the order history in admin, it is showing the custom fields of the old address. it's like taking data from the previous session or getting something cached

Steps to reproduce this error:
1. Go to checkout step 6 payment confirmation
2. Back to step 3 - add new delivery address (It must have custom fields in the register form, in my store I have the custom field "number")
3. Go to step 6 again and confirm the order.
4. Go to admin - and check this order you just made
5. Check the delivery address - The custom field is taking data from the old address (The error is only in custom field, all the rest from data like address, city, name are correct)