[Skip to main content](#vessel-content) # Error 1064 when updating Order Statusses ## - **[MadMan](/forum/user/32264-madman "View MadMan's Profile")** - [![MadMan's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32264.jpg)](/forum/user/32264-madman "View MadMan's Profile") Topic Author - [ Offline](/forum/user/32264-madman) Less More - Posts: 33 - Thank you received: 0 - - - [](http://www.MadMan.co.za) - 12 years 1 month ago [\#169603](#169603) by [MadMan](/forum/user/32264-madman "View MadMan's Profile") *[Error 1064 when updating Order Statusses](/forum/35-orders-management/870743-error-1064-when-updating-order-statusses#169603 "-- url of the page with the problem -- : www.madman.co.za -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.0 The error comes up as soon as the "save and close" buttin is pressed, however the status is updated, but the error is a problem. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE syi7r_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Where do I fix it ? Regards Brian")* was created by *[MadMan](/forum/user/32264-madman "View MadMan's Profile")* -- url of the page with the problem -- : [ www.madman.co.za](http://www.madman.co.za) -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.0 The error comes up as soon as the "save and close" buttin is pressed, however the status is updated, but the error is a problem. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE syi7r_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Where do I fix it ? Regards Brian --- Engine Monitoring and Performance Systems Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDc0My1lcnJvci0xMDY0LXdoZW4tdXBkYXRpbmctb3JkZXItc3RhdHVzc2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 1 month ago [\#169614](#169614) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Error 1064 when updating Order Statusses](/forum/35-orders-management/870743-error-1064-when-updating-order-statusses#169614 "-- url of the page with the problem -- : www.madman.co.za -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.0 The error comes up as soon as the "save and close" buttin is pressed, however the status is updated, but the error is a problem. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE syi7r_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Where do I fix it ? Regards Brian")* Hi, You have this error when updating an order status ? Thanks to tell us where exactly you press this button, in the order detail page in backend or in the listing ? Do you have any custom plugin called when saving an order ? It seems to be strange that a request is executed on the category table when updating an order. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDc0My1lcnJvci0xMDY0LXdoZW4tdXBkYXRpbmctb3JkZXItc3RhdHVzc2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MadMan](/forum/user/32264-madman "View MadMan's Profile")** - [![MadMan's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32264.jpg)](/forum/user/32264-madman "View MadMan's Profile") Topic Author - [ Offline](/forum/user/32264-madman) Less More - Posts: 33 - Thank you received: 0 - - - [](http://www.MadMan.co.za) - 12 years 1 month ago [\#169682](#169682) by [MadMan](/forum/user/32264-madman "View MadMan's Profile") Replied by *[MadMan](/forum/user/32264-madman "View MadMan's Profile")* on topic *[Error 1064 when updating Order Statusses](/forum/35-orders-management/870743-error-1064-when-updating-order-statusses#169682 "-- url of the page with the problem -- : www.madman.co.za -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.0 The error comes up as soon as the "save and close" buttin is pressed, however the status is updated, but the error is a problem. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE syi7r_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Where do I fix it ? Regards Brian")* Xavier, In the backend, I click on SYSTEM > ORDER STATUSES, I create an order status such as "Awaiting Payment" then I click on "SAVE and EXIT" and that is when the error comes up. The error displays the text and gives "Return to Control Panel" and throws me completely out of Joomla backend, I must log in again. Only happens on create a new status, If I edit an existing status it saves it ok. I have no custom plugins (that I know of) Regards Brian --- Engine Monitoring and Performance Systems Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDc0My1lcnJvci0xMDY0LXdoZW4tdXBkYXRpbmctb3JkZXItc3RhdHVzc2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 1 month ago [\#169721](#169721) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Error 1064 when updating Order Statusses](/forum/35-orders-management/870743-error-1064-when-updating-order-statusses#169721 "-- url of the page with the problem -- : www.madman.co.za -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.0 The error comes up as soon as the "save and close" buttin is pressed, however the status is updated, but the error is a problem. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE syi7r_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Where do I fix it ? Regards Brian")* Hi, I was not able to reproduce the issue on my end, so I think that an error potentially happened when updating/installing HikaShop. Could you try to download again the latest version from our website and install it over the current one ? Before that, you can maybe try to go in the category listing in HikaShop and click on the "rebuild" button in the toolbar. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDc0My1lcnJvci0xMDY0LXdoZW4tdXBkYXRpbmctb3JkZXItc3RhdHVzc2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MadMan](/forum/user/32264-madman "View MadMan's Profile")** - [![MadMan's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32264.jpg)](/forum/user/32264-madman "View MadMan's Profile") Topic Author - [ Offline](/forum/user/32264-madman) Less More - Posts: 33 - Thank you received: 0 - - - [](http://www.MadMan.co.za) - 12 years 1 month ago [\#169768](#169768) by [MadMan](/forum/user/32264-madman "View MadMan's Profile") Replied by *[MadMan](/forum/user/32264-madman "View MadMan's Profile")* on topic *[Error 1064 when updating Order Statusses](/forum/35-orders-management/870743-error-1064-when-updating-order-statusses#169768 "-- url of the page with the problem -- : www.madman.co.za -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.0 The error comes up as soon as the "save and close" buttin is pressed, however the status is updated, but the error is a problem. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE syi7r_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Where do I fix it ? Regards Brian")* Xavier, I sent you a PM with logins, so you can go in and try the action as I explained - hopefully it will happen when you do it. I will do the re-install soon when I get a chance. I did try the rebuild button to no benefit. Regards Brian --- Engine Monitoring and Performance Systems Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDc0My1lcnJvci0xMDY0LXdoZW4tdXBkYXRpbmctb3JkZXItc3RhdHVzc2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MadMan](/forum/user/32264-madman "View MadMan's Profile")** - [![MadMan's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32264.jpg)](/forum/user/32264-madman "View MadMan's Profile") Topic Author - [ Offline](/forum/user/32264-madman) Less More - Posts: 33 - Thank you received: 0 - - - [](http://www.MadMan.co.za) - 12 years 1 month ago [\#170376](#170376) by [MadMan](/forum/user/32264-madman "View MadMan's Profile") Replied by *[MadMan](/forum/user/32264-madman "View MadMan's Profile")* on topic *[Error 1064 when updating Order Statusses](/forum/35-orders-management/870743-error-1064-when-updating-order-statusses#170376 "-- url of the page with the problem -- : www.madman.co.za -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.0 The error comes up as soon as the "save and close" buttin is pressed, however the status is updated, but the error is a problem. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE syi7r_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Where do I fix it ? Regards Brian")* Xavier, I found a mixup in the order status names - some places it shows one list ((Orders> Orders>drop downlist )and other places (System>config>main>Order ) it shows a different list. I multiple places to put the lists: I then found that one list is nested inside the other list leading from the "none" tag. System>order statusses> I get a list I created with "root" at the top. If I click on "root" I get "categories", "tax categories" , "order status" and "Brand" . Where exactly must I put my order statusses for them to appear in all the dropdowns and selections ? Regards, Brian --- Engine Monitoring and Performance Systems Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDc0My1lcnJvci0xMDY0LXdoZW4tdXBkYXRpbmctb3JkZXItc3RhdHVzc2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 1 month ago [\#170511](#170511) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Error 1064 when updating Order Statusses](/forum/35-orders-management/870743-error-1064-when-updating-order-statusses#170511 "-- url of the page with the problem -- : www.madman.co.za -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.0 The error comes up as soon as the "save and close" buttin is pressed, however the status is updated, but the error is a problem. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE syi7r_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Where do I fix it ? Regards Brian")* Hi, To edit the statuses, you just have to go to System > Order statuses and add them in the current category, so the "order statuses" one. Then check that the statuses are well published. And they should be displayed in all the dropdowns. If it's not the case, thanks to check the entries in the database via phpMyAdmin. The following user(s) said Thank You: [MadMan](/forum/user/32264-madman "View MadMan's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDc0My1lcnJvci0xMDY0LXdoZW4tdXBkYXRpbmctb3JkZXItc3RhdHVzc2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MadMan](/forum/user/32264-madman "View MadMan's Profile")** - [![MadMan's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32264.jpg)](/forum/user/32264-madman "View MadMan's Profile") Topic Author - [ Offline](/forum/user/32264-madman) Less More - Posts: 33 - Thank you received: 0 - - - [](http://www.MadMan.co.za) - 12 years 1 month ago [\#170545](#170545) by [MadMan](/forum/user/32264-madman "View MadMan's Profile") Replied by *[MadMan](/forum/user/32264-madman "View MadMan's Profile")* on topic *[Error 1064 when updating Order Statusses](/forum/35-orders-management/870743-error-1064-when-updating-order-statusses#170545 "-- url of the page with the problem -- : www.madman.co.za -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.0 The error comes up as soon as the "save and close" buttin is pressed, however the status is updated, but the error is a problem. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE syi7r_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Where do I fix it ? Regards Brian")* Xavier, I tried deleting the statuses listed in the same category as Root, but an error came up, I then went in via phpMyadmin and deleted the entries there - it seems ok now. Thank you. --- Engine Monitoring and Performance Systems Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MDc0My1lcnJvci0xMDY0LXdoZW4tdXBkYXRpbmctb3JkZXItc3RhdHVzc2VzP3RtcGw9bWFya2Rvd24=) 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.371 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)