[Skip to main content](#vessel-content) # Profile for s21rc ## [![s21rc's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4438-s21rc "View s21rc's Profile") **[ Offline](/forum/user/4438-s21rc)** - **User Type:** User - **Register Date:** 05 Nov 2011 - **Last login:** 10 years 10 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 12:18 - **Posts:** 22 - **Profile views:** 344 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # s21rc's recent posts (22 messages ) All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/25-install-update/871944-order-status-creation-error#174003) | [Order Status creation error](/forum/25-install-update/871944-order-status-creation-error#174003 "-- url of the page with the problem -- : peak69.com -- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.4 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 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 aosa8_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Hi Nicolas, Last week I have reported that the brand name has disapeared from the list but can be found using explore in product option. Now I have just noticed I can not find the Order status such as created, confirmed, shipped etc under SYSTEM>ORDER STATUS. Only root is showing. WHile trying to create an entry, it gived error: 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 aosa8_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Later found the entry been created though. But, the statuses are all there when I try to change the status of any existing order from Orders>Orders page. Both screenshot attached. I have re-installed the Hikashop business version again, no change. I really am thinking there is something wrong, please have a look thoroughly, access credential has been sent before. All this trouble started after I installed the business version (fresh installation), and imported joomla user (using extra tools), imported products using hikashop tools, imported user address using PHP Myadmin. At first everything was ok, later it started behaving like this. Also updated Joomla to 3.3.4. PLease please have a good look. Thanks.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/25-install-update/871944-order-status-creation-error#174003 "Thanks a lot Jerome, now it not only solve current problem but also the previous brand problem as well. Again will poke you until the site is fully configured like before :D Thanks again.") 12 years 1 month ago by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") | Replies:6 Views:791 | [Last Post](/forum/25-install-update/871944-order-status-creation-error#174003 "Thanks a lot Jerome, now it not only solve current problem but also the previous brand problem as well. Again will poke you until the site is fully configured like before :D Thanks again.") by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") 12 years 1 month ago | | [](/forum/25-install-update/871944-order-status-creation-error#173824) | [Order Status creation error](/forum/25-install-update/871944-order-status-creation-error#173824 "-- url of the page with the problem -- : peak69.com -- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.4 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 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 aosa8_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Hi Nicolas, Last week I have reported that the brand name has disapeared from the list but can be found using explore in product option. Now I have just noticed I can not find the Order status such as created, confirmed, shipped etc under SYSTEM>ORDER STATUS. Only root is showing. WHile trying to create an entry, it gived error: 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 aosa8_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Later found the entry been created though. But, the statuses are all there when I try to change the status of any existing order from Orders>Orders page. Both screenshot attached. I have re-installed the Hikashop business version again, no change. I really am thinking there is something wrong, please have a look thoroughly, access credential has been sent before. All this trouble started after I installed the business version (fresh installation), and imported joomla user (using extra tools), imported products using hikashop tools, imported user address using PHP Myadmin. At first everything was ok, later it started behaving like this. Also updated Joomla to 3.3.4. PLease please have a good look. Thanks.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/25-install-update/871944-order-status-creation-error#174003 "Thanks a lot Jerome, now it not only solve current problem but also the previous brand problem as well. Again will poke you until the site is fully configured like before :D Thanks again.") 12 years 1 month ago by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") | Replies:6 Views:791 | [Last Post](/forum/25-install-update/871944-order-status-creation-error#174003 "Thanks a lot Jerome, now it not only solve current problem but also the previous brand problem as well. Again will poke you until the site is fully configured like before :D Thanks again.") by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") 12 years 1 month ago | | [](/forum/25-install-update/871944-order-status-creation-error#173672) | [Order Status creation error](/forum/25-install-update/871944-order-status-creation-error#173672 "-- url of the page with the problem -- : peak69.com -- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.4 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 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 aosa8_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Hi Nicolas, Last week I have reported that the brand name has disapeared from the list but can be found using explore in product option. Now I have just noticed I can not find the Order status such as created, confirmed, shipped etc under SYSTEM>ORDER STATUS. Only root is showing. WHile trying to create an entry, it gived error: 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 aosa8_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Later found the entry been created though. But, the statuses are all there when I try to change the status of any existing order from Orders>Orders page. Both screenshot attached. I have re-installed the Hikashop business version again, no change. I really am thinking there is something wrong, please have a look thoroughly, access credential has been sent before. All this trouble started after I installed the business version (fresh installation), and imported joomla user (using extra tools), imported products using hikashop tools, imported user address using PHP Myadmin. At first everything was ok, later it started behaving like this. Also updated Joomla to 3.3.4. PLease please have a good look. Thanks.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/25-install-update/871944-order-status-creation-error#174003 "Thanks a lot Jerome, now it not only solve current problem but also the previous brand problem as well. Again will poke you until the site is fully configured like before :D Thanks again.") 12 years 1 month ago by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") | Replies:6 Views:791 | [Last Post](/forum/25-install-update/871944-order-status-creation-error#174003 "Thanks a lot Jerome, now it not only solve current problem but also the previous brand problem as well. Again will poke you until the site is fully configured like before :D Thanks again.") by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") 12 years 1 month ago | | [](/forum/25-install-update/871944-order-status-creation-error#173574) | [Order Status creation error](/forum/25-install-update/871944-order-status-creation-error#173574 "-- url of the page with the problem -- : peak69.com -- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.4 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 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 aosa8_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Hi Nicolas, Last week I have reported that the brand name has disapeared from the list but can be found using explore in product option. Now I have just noticed I can not find the Order status such as created, confirmed, shipped etc under SYSTEM>ORDER STATUS. Only root is showing. WHile trying to create an entry, it gived error: 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 aosa8_hikashop_category SET category_right = category_right + 2 WHERE category_right >= Later found the entry been created though. But, the statuses are all there when I try to change the status of any existing order from Orders>Orders page. Both screenshot attached. I have re-installed the Hikashop business version again, no change. I really am thinking there is something wrong, please have a look thoroughly, access credential has been sent before. All this trouble started after I installed the business version (fresh installation), and imported joomla user (using extra tools), imported products using hikashop tools, imported user address using PHP Myadmin. At first everything was ok, later it started behaving like this. Also updated Joomla to 3.3.4. PLease please have a good look. Thanks.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/25-install-update/871944-order-status-creation-error#174003 "Thanks a lot Jerome, now it not only solve current problem but also the previous brand problem as well. Again will poke you until the site is fully configured like before :D Thanks again.") 12 years 1 month ago by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") | Replies:6 Views:791 | [Last Post](/forum/25-install-update/871944-order-status-creation-error#174003 "Thanks a lot Jerome, now it not only solve current problem but also the previous brand problem as well. Again will poke you until the site is fully configured like before :D Thanks again.") by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") 12 years 1 month ago | | [](/forum/44-mass-actions/871671-importing-user-address#172869) | [Importing user address](/forum/44-mass-actions/871671-importing-user-address#172869 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 I am migrating from starter to business edition. I am doing a fresh installation. Already imported joomla users from old installation. Is there any way I can export the users addresses from the old Hikashop to new one? Both version are on 2.3.2") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/44-mass-actions/871671-importing-user-address#181217 "Hi, hikashop uses the hikashop_address table to store the addresses of the users. Joomla doesn't have a table to stores addresses of users. They have the equivalent of custom user fields which some people will use to get one address of the users but it cannot be used for a serious ecommerce solution handling multiple addresses per user which is why we have our own table to store the user addresses. Usually what you do is that you just disable the joomla fields and only use HikaShop's.") 11 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:1784 | [Last Post](/forum/44-mass-actions/871671-importing-user-address#181217 "Hi, hikashop uses the hikashop_address table to store the addresses of the users. Joomla doesn't have a table to stores addresses of users. They have the equivalent of custom user fields which some people will use to get one address of the users but it cannot be used for a serious ecommerce solution handling multiple addresses per user which is why we have our own table to store the user addresses. Usually what you do is that you just disable the joomla fields and only use HikaShop's.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 11 months ago | | [](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172868) | [Vote star is not visible, number is showing](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172868 "-- url of the page with the problem -- : peak69.com/ -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- Error-message(debug-mod must be tuned on) -- : Console: Uncaught ReferenceError: Class is not defined vote.js:8 Uncaught ReferenceError: Class is not defined vote.js:8 Vote star is not visible, instead number is showing. Installed jQuery Easy as per other post in forum, still not working. Other plugin used are: XMAP, disabled it but no luck.") Category: [Vote](/forum/42-vote "Question about the awesome Hikashop voting system can be posted here!") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172868 "Thanks Jerome. After installing Bootstrap 2 based template all problem solved. Vote and star came back, pop up also working for add to cart. Thanks. SOLVED") 12 years 1 month ago by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") | Replies:4 Views:2696 | [Last Post](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172868 "Thanks Jerome. After installing Bootstrap 2 based template all problem solved. Vote and star came back, pop up also working for add to cart. Thanks. SOLVED") by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") 12 years 1 month ago | | [](/forum/25-install-update/871829-brand-disappeared-only-root-shows#172867) | [Brand disappeared, only root shows](/forum/25-install-update/871829-brand-disappeared-only-root-shows#172867 "-- url of the page with the problem -- : peak69.com/ -- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.4 Hi, I have recently fresh installed Hikashop over a new installed Joomla 3. I have imported DB table to get the address and import/export to get the products from existing setup. First few days everything was ok, but suddenly item under brands (manufactures name) disappeared. In backend If I go Product>Brands it only shows ROOT. But if I go product and use explorer to explore, then the brands items shows under brands tree. Front end also is not showing any brands. I have sent you site access credentials (joomla, ftp) using contact us form of your site. www.peak69.com Please have a look and suggest. Thanks in advance. Fazlay") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/25-install-update/871829-brand-disappeared-only-root-shows#172956 "Hi, As far as I can see, there is a problem in the data of the main "brand" category and/or it's children and some of them are not of the type brand anymore in the database but of the type product category and thus the brands listing doesn't find them. I've edited your menu item options via the menu Display>Content menus and change the type of the content option to "category" and selected the brand category as associated category and the "brand" categories are now displaying on your website.") 12 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:616 | [Last Post](/forum/25-install-update/871829-brand-disappeared-only-root-shows#172956 "Hi, As far as I can see, there is a problem in the data of the main "brand" category and/or it's children and some of them are not of the type brand anymore in the database but of the type product category and thus the brands listing doesn't find them. I've edited your menu item options via the menu Display>Content menus and change the type of the content option to "category" and selected the brand category as associated category and the "brand" categories are now displaying on your website.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 1 month ago | | [](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172408) | [Vote star is not visible, number is showing](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172408 "-- url of the page with the problem -- : peak69.com/ -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- Error-message(debug-mod must be tuned on) -- : Console: Uncaught ReferenceError: Class is not defined vote.js:8 Uncaught ReferenceError: Class is not defined vote.js:8 Vote star is not visible, instead number is showing. Installed jQuery Easy as per other post in forum, still not working. Other plugin used are: XMAP, disabled it but no luck.") Category: [Vote](/forum/42-vote "Question about the awesome Hikashop voting system can be posted here!") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172868 "Thanks Jerome. After installing Bootstrap 2 based template all problem solved. Vote and star came back, pop up also working for add to cart. Thanks. SOLVED") 12 years 1 month ago by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") | Replies:4 Views:2696 | [Last Post](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172868 "Thanks Jerome. After installing Bootstrap 2 based template all problem solved. Vote and star came back, pop up also working for add to cart. Thanks. SOLVED") by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") 12 years 1 month ago | | [](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172383) | [Vote star is not visible, number is showing](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172383 "-- url of the page with the problem -- : peak69.com/ -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- Error-message(debug-mod must be tuned on) -- : Console: Uncaught ReferenceError: Class is not defined vote.js:8 Uncaught ReferenceError: Class is not defined vote.js:8 Vote star is not visible, instead number is showing. Installed jQuery Easy as per other post in forum, still not working. Other plugin used are: XMAP, disabled it but no luck.") Category: [Vote](/forum/42-vote "Question about the awesome Hikashop voting system can be posted here!") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172868 "Thanks Jerome. After installing Bootstrap 2 based template all problem solved. Vote and star came back, pop up also working for add to cart. Thanks. SOLVED") 12 years 1 month ago by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") | Replies:4 Views:2696 | [Last Post](/forum/42-vote/871740-vote-star-is-not-visible-number-is-showing#172868 "Thanks Jerome. After installing Bootstrap 2 based template all problem solved. Vote and star came back, pop up also working for add to cart. Thanks. SOLVED") by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") 12 years 1 month ago | | [](/forum/44-mass-actions/871671-importing-user-address#172370) | [Importing user address](/forum/44-mass-actions/871671-importing-user-address#172370 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 I am migrating from starter to business edition. I am doing a fresh installation. Already imported joomla users from old installation. Is there any way I can export the users addresses from the old Hikashop to new one? Both version are on 2.3.2") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 12 years 1 month ago, by [s21rc](/forum/user/4438-s21rc "View s21rc's Profile") [Last Post](/forum/44-mass-actions/871671-importing-user-address#181217 "Hi, hikashop uses the hikashop_address table to store the addresses of the users. Joomla doesn't have a table to stores addresses of users. They have the equivalent of custom user fields which some people will use to get one address of the users but it cannot be used for a serious ecommerce solution handling multiple addresses per user which is why we have our own table to store the user addresses. Usually what you do is that you just disable the joomla fields and only use HikaShop's.") 11 years 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:1784 | [Last Post](/forum/44-mass-actions/871671-importing-user-address#181217 "Hi, hikashop uses the hikashop_address table to store the addresses of the users. Joomla doesn't have a table to stores addresses of users. They have the equivalent of custom user fields which some people will use to get one address of the users but it cannot be used for a serious ecommerce solution handling multiple addresses per user which is why we have our own table to store the user addresses. Usually what you do is that you just disable the joomla fields and only use HikaShop's.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 11 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.082 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)