[SOLVED] Checkout SQL error

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.6.0
-- PHP version -- : 5.5.36
-- Browser(s) name and version -- : FF, Chrome, Edge - all updated to most recent versions
-- Error-message(debug-mod must be tuned on) -- : SQL error display

When I log in as a client user, purchase the client product, update the billing address and click 'Finish', I get this display on the 'step-2' of the checkout process:

IGNORE INTO `#__hikashop_order` ( `order_user_id`,`order_status`,`order_shipping_address_id`,`order_billing_address_id`,`order_currency_id`,`order_currency_info`,`order_type`,`order_full_price`,`order_tax_info`,`order_shipping_price`,`order_shipping_tax`,`order_payment_price`,`order_discount_tax`,`order_discount_price`,`order_payment_id`,`order_payment_method`,`products`,`order_created`,`order_ip`,`order_modified`,`order_serial_params` ) VALUES ( '11','created','14','14','2','O:8:\"stdClass\":4:{s:13:\"currency_code\";s:3:\"USD\";s:13:\"currency_rate\";s:7:\"1.11570\";s:20:\"currency_percent_fee\";s:4:\"0.00\";s:17:\"currency_modified\";s:10:\"1469302235\";}','sale','0.99','a:1:{s:0:\"\";O:8:\"stdClass\":3:{s:11:\"tax_namekey\";s:0:\"\";s:8:\"tax_rate\";s:7:\"0.00000\";s:10:\"tax_amount\";i:0;}}','0','0','0','0','0','1','authorize','','1469303415','69.246.184.174','1469303415','{\"order\":[],\"product\":[],\"order_product\":[],\"serial\":[]}' )

Nicolas,

Activated debug with maximum setting. Did a checkout on both Firefox and Chrome. On Chrome it was a straight product (program) purchase with no coupon linkage. On Firefox, it was a product linked to the coupon in HikaSerial. Checkout went normally, redirection to Authorize.net payment gateway went fine, after payment, I got a message:

"Thank you for your purchase.
You can go back to the shop by clicking on this link" on the "https://secure.authorize.net/gateway/transact.dll" page.

Pack Name 	Serial Data 	Assign date 	Attached to product
Divorce Toolbox - Divorcing with Children 	uVhlYQuN 	2016-07-25 15:09 	Divorcing with Children Coupon

Nicolas,

Did some test and here is what I 'think' is happening.

If I order a product, go to the checkout without being logged in, which displays the login section on the left, I enter the username and password to login on the checkout page, click the next and it displays the user address info on the left on the 'step' three of the checkout, click next, I get the SQL checkout error, even though 'error reporting' in the Joomla configuration is disabled (None).

If I go back to the checkout 1st page using the browser back buttons (actually right-clicking the back button and selecting the first Checkout Page option, it loads the check out page, I am already logged in, click next, it displays the user address info on the left, click next, it goes to Authorize.net, I pay, return and it goes to the 'Thank you' page, which is what it is suppose to do.

So it appears that if you go to the checkout without being logged in, it is causing this SQL error on the final checkout page. That seems weird.

Now I can 'force' them to login first before proceeding with checkout but the client prefers that they get to the checkout page first whether they are logged in or not. There is NO guest checkout.

Any ideas on why this is happening?

Nicolas, GREMLINS!!!!

Now I "can't" reproduce the problem. Tried several different ways and the cart is working.

I am not an idiot as it did give me that SQL message on three different attempts. Technology is great....when it works.