SQL error

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.5.1
-- PHP version -- : 5.4.43
-- Browser(s) name and version -- : Firefox Developer Edition 48.0a2 (2016-05-31)
-- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM #__hikashop_address WHERE address_id =

While trying to confirm an order of a client in the backend we get a SQL error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM #__hikashop_address WHERE address_id =

Seemed I spoke to soon.... The error returned.

It seem that when I directly try to alter the order status in the list view from , the SQL error is presented (although the order status is altered!).

$db->setQuery('SELECT address_id FROM '.hikashop_table('address').' WHERE address_user_id = '. (int)$user_id . ' AND address_published = 1 ORDER BY address_default DESC, address_id ASC LIMIT 1');

Hello,

Can you click on the "Check database" button via "Hikashop->System->Configuration" and test it again after the check is complete ?

Thank you.

Everything seems to be allright at first glance:

OK Table "hikashop_address" checked

OK Table "hikashop_badge" checked

OK Table "hikashop_banner" checked

OK Table "hikashop_cart" checked

OK Table "hikashop_cart_product" checked

OK Table "hikashop_category" checked

OK Table "hikashop_characteristic" checked

OK Table "hikashop_click" checked

OK Table "hikashop_config" checked

OK Table "hikashop_currency" checked

OK Table "hikashop_discount" checked

OK Table "hikashop_download" checked

OK Table "hikashop_entry" checked

OK Table "hikashop_field" checked

OK Table "hikashop_file" checked

OK Table "hikashop_filter" checked

OK Table "hikashop_geolocation" checked

OK Table "hikashop_history" checked

OK Table "hikashop_limit" checked

OK Table "hikashop_massaction" checked

OK Table "hikashop_order" checked

OK Table "hikashop_order_product" checked

OK Table "hikashop_payment" checked

OK Table "hikashop_price" checked

OK Table "hikashop_product" checked

OK Table "hikashop_product_category" checked

OK Table "hikashop_product_related" checked

OK Table "hikashop_plugin" checked

OK Table "hikashop_shipping" checked

OK Table "hikashop_shipping_price" checked

OK Table "hikashop_tax" checked

OK Table "hikashop_taxation" checked

OK Table "hikashop_user" checked

OK Table "hikashop_variant" checked

OK Table "hikashop_vote" checked

OK Table "hikashop_vote_user" checked

OK Table "hikashop_waitlist" checked

OK Table "hikashop_widget" checked

OK Table "hikashop_zone" checked

OK Table "hikashop_zone_link" checked

OK Table "hikashop_warehouse" checked

OK Table "hikashop_email_log" checked

OK Product categories checked

OK Variants orphan links cleaned

To speed things up I've set up a temporary copy of the site on our LAN. Who might I PM to send the login and URL?

Hello,

i have the same problem !!! Exactly !

Can you give me a solution ???

Thank you !!!

I still have to send them the credentials for my testing server. I will do so this evening and I will post any answer I might receive here.

Meanwhile, it might interest you that you can still confirm an order (or alter the status of the order) by clicking on the order number to view the details of the order.

Change the details and save your new status like that. I didn't get any error working like this.

If needed you see this in more detail (with images, although in dutch) over here: https://vaconi.com/klanten/ondersteuning/ticket/trouble-tickets/67-bestelling-bevestigen-lukt-niet

Thank you for your quick response !

I can still confirm an order (or alter the status of the order) by clicking on the order number to view the details of the order.
It's ok for me

Thank you !

Thanks for the great support, I'll have a look at the Invoice manager extension and if needed contact Joomlathat.

I posted a (positive) review in the Joomla Extension Directory for Hikashop.

@fafamaster: I'll keep you posted on the Invoice manager issue if I get to know exactly what triggers the error.

Thank you very much to all !

Nicolas thank you for your return ausi always effective, and thank you for vaconiit back!

Germinal Camps of Joomlathat! was quick to respond.

It seemed there was a new version of the plugin available that solved the issue, but it was not published in the Invoice Manager downloads section.

Installing this new version of the plugin did resolve the issue.

More info can be found in the the Joomlathat! Forum

Thank you for the investigation !!!!!

But where is the version 2.0.2 of plugin joomlathat
?