[Skip to main content](#vessel-content) # SQL error ## - **[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")** - [![vaconiit's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35152.jpg)](/forum/user/35152-vaconiit "View vaconiit's Profile") Topic Author - [ Offline](/forum/user/35152-vaconiit) Less More - Posts: 16 - Thank you received: 2 - - 10 years 4 months ago - 10 years 4 months ago [\#241830](#241830) by [vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile") *[SQL error](/forum/35-orders-management/884864-sql-error#241830 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* was created by *[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")* -- 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: Code: 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 = Any idea what might trigger this? [ ![[img](http://justlovepaint.be/images/justlovepaint-bestelling.jpg) ](http://justlovepaint.be/images/justlovepaint-bestelling.jpg "[img") Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience... Last edit: 10 years 4 months ago by [vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile"). Reason: Found the reason The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")** - [![vaconiit's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35152.jpg)](/forum/user/35152-vaconiit "View vaconiit's Profile") Topic Author - [ Offline](/forum/user/35152-vaconiit) Less More - Posts: 16 - Thank you received: 2 - - 10 years 4 months ago [\#241854](#241854) by [vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile") Replied by *[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#241854 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* 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!). [ ![[img](https://vaconi.com/images/support/order1.jpg) ](https://vaconi.com/images/support/order1.jpg "[img") [ ![[img](https://vaconi.com/images/support/order2.jpg) ](https://vaconi.com/images/support/order2.jpg "[img") Opening the order via the order number and altering the status via the "Main information" section does not trigger the error. [ ![[img](https://vaconi.com/images/support/order3.jpg) ](https://vaconi.com/images/support/order3.jpg "[img") I figure it has something to do with line 322 of the /administrator/components/com_hikashop/controllers/order.php file Code: $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'); Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 10 years 4 months ago [\#241867](#241867) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#241867 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* Hello, Can you click on the "Check database" button via "Hikashop->System->Configuration" and test it again after the check is complete ? Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")** - [![vaconiit's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35152.jpg)](/forum/user/35152-vaconiit "View vaconiit's Profile") Topic Author - [ Offline](/forum/user/35152-vaconiit) Less More - Posts: 16 - Thank you received: 2 - - 10 years 4 months ago [\#241969](#241969) by [vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile") Replied by *[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#241969 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* Everything seems to be allright at first glance: Code: 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 10 years 4 months ago [\#242011](#242011) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242011 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* Hi, The error doesn't come from > $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'); It's another MySQL query. Please try again after activating the "debug mode" and "error reporting" settings of the Joomla configuration. It will provide more precise information on what's going on, which will help us tell you what to do. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")** - [![vaconiit's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35152.jpg)](/forum/user/35152-vaconiit "View vaconiit's Profile") Topic Author - [ Offline](/forum/user/35152-vaconiit) Less More - Posts: 16 - Thank you received: 2 - - 10 years 4 months ago [\#242162](#242162) by [vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile") Replied by *[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242162 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* 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? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 10 years 4 months ago [\#242165](#242165) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242165 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* Hi, Please use our contact form and provide a link to this thread in your message: [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile")** - [![fafamaster's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar68.png)](/forum/user/68-fafamaster "View fafamaster's Profile") - [ Offline](/forum/user/68-fafamaster) Less More - Posts: 502 - Thank you received: 12 - - 10 years 4 months ago [\#242386](#242386) by [fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile") Replied by *[fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242386 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* Hello, i have the same problem !!! Exactly ! Can you give me a solution ??? Thank you !!! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")** - [![vaconiit's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35152.jpg)](/forum/user/35152-vaconiit "View vaconiit's Profile") Topic Author - [ Offline](/forum/user/35152-vaconiit) Less More - Posts: 16 - Thank you received: 2 - - 10 years 4 months ago [\#242395](#242395) by [vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile") Replied by *[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242395 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* 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)[ vaconi.com/klanten/ondersteuning/ticket/...bevestigen-lukt-niet](https://vaconi.com/klanten/ondersteuning/ticket/trouble-tickets/67-bestelling-bevestigen-lukt-niet) The following user(s) said Thank You: [fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile")** - [![fafamaster's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar68.png)](/forum/user/68-fafamaster "View fafamaster's Profile") - [ Offline](/forum/user/68-fafamaster) Less More - Posts: 502 - Thank you received: 12 - - 10 years 4 months ago [\#242403](#242403) by [fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile") Replied by *[fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242403 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* 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 ! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 10 years 4 months ago [\#242560](#242560) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242560 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* Hi, Thank you for the access, I was able to see the debug data: Code: 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 vit_hikashop_address WHERE address_id = Call stack # Function Location 1 JApplicationCms->execute() /volume1/web/justlovepaint/administrator/index.php:51 2 JApplicationAdministrator->doExecute() /volume1/web/justlovepaint/libraries/cms/application/cms.php:257 3 JApplicationAdministrator->dispatch() /volume1/web/justlovepaint/libraries/cms/application/administrator.php:152 4 JComponentHelper::renderComponent() /volume1/web/justlovepaint/libraries/cms/application/administrator.php:98 5 JComponentHelper::executeComponent() /volume1/web/justlovepaint/libraries/cms/component/helper.php:380 6 require_once() /volume1/web/justlovepaint/libraries/cms/component/helper.php:405 7 hikashopController->execute() /volume1/web/justlovepaint/administrator/components/com_hikashop/hikashop.php:54 8 JControllerLegacy->execute() /volume1/web/justlovepaint/administrator/components/com_hikashop/helpers/helper.php:1630 9 OrderController->savechangestatus() /volume1/web/justlovepaint/libraries/legacy/controller/legacy.php:728 10 OrderController->_save() /volume1/web/justlovepaint/administrator/components/com_hikashop/controllers/order.php:432 11 hikashopOrderClass->save() /volume1/web/justlovepaint/administrator/components/com_hikashop/controllers/order.php:491 12 JEventDispatcher->trigger() /volume1/web/justlovepaint/administrator/components/com_hikashop/classes/order.php:416 13 JEvent->update() /volume1/web/justlovepaint/libraries/joomla/event/dispatcher.php:160 14 call_user_func_array() /volume1/web/justlovepaint/libraries/joomla/event/event.php:69 15 plgHikashopInvoicemanager->onAfterOrderUpdate() 16 plgHikashopInvoicemanager->create_invoice() /volume1/web/justlovepaint/plugins/hikashop/invoicemanager/invoicemanager.php:34 17 JDatabaseDriver->loadObject() /volume1/web/justlovepaint/plugins/hikashop/invoicemanager/invoicemanager.php:78 18 JDatabaseDriverMysqli->execute() /volume1/web/justlovepaint/libraries/joomla/database/driver.php:1653 As you can see, the problem is with a MySQL query in the invoicemanager plugin. That's not a plugin from HikaShop. So you need to contact the developer of that plugin so tha they can tell you what to change in order to avoid the problem. It should be an easy modification to do near the line 78 of the file plugins/hikashop/invoicemanager/invoicemanager.php If you provide the debug data above to the developer, he will be able to tell you what to do. The following user(s) said Thank You: [vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")** - [![vaconiit's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35152.jpg)](/forum/user/35152-vaconiit "View vaconiit's Profile") Topic Author - [ Offline](/forum/user/35152-vaconiit) Less More - Posts: 16 - Thank you received: 2 - - 10 years 4 months ago [\#242633](#242633) by [vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile") Replied by *[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242633 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile")** - [![fafamaster's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar68.png)](/forum/user/68-fafamaster "View fafamaster's Profile") - [ Offline](/forum/user/68-fafamaster) Less More - Posts: 502 - Thank you received: 12 - - 10 years 4 months ago [\#242635](#242635) by [fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile") Replied by *[fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242635 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* Thank you very much to all ! Nicolas thank you for your return ausi always effective, and thank you for vaconiit back! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")** - [![vaconiit's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35152.jpg)](/forum/user/35152-vaconiit "View vaconiit's Profile") Topic Author - [ Offline](/forum/user/35152-vaconiit) Less More - Posts: 16 - Thank you received: 2 - - 10 years 4 months ago [\#242659](#242659) by [vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile") Replied by *[vaconiit](/forum/user/35152-vaconiit "View vaconiit's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242659 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* 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](http://www.joomlathat.com/support/invoice-manager/sql-error-presumably-by-hikashop-plugin) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile")** - [![fafamaster's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar68.png)](/forum/user/68-fafamaster "View fafamaster's Profile") - [ Offline](/forum/user/68-fafamaster) Less More - Posts: 502 - Thank you received: 12 - - 10 years 4 months ago - 10 years 4 months ago [\#242661](#242661) by [fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile") Replied by *[fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile")* on topic *[SQL error](/forum/35-orders-management/884864-sql-error#242661 "-- 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: Any idea what might trigger this? Edit: found the reason... The user table was corrupt. All works as exprected now... Sorry for any inconvenience...")* Thank you for the investigation ![;)](/media/kunena/emoticons/11.png ";)") !!!!! But where is the version 2.0.2 of plugin joomlathat ? Last edit: 10 years 4 months ago by [fafamaster](/forum/user/68-fafamaster "View fafamaster's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4NDg2NC1zcWwtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.488 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)