[Skip to main content](#vessel-content) # Profile for comyoo ## [![comyoo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1145.png)](/forum/user/1145-comyoo "View comyoo's Profile") **[ Offline](/forum/user/1145-comyoo)** - **User Type:** User - **Register Date:** 16 Feb 2011 - **Last login:** 2 months 6 days ago - **Time Zone:** UTC +1:00 - **Local Time:** 20:47 - **Posts:** 97 - **Profile views:** 452 - **Gender:** Unknown - **Birthdate:** Unknown - **Medals:** Hikashop Business - Posts # comyoo's recent posts (97 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/906643-error-in-checkout-after-update-to-4-7-4#353042) | [error in checkout after update to 4.7.4](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353042 "-- url of the page with the problem -- : www.geertswarenhui -- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.1.18 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Unknown column 'total_number_of_products' in 'field list' Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli_query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2515 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:208 5 hikashopOrderClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:913 6 hikashopOrderClass->createFromCart() JROOT/components/com_hikashop/controllers/checkout.php:678 7 checkoutController->confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2441 9 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:88 10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 Hi, Very serious problem: my customers can't order right now: Unknown column 'total_number_of_products' in 'field list' Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli_query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2515 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:208 5 hikashopOrderClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:913 6 hikashopOrderClass->createFromCart() JROOT/components/com_hikashop/controllers/checkout.php:678 7 checkoutController->confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2441 9 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:88 10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 What to do?") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 3 months ago, by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile") [Last Post](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353047 "Hi, Indeed. The message from Jerome actually missled me to a wrong conclusion. There is no such column and it's normal. You can always create it and it will solve the problem. But it should not be necessary. I suppose you must be using some 3rd party plugin implementing the onBeforeOrderCreate event and messing with the order object before it is saved. I've made some modifications in the way HikaShop deals with that total_number_of_products value so that it can't create an error in such cases. Download the HikaShop install package on our website and install it on yours to get the patch and you should not get the error anymore, even without the column in the database.") 3 years 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:753 | [Last Post](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353047 "Hi, Indeed. The message from Jerome actually missled me to a wrong conclusion. There is no such column and it's normal. You can always create it and it will solve the problem. But it should not be necessary. I suppose you must be using some 3rd party plugin implementing the onBeforeOrderCreate event and messing with the order object before it is saved. I've made some modifications in the way HikaShop deals with that total_number_of_products value so that it can't create an error in such cases. Download the HikaShop install package on our website and install it on yours to get the patch and you should not get the error anymore, even without the column in the database.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 years 3 months ago | | [](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353000) | [error in checkout after update to 4.7.4](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353000 "-- url of the page with the problem -- : www.geertswarenhui -- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.1.18 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Unknown column 'total_number_of_products' in 'field list' Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli_query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2515 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:208 5 hikashopOrderClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:913 6 hikashopOrderClass->createFromCart() JROOT/components/com_hikashop/controllers/checkout.php:678 7 checkoutController->confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2441 9 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:88 10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 Hi, Very serious problem: my customers can't order right now: Unknown column 'total_number_of_products' in 'field list' Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli_query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2515 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:208 5 hikashopOrderClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:913 6 hikashopOrderClass->createFromCart() JROOT/components/com_hikashop/controllers/checkout.php:678 7 checkoutController->confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2441 9 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:88 10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 What to do?") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 3 months ago, by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile") [Last Post](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353047 "Hi, Indeed. The message from Jerome actually missled me to a wrong conclusion. There is no such column and it's normal. You can always create it and it will solve the problem. But it should not be necessary. I suppose you must be using some 3rd party plugin implementing the onBeforeOrderCreate event and messing with the order object before it is saved. I've made some modifications in the way HikaShop deals with that total_number_of_products value so that it can't create an error in such cases. Download the HikaShop install package on our website and install it on yours to get the patch and you should not get the error anymore, even without the column in the database.") 3 years 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:753 | [Last Post](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353047 "Hi, Indeed. The message from Jerome actually missled me to a wrong conclusion. There is no such column and it's normal. You can always create it and it will solve the problem. But it should not be necessary. I suppose you must be using some 3rd party plugin implementing the onBeforeOrderCreate event and messing with the order object before it is saved. I've made some modifications in the way HikaShop deals with that total_number_of_products value so that it can't create an error in such cases. Download the HikaShop install package on our website and install it on yours to get the patch and you should not get the error anymore, even without the column in the database.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 years 3 months ago | | [](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#352923) | [error in checkout after update to 4.7.4](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#352923 "-- url of the page with the problem -- : www.geertswarenhui -- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.1.18 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Unknown column 'total_number_of_products' in 'field list' Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli_query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2515 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:208 5 hikashopOrderClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:913 6 hikashopOrderClass->createFromCart() JROOT/components/com_hikashop/controllers/checkout.php:678 7 checkoutController->confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2441 9 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:88 10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 Hi, Very serious problem: my customers can't order right now: Unknown column 'total_number_of_products' in 'field list' Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli_query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2515 4 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:208 5 hikashopOrderClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:913 6 hikashopOrderClass->createFromCart() JROOT/components/com_hikashop/controllers/checkout.php:678 7 checkoutController->confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2441 9 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:88 10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 What to do?") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 3 years 3 months ago, by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile") [Last Post](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353047 "Hi, Indeed. The message from Jerome actually missled me to a wrong conclusion. There is no such column and it's normal. You can always create it and it will solve the problem. But it should not be necessary. I suppose you must be using some 3rd party plugin implementing the onBeforeOrderCreate event and messing with the order object before it is saved. I've made some modifications in the way HikaShop deals with that total_number_of_products value so that it can't create an error in such cases. Download the HikaShop install package on our website and install it on yours to get the patch and you should not get the error anymore, even without the column in the database.") 3 years 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:753 | [Last Post](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353047 "Hi, Indeed. The message from Jerome actually missled me to a wrong conclusion. There is no such column and it's normal. You can always create it and it will solve the problem. But it should not be necessary. I suppose you must be using some 3rd party plugin implementing the onBeforeOrderCreate event and messing with the order object before it is saved. I've made some modifications in the way HikaShop deals with that total_number_of_products value so that it can't create an error in such cases. Download the HikaShop install package on our website and install it on yours to get the patch and you should not get the error anymore, even without the column in the database.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 years 3 months ago | | [](/forum/29-payment-methods/889803-do-not-select-default-shipping-and-payment-method#273075) | [Do not select default shipping and payment method](/forum/29-payment-methods/889803-do-not-select-default-shipping-and-payment-method#273075 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6 -- PHP version -- : 5.6 We notice that a default shipping and payment method was selected in the latest version of Hikashop We remember that there is a setting in configuration to control this behavior so no default was selected How can we control this behavior now or change the default selected method?") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 9 years 6 months ago, by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") [Last Post](/forum/29-payment-methods/889803-do-not-select-default-shipping-and-payment-method#297057 "Hello, I'm afraid that your question is not related to that forum thread. Please create a new one. Regards,") 8 years 2 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:9 Views:2244 | [Last Post](/forum/29-payment-methods/889803-do-not-select-default-shipping-and-payment-method#297057 "Hello, I'm afraid that your question is not related to that forum thread. Please create a new one. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 8 years 2 months ago | | [](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264529) | [Filter on product in acymailing sql error](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264529 "-- url of the page with the problem -- : geertswarenhuis.nl -- HikaShop version -- : 3.0.0 -- Joomla version -- : 3.6.5 -- PHP version -- : 5 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'a.product_parent_id' in 'on clause' SQL=SELECT DISTINCT b.user_email FROM j17_hikashop_order_product AS a LEFT JOIN j17_hikashop_order AS c ON a.order_id = c.order_id LEFT JOIN j17_hikashop_user AS b on c.order_user_id = b.user_id LEFT JOIN j17_hikashop_product_category AS hkpc ON (a.product_id = hkpc.product_id) OR (a.product_parent_id > 0 AND a.product_parent_id = hkpc.product_id) WHERE c.order_status IN ('confirmed','shipped') AND hkpc.category_id = 67 Hi, I get this error if I try to do the action in the screenshot. Make a list based on whom bought a product from a specific product category An error has occurred. 1054 Unknown column 'a.product_parent_id' in 'on clause' SQL=SELECT DISTINCT b.user_email FROM j17_hikashop_order_product AS a LEFT JOIN j17_hikashop_order AS c ON a.order_id = c.order_id LEFT JOIN j17_hikashop_user AS b on c.order_user_id = b.user_id LEFT JOIN j17_hikashop_product_category AS hkpc ON (a.product_id = hkpc.product_id) OR (a.product_parent_id > 0 AND a.product_parent_id = hkpc.product_id) WHERE c.order_status IN ('confirmed','shipped') AND hkpc.category_id = 67") Category: [Integrations](/forum/30-integrations "Informations on all the different integrations available for Hikashop") Topic started 9 years 7 months ago, by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile") [Last Post](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264535 "Hi, With the "hikashop orders" filter, you can select the status you want for your filter. And for the "hikashop customers" filter, it uses the order statuses that are enabled in the "invoice" column of your menu System>Order statuses. This however requires that you enable some statuses there, which wasn't the case, and that the order_status column in the hikashop_order table contains the namekey of these order statuses ( confirmed or shipped for example), and not their translation. So as long as your store is properly configured and that the statuses of your orders in the database have the correct values, it should work like you want.") 9 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:8 Views:2210 | [Last Post](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264535 "Hi, With the "hikashop orders" filter, you can select the status you want for your filter. And for the "hikashop customers" filter, it uses the order statuses that are enabled in the "invoice" column of your menu System>Order statuses. This however requires that you enable some statuses there, which wasn't the case, and that the order_status column in the hikashop_order table contains the namekey of these order statuses ( confirmed or shipped for example), and not their translation. So as long as your store is properly configured and that the statuses of your orders in the database have the correct values, it should work like you want.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 7 months ago | | [](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264008) | [Filter on product in acymailing sql error](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264008 "-- url of the page with the problem -- : geertswarenhuis.nl -- HikaShop version -- : 3.0.0 -- Joomla version -- : 3.6.5 -- PHP version -- : 5 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'a.product_parent_id' in 'on clause' SQL=SELECT DISTINCT b.user_email FROM j17_hikashop_order_product AS a LEFT JOIN j17_hikashop_order AS c ON a.order_id = c.order_id LEFT JOIN j17_hikashop_user AS b on c.order_user_id = b.user_id LEFT JOIN j17_hikashop_product_category AS hkpc ON (a.product_id = hkpc.product_id) OR (a.product_parent_id > 0 AND a.product_parent_id = hkpc.product_id) WHERE c.order_status IN ('confirmed','shipped') AND hkpc.category_id = 67 Hi, I get this error if I try to do the action in the screenshot. Make a list based on whom bought a product from a specific product category An error has occurred. 1054 Unknown column 'a.product_parent_id' in 'on clause' SQL=SELECT DISTINCT b.user_email FROM j17_hikashop_order_product AS a LEFT JOIN j17_hikashop_order AS c ON a.order_id = c.order_id LEFT JOIN j17_hikashop_user AS b on c.order_user_id = b.user_id LEFT JOIN j17_hikashop_product_category AS hkpc ON (a.product_id = hkpc.product_id) OR (a.product_parent_id > 0 AND a.product_parent_id = hkpc.product_id) WHERE c.order_status IN ('confirmed','shipped') AND hkpc.category_id = 67") Category: [Integrations](/forum/30-integrations "Informations on all the different integrations available for Hikashop") Topic started 9 years 7 months ago, by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile") [Last Post](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264535 "Hi, With the "hikashop orders" filter, you can select the status you want for your filter. And for the "hikashop customers" filter, it uses the order statuses that are enabled in the "invoice" column of your menu System>Order statuses. This however requires that you enable some statuses there, which wasn't the case, and that the order_status column in the hikashop_order table contains the namekey of these order statuses ( confirmed or shipped for example), and not their translation. So as long as your store is properly configured and that the statuses of your orders in the database have the correct values, it should work like you want.") 9 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:8 Views:2210 | [Last Post](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264535 "Hi, With the "hikashop orders" filter, you can select the status you want for your filter. And for the "hikashop customers" filter, it uses the order statuses that are enabled in the "invoice" column of your menu System>Order statuses. This however requires that you enable some statuses there, which wasn't the case, and that the order_status column in the hikashop_order table contains the namekey of these order statuses ( confirmed or shipped for example), and not their translation. So as long as your store is properly configured and that the statuses of your orders in the database have the correct values, it should work like you want.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 7 months ago | | [](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#263920) | [Filter on product in acymailing sql error](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#263920 "-- url of the page with the problem -- : geertswarenhuis.nl -- HikaShop version -- : 3.0.0 -- Joomla version -- : 3.6.5 -- PHP version -- : 5 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'a.product_parent_id' in 'on clause' SQL=SELECT DISTINCT b.user_email FROM j17_hikashop_order_product AS a LEFT JOIN j17_hikashop_order AS c ON a.order_id = c.order_id LEFT JOIN j17_hikashop_user AS b on c.order_user_id = b.user_id LEFT JOIN j17_hikashop_product_category AS hkpc ON (a.product_id = hkpc.product_id) OR (a.product_parent_id > 0 AND a.product_parent_id = hkpc.product_id) WHERE c.order_status IN ('confirmed','shipped') AND hkpc.category_id = 67 Hi, I get this error if I try to do the action in the screenshot. Make a list based on whom bought a product from a specific product category An error has occurred. 1054 Unknown column 'a.product_parent_id' in 'on clause' SQL=SELECT DISTINCT b.user_email FROM j17_hikashop_order_product AS a LEFT JOIN j17_hikashop_order AS c ON a.order_id = c.order_id LEFT JOIN j17_hikashop_user AS b on c.order_user_id = b.user_id LEFT JOIN j17_hikashop_product_category AS hkpc ON (a.product_id = hkpc.product_id) OR (a.product_parent_id > 0 AND a.product_parent_id = hkpc.product_id) WHERE c.order_status IN ('confirmed','shipped') AND hkpc.category_id = 67") Category: [Integrations](/forum/30-integrations "Informations on all the different integrations available for Hikashop") Topic started 9 years 7 months ago, by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile") [Last Post](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264535 "Hi, With the "hikashop orders" filter, you can select the status you want for your filter. And for the "hikashop customers" filter, it uses the order statuses that are enabled in the "invoice" column of your menu System>Order statuses. This however requires that you enable some statuses there, which wasn't the case, and that the order_status column in the hikashop_order table contains the namekey of these order statuses ( confirmed or shipped for example), and not their translation. So as long as your store is properly configured and that the statuses of your orders in the database have the correct values, it should work like you want.") 9 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:8 Views:2210 | [Last Post](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264535 "Hi, With the "hikashop orders" filter, you can select the status you want for your filter. And for the "hikashop customers" filter, it uses the order statuses that are enabled in the "invoice" column of your menu System>Order statuses. This however requires that you enable some statuses there, which wasn't the case, and that the order_status column in the hikashop_order table contains the namekey of these order statuses ( confirmed or shipped for example), and not their translation. So as long as your store is properly configured and that the statuses of your orders in the database have the correct values, it should work like you want.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 7 months ago | | [](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#263739) | [Filter on product in acymailing sql error](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#263739 "-- url of the page with the problem -- : geertswarenhuis.nl -- HikaShop version -- : 3.0.0 -- Joomla version -- : 3.6.5 -- PHP version -- : 5 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'a.product_parent_id' in 'on clause' SQL=SELECT DISTINCT b.user_email FROM j17_hikashop_order_product AS a LEFT JOIN j17_hikashop_order AS c ON a.order_id = c.order_id LEFT JOIN j17_hikashop_user AS b on c.order_user_id = b.user_id LEFT JOIN j17_hikashop_product_category AS hkpc ON (a.product_id = hkpc.product_id) OR (a.product_parent_id > 0 AND a.product_parent_id = hkpc.product_id) WHERE c.order_status IN ('confirmed','shipped') AND hkpc.category_id = 67 Hi, I get this error if I try to do the action in the screenshot. Make a list based on whom bought a product from a specific product category An error has occurred. 1054 Unknown column 'a.product_parent_id' in 'on clause' SQL=SELECT DISTINCT b.user_email FROM j17_hikashop_order_product AS a LEFT JOIN j17_hikashop_order AS c ON a.order_id = c.order_id LEFT JOIN j17_hikashop_user AS b on c.order_user_id = b.user_id LEFT JOIN j17_hikashop_product_category AS hkpc ON (a.product_id = hkpc.product_id) OR (a.product_parent_id > 0 AND a.product_parent_id = hkpc.product_id) WHERE c.order_status IN ('confirmed','shipped') AND hkpc.category_id = 67") Category: [Integrations](/forum/30-integrations "Informations on all the different integrations available for Hikashop") Topic started 9 years 7 months ago, by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile") [Last Post](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264535 "Hi, With the "hikashop orders" filter, you can select the status you want for your filter. And for the "hikashop customers" filter, it uses the order statuses that are enabled in the "invoice" column of your menu System>Order statuses. This however requires that you enable some statuses there, which wasn't the case, and that the order_status column in the hikashop_order table contains the namekey of these order statuses ( confirmed or shipped for example), and not their translation. So as long as your store is properly configured and that the statuses of your orders in the database have the correct values, it should work like you want.") 9 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:8 Views:2210 | [Last Post](/forum/30-integrations/889117-filter-on-product-in-acymailing-sql-error#264535 "Hi, With the "hikashop orders" filter, you can select the status you want for your filter. And for the "hikashop customers" filter, it uses the order statuses that are enabled in the "invoice" column of your menu System>Order statuses. This however requires that you enable some statuses there, which wasn't the case, and that the order_status column in the hikashop_order table contains the namekey of these order statuses ( confirmed or shipped for example), and not their translation. So as long as your store is properly configured and that the statuses of your orders in the database have the correct values, it should work like you want.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 7 months ago | | [](/forum/35-orders-management/888563-all-orders-of-all-times-have-status-of-created-instead-of-status-the-actually#260809) | [all orders of all times have status of 'created' instead of status the actually](/forum/35-orders-management/888563-all-orders-of-all-times-have-status-of-created-instead-of-status-the-actually#260809 "-- HikaShop version -- : 3.0.0 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.5.38 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : no The order history when you open an order is correct, but the dropdown are showing 'created' but then in dutch (aangemaakt). Very difficult to work with the orders and see which one you have already done. It is at all orders sinds years. bug in the new 3.0.0?") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 9 years 8 months ago, by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile") [Last Post](/forum/35-orders-management/888563-all-orders-of-all-times-have-status-of-created-instead-of-status-the-actually#260818 "The order status system was completely changed for hikashop 3. We put in place a script to migrate the order status data when the update is done so that it should be transparent. Maybe the script did run properl for you. Try the "check database" button of the hikashop configuration. It might help fixing that. Otherwise, could you provide a screenshot of the orders listing and of the menu System > Order statuses while being logged in in English ?") 9 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:969 | [Last Post](/forum/35-orders-management/888563-all-orders-of-all-times-have-status-of-created-instead-of-status-the-actually#260818 "The order status system was completely changed for hikashop 3. We put in place a script to migrate the order status data when the update is done so that it should be transparent. Maybe the script did run properl for you. Try the "check database" button of the hikashop configuration. It might help fixing that. Otherwise, could you provide a screenshot of the orders listing and of the menu System > Order statuses while being logged in in English ?") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 9 years 8 months ago | | [](/forum/27-checkout/875524-prices-in-checkout-are-duplicated#203028) | [prices in checkout are duplicated](/forum/27-checkout/875524-prices-in-checkout-are-duplicated#203028 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.0 -- PHP version -- : 5.5.14 -- Browser(s) name and version -- : Chrome 40.0.2214.115 -- Error-message(debug-mod must be tuned on) -- : error reporting maximum gives blank page. After update to this version this problem came: We have one category 'Kleding' (cloth) that gives us problems; when you add a item to the cart the total price is twice the amount of the item. Please see screenshot for the problems; There is also a ,. in shopping cart / price so the price has to be 20,00 but it shows: 20,.00 There is no coupon active on that categorie.") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 11 years 7 months ago, by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile") [Last Post](/forum/27-checkout/875524-prices-in-checkout-are-duplicated#203090 "Hi, I've checked your website but I don't see the problem there : take.ms/E7LlF Am I missing something ?") 11 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:18 Views:780 | [Last Post](/forum/27-checkout/875524-prices-in-checkout-are-duplicated#203090 "Hi, I've checked your website but I don't see the problem there : take.ms/E7LlF Am I missing something ?") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 4 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.225 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)