[Skip to main content](#vessel-content) # Profile for kaimor ## [![kaimor's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33061-kaimor "View kaimor's Profile") **[ Offline](/forum/user/33061-kaimor)** - **User Type:** User - **Register Date:** 14 Jun 2014 - **Last login:** 5 years 6 months ago - **Time Zone:** UTC +1:00 - **Local Time:** 07:29 - **Posts:** 11 - **Profile views:** 107 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # kaimor's recent posts (11 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/881331-1064-you-have-an-error-in-your-sql-syntax#292666) | [1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292666 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.4.3 -- Error-message(debug-mod must be tuned on) -- : I receive the error message when i do mass action on root category: 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 ') OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk_product.* FROM Chau_hikashop_product as hk_product WHERE (product_id IN () OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500 I make the following change and same problem $query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.(int)$this->database->Quote($element).' LIMIT 1'; $this->database->setQuery($query); $element = (int)$this->database->loadResult(); I receive the error message when i do mass action on root category: 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 ') OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk_product.* FROM Chau_hikashop_product as hk_product WHERE (product_id IN () OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500 I make the following change and same problem $query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.(int)$this->database->Quote($element).' LIMIT 1'; $this->database->setQuery($query); $element = (int)$this->database->loadResult();") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 10 years 9 months ago, by [MichelH](/forum/user/32735-michelh "View MichelH's Profile") [Last Post](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292666 "Thank you, It was "Map" report. Now all is all right! :)") 8 years 5 months ago by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") | Replies:6 Views:1318 | [Last Post](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292666 "Thank you, It was "Map" report. Now all is all right! :)") by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") 8 years 5 months ago | | [](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292630) | [1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292630 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.4.3 -- Error-message(debug-mod must be tuned on) -- : I receive the error message when i do mass action on root category: 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 ') OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk_product.* FROM Chau_hikashop_product as hk_product WHERE (product_id IN () OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500 I make the following change and same problem $query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.(int)$this->database->Quote($element).' LIMIT 1'; $this->database->setQuery($query); $element = (int)$this->database->loadResult(); I receive the error message when i do mass action on root category: 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 ') OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk_product.* FROM Chau_hikashop_product as hk_product WHERE (product_id IN () OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500 I make the following change and same problem $query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.(int)$this->database->Quote($element).' LIMIT 1'; $this->database->setQuery($query); $element = (int)$this->database->loadResult();") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 10 years 9 months ago, by [MichelH](/forum/user/32735-michelh "View MichelH's Profile") [Last Post](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292666 "Thank you, It was "Map" report. Now all is all right! :)") 8 years 5 months ago by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") | Replies:6 Views:1318 | [Last Post](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292666 "Thank you, It was "Map" report. Now all is all right! :)") by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") 8 years 5 months ago | | [](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292611) | [1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292611 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.4.3 -- Error-message(debug-mod must be tuned on) -- : I receive the error message when i do mass action on root category: 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 ') OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk_product.* FROM Chau_hikashop_product as hk_product WHERE (product_id IN () OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500 I make the following change and same problem $query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.(int)$this->database->Quote($element).' LIMIT 1'; $this->database->setQuery($query); $element = (int)$this->database->loadResult(); I receive the error message when i do mass action on root category: 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 ') OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk_product.* FROM Chau_hikashop_product as hk_product WHERE (product_id IN () OR product_parent_id IN ()) ORDER BY product_code DESC LIMIT 0, 500 I make the following change and same problem $query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.(int)$this->database->Quote($element).' LIMIT 1'; $this->database->setQuery($query); $element = (int)$this->database->loadResult();") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 10 years 9 months ago, by [MichelH](/forum/user/32735-michelh "View MichelH's Profile") [Last Post](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292666 "Thank you, It was "Map" report. Now all is all right! :)") 8 years 5 months ago by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") | Replies:6 Views:1318 | [Last Post](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292666 "Thank you, It was "Map" report. Now all is all right! :)") by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") 8 years 5 months ago | | [](/forum/26-product-category-display/880556-wrong-and-double-category-tree-view-in-backend#234933) | [Wrong and double category tree view in backend](/forum/26-product-category-display/880556-wrong-and-double-category-tree-view-in-backend#234933 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.29 -- Browser(s) name and version -- : Microsoft Edge 25.10586 -- Error-message(debug-mod must be tuned on) -- : none In Backend the category view shows a wrong tree in left column. A product category is showed as ROOT, and all categories are showed as double structure.") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 10 years 11 months ago, by [tvoeten](/forum/user/37369-tvoeten "View tvoeten's Profile") [Last Post](/forum/26-product-category-display/880556-wrong-and-double-category-tree-view-in-backend#234992 "Hi, If the rebuild itself doesn't work, go in PHPMyAdmin and open your hikashop_category table. There check the category_parent_id of the categories involved in the problem (the root, the top ones) and make sure that it correspond to the category_id of the parent you want for each (0 for the root). Once you made the changes, click on the "rebuild" button again and it will correct the tree structure accordingly.") 10 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:4 Views:832 | [Last Post](/forum/26-product-category-display/880556-wrong-and-double-category-tree-view-in-backend#234992 "Hi, If the rebuild itself doesn't work, go in PHPMyAdmin and open your hikashop_category table. There check the category_parent_id of the categories involved in the problem (the root, the top ones) and make sure that it correspond to the category_id of the parent you want for each (0 for the root). Once you made the changes, click on the "rebuild" button again and it will correct the tree structure accordingly.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 6 months ago | | [](/forum/26-product-category-display/880556-wrong-and-double-category-tree-view-in-backend#234932) | [Wrong and double category tree view in backend](/forum/26-product-category-display/880556-wrong-and-double-category-tree-view-in-backend#234932 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.29 -- Browser(s) name and version -- : Microsoft Edge 25.10586 -- Error-message(debug-mod must be tuned on) -- : none In Backend the category view shows a wrong tree in left column. A product category is showed as ROOT, and all categories are showed as double structure.") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 10 years 11 months ago, by [tvoeten](/forum/user/37369-tvoeten "View tvoeten's Profile") [Last Post](/forum/26-product-category-display/880556-wrong-and-double-category-tree-view-in-backend#234992 "Hi, If the rebuild itself doesn't work, go in PHPMyAdmin and open your hikashop_category table. There check the category_parent_id of the categories involved in the problem (the root, the top ones) and make sure that it correspond to the category_id of the parent you want for each (0 for the root). Once you made the changes, click on the "rebuild" button again and it will correct the tree structure accordingly.") 10 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:4 Views:832 | [Last Post](/forum/26-product-category-display/880556-wrong-and-double-category-tree-view-in-backend#234992 "Hi, If the rebuild itself doesn't work, go in PHPMyAdmin and open your hikashop_category table. There check the category_parent_id of the categories involved in the problem (the root, the top ones) and make sure that it correspond to the category_id of the parent you want for each (0 for the root). Once you made the changes, click on the "rebuild" button again and it will correct the tree structure accordingly.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 6 months ago | | [](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859) | [Problem with plugin: Group filter consumer](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859 "-- HikaShop version -- : 2.3.5 -- HikaSerial version -- : 1.9.0 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : Chrome Hi! The choices under GROUPS are grey, and cannot be selected. I have selected "Pack", named the new plugin and saved the new plugin. What am I doing wrong?") Category: [General talk about HikaSerial](/forum/15-general-talk-about-hikaserial "Suggest your feature requests and ideas for HikaSerial") Topic started 11 years 9 months ago, by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") [Last Post](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859 ":-)") 11 years 9 months ago by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") | Replies:5 Views:1696 | [Last Post](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859 ":-)") by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") 11 years 9 months ago | | [](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187847) | [Problem with plugin: Group filter consumer](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187847 "-- HikaShop version -- : 2.3.5 -- HikaSerial version -- : 1.9.0 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : Chrome Hi! The choices under GROUPS are grey, and cannot be selected. I have selected "Pack", named the new plugin and saved the new plugin. What am I doing wrong?") Category: [General talk about HikaSerial](/forum/15-general-talk-about-hikaserial "Suggest your feature requests and ideas for HikaSerial") Topic started 11 years 9 months ago, by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") [Last Post](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859 ":-)") 11 years 9 months ago by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") | Replies:5 Views:1696 | [Last Post](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859 ":-)") by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") 11 years 9 months ago | | [](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187846) | [Problem with plugin: Group filter consumer](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187846 "-- HikaShop version -- : 2.3.5 -- HikaSerial version -- : 1.9.0 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : Chrome Hi! The choices under GROUPS are grey, and cannot be selected. I have selected "Pack", named the new plugin and saved the new plugin. What am I doing wrong?") Category: [General talk about HikaSerial](/forum/15-general-talk-about-hikaserial "Suggest your feature requests and ideas for HikaSerial") Topic started 11 years 9 months ago, by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") [Last Post](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859 ":-)") 11 years 9 months ago by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") | Replies:5 Views:1696 | [Last Post](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859 ":-)") by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") 11 years 9 months ago | | [](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187825) | [Problem with plugin: Group filter consumer](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187825 "-- HikaShop version -- : 2.3.5 -- HikaSerial version -- : 1.9.0 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : Chrome Hi! The choices under GROUPS are grey, and cannot be selected. I have selected "Pack", named the new plugin and saved the new plugin. What am I doing wrong?") Category: [General talk about HikaSerial](/forum/15-general-talk-about-hikaserial "Suggest your feature requests and ideas for HikaSerial") Topic started 11 years 9 months ago, by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") [Last Post](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859 ":-)") 11 years 9 months ago by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") | Replies:5 Views:1696 | [Last Post](/forum/15-general-talk-about-hikaserial/874451-problem-with-plugin-group-filter-consumer#187859 ":-)") by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") 11 years 9 months ago | | [](/forum/32-content-creation/869896-download-with-unique-codes#165113) | [Download with unique codes?](/forum/32-content-creation/869896-download-with-unique-codes#165113 "Is it possible to create documents for download with unique codes? As a ticket. In that case I can make one basic document, which gets unique codes for each download. Or are there other ways to solve this?") Category: [Content Creation](/forum/32-content-creation "If you want to know more about the different options of the product and category creation.") Topic started 12 years 3 months ago, by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile") [Last Post](/forum/32-content-creation/869896-download-with-unique-codes#165121 "Hello, The solution will probably be to use HikaSerial : www.hikashop.com/extensions/hikaserial/product.html") 12 years 3 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:1 Views:699 | [Last Post](/forum/32-content-creation/869896-download-with-unique-codes#165121 "Hello, The solution will probably be to use HikaSerial : www.hikashop.com/extensions/hikaserial/product.html") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 12 years 3 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.155 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)