[Skip to main content](#vessel-content) # Profile for MichelH ## [![MichelH's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32735-michelh "View MichelH's Profile") **[ Offline](/forum/user/32735-michelh)** - **User Type:** User - **Register Date:** 22 May 2014 - **Last login:** 9 years 3 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 07:28 - **Posts:** 7 - **Profile views:** 66 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # MichelH's recent posts (7 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#225375) | [1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#225375 "-- 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:1317 | [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/44-mass-actions/875924-product-variants-arent-assigned-a-category#225299) | [Product Variants aren't assigned a Category](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225299 "-- url of the page with the problem -- : www.claycellar.co.uk -- HikaShop version -- : 2.3.0 -- Joomla version -- : 2.5.14 Hi there, My client wants to apply a mass action to update the price of all the products in a given category. To do this we add a filter by category column and an "update the values" action using "operation" to increase the price by 10%. A screen shot of this is attached. We then discover that this doesn't update the price of the variants, because the variants haven't been assigned a category. Indeed there appears to be no place to assign a category to a variant. Presumably variants are assigned to a product which is in turn assigned to a category. But this makes filtering all products and variant under a single category hard right? Though you can do it in the back end table of products, so presumably it's possible? Can you explain how? Best wishes, Jonathan") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 11 years 7 months ago, by [jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile") [Last Post](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225302 "Hi, There is indeed an issue, we just corrected it on our end and the fix will be in the next release. For now you can edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "_displayResults()" replace the code: By:") 10 years 9 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:8 Views:1733 | [Last Post](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225302 "Hi, There is indeed an issue, we just corrected it on our end and the fix will be in the next release. For now you can edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "_displayResults()" replace the code: By:") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 10 years 9 months ago | | [](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225260) | [Product Variants aren't assigned a Category](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225260 "-- url of the page with the problem -- : www.claycellar.co.uk -- HikaShop version -- : 2.3.0 -- Joomla version -- : 2.5.14 Hi there, My client wants to apply a mass action to update the price of all the products in a given category. To do this we add a filter by category column and an "update the values" action using "operation" to increase the price by 10%. A screen shot of this is attached. We then discover that this doesn't update the price of the variants, because the variants haven't been assigned a category. Indeed there appears to be no place to assign a category to a variant. Presumably variants are assigned to a product which is in turn assigned to a category. But this makes filtering all products and variant under a single category hard right? Though you can do it in the back end table of products, so presumably it's possible? Can you explain how? Best wishes, Jonathan") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 11 years 7 months ago, by [jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile") [Last Post](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225302 "Hi, There is indeed an issue, we just corrected it on our end and the fix will be in the next release. For now you can edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "_displayResults()" replace the code: By:") 10 years 9 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:8 Views:1733 | [Last Post](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225302 "Hi, There is indeed an issue, we just corrected it on our end and the fix will be in the next release. For now you can edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "_displayResults()" replace the code: By:") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 10 years 9 months ago | | [](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225237) | [Product Variants aren't assigned a Category](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225237 "-- url of the page with the problem -- : www.claycellar.co.uk -- HikaShop version -- : 2.3.0 -- Joomla version -- : 2.5.14 Hi there, My client wants to apply a mass action to update the price of all the products in a given category. To do this we add a filter by category column and an "update the values" action using "operation" to increase the price by 10%. A screen shot of this is attached. We then discover that this doesn't update the price of the variants, because the variants haven't been assigned a category. Indeed there appears to be no place to assign a category to a variant. Presumably variants are assigned to a product which is in turn assigned to a category. But this makes filtering all products and variant under a single category hard right? Though you can do it in the back end table of products, so presumably it's possible? Can you explain how? Best wishes, Jonathan") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 11 years 7 months ago, by [jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile") [Last Post](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225302 "Hi, There is indeed an issue, we just corrected it on our end and the fix will be in the next release. For now you can edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "_displayResults()" replace the code: By:") 10 years 9 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:8 Views:1733 | [Last Post](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225302 "Hi, There is indeed an issue, we just corrected it on our end and the fix will be in the next release. For now you can edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "_displayResults()" replace the code: By:") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 10 years 9 months ago | | [](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#203958) | [Product Variants aren't assigned a Category](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#203958 "-- url of the page with the problem -- : www.claycellar.co.uk -- HikaShop version -- : 2.3.0 -- Joomla version -- : 2.5.14 Hi there, My client wants to apply a mass action to update the price of all the products in a given category. To do this we add a filter by category column and an "update the values" action using "operation" to increase the price by 10%. A screen shot of this is attached. We then discover that this doesn't update the price of the variants, because the variants haven't been assigned a category. Indeed there appears to be no place to assign a category to a variant. Presumably variants are assigned to a product which is in turn assigned to a category. But this makes filtering all products and variant under a single category hard right? Though you can do it in the back end table of products, so presumably it's possible? Can you explain how? Best wishes, Jonathan") Category: [Mass Actions](/forum/44-mass-actions "Everything about the powerful Hikashop mass action tool") Topic started 11 years 7 months ago, by [jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile") [Last Post](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225302 "Hi, There is indeed an issue, we just corrected it on our end and the fix will be in the next release. For now you can edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "_displayResults()" replace the code: By:") 10 years 9 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:8 Views:1733 | [Last Post](/forum/44-mass-actions/875924-product-variants-arent-assigned-a-category#225302 "Hi, There is indeed an issue, we just corrected it on our end and the fix will be in the next release. For now you can edit the file "administrator/components/com_hikashop/classes/massaction.php" and in the function "_displayResults()" replace the code: By:") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 10 years 9 months ago | | [](/forum/37-import-export-csv-xls/870982-comment-exporter-en-csv-certains-champs#171007) | [Comment exporter en csv certains champs](/forum/37-import-export-csv-xls/870982-comment-exporter-en-csv-certains-champs#171007 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- Browser(s) name and version -- : Chrome Version 37.0.2062.120 m Comment exporter en csv certains champs des produits Par exemple code description prix Merci") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 1 month ago, by [MichelH](/forum/user/32735-michelh "View MichelH's Profile") [Last Post](/forum/37-import-export-csv-xls/870982-comment-exporter-en-csv-certains-champs#171033 "Bonjour, Le champs "Chemin d'export" vous permet de spécifier un chemin pour le fichier (et non pour le dossier où le fichier serait sauvegardé)pour qu'HikaShop le sauvegarde à cet endroit sur le serveur web (et non sur votre ordinateur car bien sûr HikaShop n'à pas accès aux dossiers de votre ordinateur). Le plus simple, c'est de laisser ce champs vide, comme c'est le cas par défaut. Alors, lorsque vous cliquerez sur le bouton "process" de votre action de masse, votre navigateur vous téléchargera le fichier soit automatiquement dans votre dossier de téléchargements, soit vous demandera où vous voulez le sauvegarder.") 12 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1193 | [Last Post](/forum/37-import-export-csv-xls/870982-comment-exporter-en-csv-certains-champs#171033 "Bonjour, Le champs "Chemin d'export" vous permet de spécifier un chemin pour le fichier (et non pour le dossier où le fichier serait sauvegardé)pour qu'HikaShop le sauvegarde à cet endroit sur le serveur web (et non sur votre ordinateur car bien sûr HikaShop n'à pas accès aux dossiers de votre ordinateur). Le plus simple, c'est de laisser ce champs vide, comme c'est le cas par défaut. Alors, lorsque vous cliquerez sur le bouton "process" de votre action de masse, votre navigateur vous téléchargera le fichier soit automatiquement dans votre dossier de téléchargements, soit vous demandera où vous voulez le sauvegarder.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 1 month ago | | [](/forum/37-import-export-csv-xls/870982-comment-exporter-en-csv-certains-champs#170826) | [Comment exporter en csv certains champs](/forum/37-import-export-csv-xls/870982-comment-exporter-en-csv-certains-champs#170826 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- Browser(s) name and version -- : Chrome Version 37.0.2062.120 m Comment exporter en csv certains champs des produits Par exemple code description prix Merci") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 1 month ago, by [MichelH](/forum/user/32735-michelh "View MichelH's Profile") [Last Post](/forum/37-import-export-csv-xls/870982-comment-exporter-en-csv-certains-champs#171033 "Bonjour, Le champs "Chemin d'export" vous permet de spécifier un chemin pour le fichier (et non pour le dossier où le fichier serait sauvegardé)pour qu'HikaShop le sauvegarde à cet endroit sur le serveur web (et non sur votre ordinateur car bien sûr HikaShop n'à pas accès aux dossiers de votre ordinateur). Le plus simple, c'est de laisser ce champs vide, comme c'est le cas par défaut. Alors, lorsque vous cliquerez sur le bouton "process" de votre action de masse, votre navigateur vous téléchargera le fichier soit automatiquement dans votre dossier de téléchargements, soit vous demandera où vous voulez le sauvegarder.") 12 years 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1193 | [Last Post](/forum/37-import-export-csv-xls/870982-comment-exporter-en-csv-certains-champs#171033 "Bonjour, Le champs "Chemin d'export" vous permet de spécifier un chemin pour le fichier (et non pour le dossier où le fichier serait sauvegardé)pour qu'HikaShop le sauvegarde à cet endroit sur le serveur web (et non sur votre ordinateur car bien sûr HikaShop n'à pas accès aux dossiers de votre ordinateur). Le plus simple, c'est de laisser ce champs vide, comme c'est le cas par défaut. Alors, lorsque vous cliquerez sur le bouton "process" de votre action de masse, votre navigateur vous téléchargera le fichier soit automatiquement dans votre dossier de téléchargements, soit vous demandera où vous voulez le sauvegarder.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 1 month ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.145 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)