[Skip to main content](#vessel-content)

#  Profile for joostbloom

##

[![joostbloom's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29932-joostbloom "View joostbloom's Profile")

**[ Offline](/forum/user/29932-joostbloom)**

- **User Type:** User

- **Register Date:** 02 Dec 2013
- **Last login:** 2 months 3 days ago
- **Time Zone:**  UTC +0:00
- **Local Time:** 16:45

- **Posts:** 62
- **Profile views:** 241

- **Gender:** Unknown
- **Birthdate:** Unknown
- **Medals:**  Hikashop Business

- Posts

#  joostbloom's recent posts  (62 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

| <a id="forumtop"> </a> [  ](#forumbottom) | Subject | Replies / Views | Last Post | <a id="forumbottom"> </a> [   ](#forumtop) |
|---|---|---|---|---|
| [](/forum/25-install-update/897986-1064-error#309286) | [1064 error](/forum/25-install-update/897986-1064-error#309286 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.10 -- PHP version -- : 7.2.20 -- Error-message(debug-mod must be tuned on) -- : 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 SELECT product&#95;id FROM saqj9&#95;hikashop&#95;product&#95;category WHERE category&#95;id IN ()  Hi,  I have in a specific category of my shop an error when I try to enter the price of a product or when I try to add some variants to it. I got this error message: 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 SELECT product&#95;id FROM saqj9&#95;hikashop&#95;product&#95;category WHERE category&#95;id IN ()  You can see it in live here:   www.mijnkinderkamer.nl/nl/producten/hout...etters-12-cm-meisjes  I have tried a lot and search for same errors but no result till now.  Any idea what can be wrong?  regards, Joost")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 7 years 3 months ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/25-install-update/897986-1064-error#309286 "Hi Nicolas!  Thanks for the quick and great support! Everything is working again! Thanks!") 7 years 3 months ago     by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile") | Replies:4  Views:1098 | [Last Post](/forum/25-install-update/897986-1064-error#309286 "Hi Nicolas!  Thanks for the quick and great support! Everything is working again! Thanks!") by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")      7 years 3 months ago |
| [](/forum/25-install-update/897986-1064-error#309266) | [1064 error](/forum/25-install-update/897986-1064-error#309266 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.10 -- PHP version -- : 7.2.20 -- Error-message(debug-mod must be tuned on) -- : 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 SELECT product&#95;id FROM saqj9&#95;hikashop&#95;product&#95;category WHERE category&#95;id IN ()  Hi,  I have in a specific category of my shop an error when I try to enter the price of a product or when I try to add some variants to it. I got this error message: 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 SELECT product&#95;id FROM saqj9&#95;hikashop&#95;product&#95;category WHERE category&#95;id IN ()  You can see it in live here:   www.mijnkinderkamer.nl/nl/producten/hout...etters-12-cm-meisjes  I have tried a lot and search for same errors but no result till now.  Any idea what can be wrong?  regards, Joost")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 7 years 3 months ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/25-install-update/897986-1064-error#309286 "Hi Nicolas!  Thanks for the quick and great support! Everything is working again! Thanks!") 7 years 3 months ago     by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile") | Replies:4  Views:1098 | [Last Post](/forum/25-install-update/897986-1064-error#309286 "Hi Nicolas!  Thanks for the quick and great support! Everything is working again! Thanks!") by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")      7 years 3 months ago |
| [](/forum/25-install-update/897986-1064-error#309263) | [1064 error](/forum/25-install-update/897986-1064-error#309263 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.10 -- PHP version -- : 7.2.20 -- Error-message(debug-mod must be tuned on) -- : 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 SELECT product&#95;id FROM saqj9&#95;hikashop&#95;product&#95;category WHERE category&#95;id IN ()  Hi,  I have in a specific category of my shop an error when I try to enter the price of a product or when I try to add some variants to it. I got this error message: 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 SELECT product&#95;id FROM saqj9&#95;hikashop&#95;product&#95;category WHERE category&#95;id IN ()  You can see it in live here:   www.mijnkinderkamer.nl/nl/producten/hout...etters-12-cm-meisjes  I have tried a lot and search for same errors but no result till now.  Any idea what can be wrong?  regards, Joost")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 7 years 3 months ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/25-install-update/897986-1064-error#309286 "Hi Nicolas!  Thanks for the quick and great support! Everything is working again! Thanks!") 7 years 3 months ago     by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile") | Replies:4  Views:1098 | [Last Post](/forum/25-install-update/897986-1064-error#309286 "Hi Nicolas!  Thanks for the quick and great support! Everything is working again! Thanks!") by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")      7 years 3 months ago |
| [](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#304724) | [Error - Cannot pass parameter 3 by reference](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#304724 "-- HikaShop version -- : 4.0.2 -- Joomla version -- : 3.9.4 -- PHP version -- : 7.3.2 -- Error-message(debug-mod must be tuned on) -- : 0 - Cannot pass parameter 3 by reference  Hello,  When trying to go to the checkout I got this message: Cannot pass parameter 3 by reference What can I do to fix this?  regards, Joost")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 7 years 8 months ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#314954 "Hi,  No, the legacy settings are supposed to work with PHP 7.3. It's just that they are less tested than the non legacy ones, since the vast majority of people don't use them anymore as they are old stuff. The main reason you could look at disabling them would be to use the new interfaces which work better and have more features. For example, after enable the checkout legacy, if you look at the &quot;checkout&quot; tab of the HikaShop configuration, you'll see the new checkout workflow editor which has much more options than the old one.") 6 years 9 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6  Views:2465 | [Last Post](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#314954 "Hi,  No, the legacy settings are supposed to work with PHP 7.3. It's just that they are less tested than the non legacy ones, since the vast majority of people don't use them anymore as they are old stuff. The main reason you could look at disabling them would be to use the new interfaces which work better and have more features. For example, after enable the checkout legacy, if you look at the &quot;checkout&quot; tab of the HikaShop configuration, you'll see the new checkout workflow editor which has much more options than the old one.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      6 years 9 months ago |
| [](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#304717) | [Error - Cannot pass parameter 3 by reference](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#304717 "-- HikaShop version -- : 4.0.2 -- Joomla version -- : 3.9.4 -- PHP version -- : 7.3.2 -- Error-message(debug-mod must be tuned on) -- : 0 - Cannot pass parameter 3 by reference  Hello,  When trying to go to the checkout I got this message: Cannot pass parameter 3 by reference What can I do to fix this?  regards, Joost")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 7 years 8 months ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#314954 "Hi,  No, the legacy settings are supposed to work with PHP 7.3. It's just that they are less tested than the non legacy ones, since the vast majority of people don't use them anymore as they are old stuff. The main reason you could look at disabling them would be to use the new interfaces which work better and have more features. For example, after enable the checkout legacy, if you look at the &quot;checkout&quot; tab of the HikaShop configuration, you'll see the new checkout workflow editor which has much more options than the old one.") 6 years 9 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6  Views:2465 | [Last Post](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#314954 "Hi,  No, the legacy settings are supposed to work with PHP 7.3. It's just that they are less tested than the non legacy ones, since the vast majority of people don't use them anymore as they are old stuff. The main reason you could look at disabling them would be to use the new interfaces which work better and have more features. For example, after enable the checkout legacy, if you look at the &quot;checkout&quot; tab of the HikaShop configuration, you'll see the new checkout workflow editor which has much more options than the old one.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      6 years 9 months ago |
| [](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#304711) | [Error - Cannot pass parameter 3 by reference](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#304711 "-- HikaShop version -- : 4.0.2 -- Joomla version -- : 3.9.4 -- PHP version -- : 7.3.2 -- Error-message(debug-mod must be tuned on) -- : 0 - Cannot pass parameter 3 by reference  Hello,  When trying to go to the checkout I got this message: Cannot pass parameter 3 by reference What can I do to fix this?  regards, Joost")        Category: [Install &amp; Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.")     Topic started 7 years 8 months ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#314954 "Hi,  No, the legacy settings are supposed to work with PHP 7.3. It's just that they are less tested than the non legacy ones, since the vast majority of people don't use them anymore as they are old stuff. The main reason you could look at disabling them would be to use the new interfaces which work better and have more features. For example, after enable the checkout legacy, if you look at the &quot;checkout&quot; tab of the HikaShop configuration, you'll see the new checkout workflow editor which has much more options than the old one.") 6 years 9 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6  Views:2465 | [Last Post](/forum/25-install-update/897108-error-cannot-pass-parameter-3-by-reference#314954 "Hi,  No, the legacy settings are supposed to work with PHP 7.3. It's just that they are less tested than the non legacy ones, since the vast majority of people don't use them anymore as they are old stuff. The main reason you could look at disabling them would be to use the new interfaces which work better and have more features. For example, after enable the checkout legacy, if you look at the &quot;checkout&quot; tab of the HikaShop configuration, you'll see the new checkout workflow editor which has much more options than the old one.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      6 years 9 months ago |
| [](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#300809) | [Two buttons: Buy now &amp; Add to cart](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#300809 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.22  Hi,  I have a simple question: is it possible to have two buttons on a productpage: - Buy now (this will redirect you directly to the checkout) - Add to cart (this will add the item to the cart but the visitor will stay on the same page)  If it is possible, how can I arrange this? Thanks in advance!  Regards, Joost")        Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop")     Topic started 8 years 1 month ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#300822 "Hello,  Sorry for this return, but I process some test thanks to your Url, and if I understand your needs for me everything seems to work as described previously.  So can you describe your issue, how it work before and now, give us maybe your step by step test procedure, and maybe the navigator you used. Other point, did you process some HikaShop update recently ? Awaiting news from you.  Regards") 7 years 11 months ago     by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:4  Views:826 | [Last Post](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#300822 "Hello,  Sorry for this return, but I process some test thanks to your Url, and if I understand your needs for me everything seems to work as described previously.  So can you describe your issue, how it work before and now, give us maybe your step by step test procedure, and maybe the navigator you used. Other point, did you process some HikaShop update recently ? Awaiting news from you.  Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile")      7 years 11 months ago |
| [](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#298951) | [Two buttons: Buy now &amp; Add to cart](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#298951 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.22  Hi,  I have a simple question: is it possible to have two buttons on a productpage: - Buy now (this will redirect you directly to the checkout) - Add to cart (this will add the item to the cart but the visitor will stay on the same page)  If it is possible, how can I arrange this? Thanks in advance!  Regards, Joost")        Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop")     Topic started 8 years 1 month ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#300822 "Hello,  Sorry for this return, but I process some test thanks to your Url, and if I understand your needs for me everything seems to work as described previously.  So can you describe your issue, how it work before and now, give us maybe your step by step test procedure, and maybe the navigator you used. Other point, did you process some HikaShop update recently ? Awaiting news from you.  Regards") 7 years 11 months ago     by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:4  Views:826 | [Last Post](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#300822 "Hello,  Sorry for this return, but I process some test thanks to your Url, and if I understand your needs for me everything seems to work as described previously.  So can you describe your issue, how it work before and now, give us maybe your step by step test procedure, and maybe the navigator you used. Other point, did you process some HikaShop update recently ? Awaiting news from you.  Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile")      7 years 11 months ago |
| [](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#298860) | [Two buttons: Buy now &amp; Add to cart](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#298860 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.22  Hi,  I have a simple question: is it possible to have two buttons on a productpage: - Buy now (this will redirect you directly to the checkout) - Add to cart (this will add the item to the cart but the visitor will stay on the same page)  If it is possible, how can I arrange this? Thanks in advance!  Regards, Joost")        Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop")     Topic started 8 years 1 month ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#300822 "Hello,  Sorry for this return, but I process some test thanks to your Url, and if I understand your needs for me everything seems to work as described previously.  So can you describe your issue, how it work before and now, give us maybe your step by step test procedure, and maybe the navigator you used. Other point, did you process some HikaShop update recently ? Awaiting news from you.  Regards") 7 years 11 months ago     by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:4  Views:826 | [Last Post](/forum/27-checkout/895908-two-buttons-buy-now-add-to-cart#300822 "Hello,  Sorry for this return, but I process some test thanks to your Url, and if I understand your needs for me everything seems to work as described previously.  So can you describe your issue, how it work before and now, give us maybe your step by step test procedure, and maybe the navigator you used. Other point, did you process some HikaShop update recently ? Awaiting news from you.  Regards") by [Philip](/forum/user/34318-philip "View Philip's Profile")      7 years 11 months ago |
| [](/forum/45-filters-search/895514-filtering-on-custom-fields-is-not-working#296912) | [Filtering on custom fields is not working](/forum/45-filters-search/895514-filtering-on-custom-fields-is-not-working#296912 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.11 -- PHP version -- : 7.1.18 -- Browser(s) name and version -- : Chrome  Hi,  I have a problem with the functionality of filtering of my products. I have setup dynamic filtering on my custom fields. Unfortunately the filter is not working. I onle have the option in the pulldown 'all'. So the content of the custom fields is not showing. I have tried a lot to fix it and search the web and this forum to find a solution, but no.....  Any idea how to get this working?  regrads, Joost")         Category: [Filters &amp; Search](/forum/45-filters-search "Question about filters and search fields")     Topic started 8 years 2 months ago, by [joostbloom](/forum/user/29932-joostbloom "View joostbloom's Profile")       [Last Post](/forum/45-filters-search/895514-filtering-on-custom-fields-is-not-working#298148 "Hi,  No. If it's a text custom field, you can only use a text filter on it. In that case, the users will see a text input for the filter and it will search among the values entered in the custom field in the products. If you want a dropdown/radio/checkbox filter, then you need to use a dropdown/radio/checkbox custom field. The only exception is if in your text custom field, you're entering numbers. In that case, you can enter steps in your dropdown/radio/checkbox filter and the filter will display selectable ranges based on these steps to be able to search among the values in the custom field.  There is no functionality in the works for now to be able to generate the values of a dropdown/radio/checkbox filter from the values entered in a text custom field. We actually want to redo the filters system from the ground up this year or next year, so we're waiting before implementing new features in that old filter system so that we can directly add them once the new system will be available.") 8 years 1 month ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:8  Views:1139 | [Last Post](/forum/45-filters-search/895514-filtering-on-custom-fields-is-not-working#298148 "Hi,  No. If it's a text custom field, you can only use a text filter on it. In that case, the users will see a text input for the filter and it will search among the values entered in the custom field in the products. If you want a dropdown/radio/checkbox filter, then you need to use a dropdown/radio/checkbox custom field. The only exception is if in your text custom field, you're entering numbers. In that case, you can enter steps in your dropdown/radio/checkbox filter and the filter will display selectable ranges based on these steps to be able to search among the values in the custom field.  There is no functionality in the works for now to be able to generate the values of a dropdown/radio/checkbox filter from the values entered in a text custom field. We actually want to redo the filters system from the ground up this year or next year, so we're waiting before implementing new features in that old filter system so that we can directly add them once the new system will be available.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      8 years 1 month ago |

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.059 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
