[Skip to main content](#vessel-content) # 1052 column 'product\_id' in where clause is ambiguous ## - **[Igor\_UA](/forum/user/51250-igor-ua "View Igor_UA's Profile")** - [![Igor_UA's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar51250.jpg)](/forum/user/51250-igor-ua "View Igor_UA's Profile") Topic Author - [ Offline](/forum/user/51250-igor-ua) Less More - Posts: 57 - Thank you received: 0 - - 8 years 9 months ago [\#286238](#286238) by [Igor\_UA](/forum/user/51250-igor-ua "View Igor_UA's Profile") *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#286238 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* was created by *[Igor\_UA](/forum/user/51250-igor-ua "View Igor_UA's Profile")* -- url of the page with the problem -- : [ panda-ua.com/мужчинам/мужские-кошельки-портмоне](https://panda-ua.com/%D0%BC%D1%83%D0%B6%D1%87%D0%B8%D0%BD%D0%B0%D0%BC/%D0%BC%D1%83%D0%B6%D1%81%D0%BA%D0%B8%D0%B5-%D0%BA%D0%BE%D1%88%D0%B5%D0%BB%D1%8C%D0%BA%D0%B8-%D0%BF%D0%BE%D1%80%D1%82%D0%BC%D0%BE%D0%BD%D0%B5) -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 8 years 9 months ago [\#286240](#286240) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#286240 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* Hello, Please activate temporally the Joomla debug mode in order to have the call stack. The full SQL query and the file where that query is generated will be required in order to understand the issue. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Igor\_UA](/forum/user/51250-igor-ua "View Igor_UA's Profile")** - [![Igor_UA's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar51250.jpg)](/forum/user/51250-igor-ua "View Igor_UA's Profile") Topic Author - [ Offline](/forum/user/51250-igor-ua) Less More - Posts: 57 - Thank you received: 0 - - 8 years 9 months ago [\#286265](#286265) by [Igor\_UA](/forum/user/51250-igor-ua "View Igor_UA's Profile") Replied by *[Igor\_UA](/forum/user/51250-igor-ua "View Igor_UA's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#286265 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* [ ![file_cd8ab0b.jpg](/forum/attachment/42240) ](/forum/attachment/42240 "file_cd8ab0b.jpg") - [ ![file_cd8ab0b.jpg](/forum/attachment/42240) ](/forum/attachment/42240 "file_cd8ab0b.jpg") [ ](/forum/attachment/42240?download=1 "file_cd8ab0b.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 8 years 9 months ago [\#286268](#286268) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#286268 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* Hello, Unfortunately, there is not the full SQL query which would allow us to understand where and what that query is. Please try to use the default Joomla template and check again your settings for the Joomla debug mode. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 8 years 8 months ago [\#287398](#287398) by [renem](/forum/user/47055-renem "View renem's Profile") Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#287398 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* Same problem here. It has something to do with the HikaShop Content Module. When i disable this module the problem is gone. This is since i updated from version 3.2.1 to version 3.2.2 any clue? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14280 - - 8 years 8 months ago [\#287405](#287405) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#287405 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* Hi, In the file /libraries/joomla/database/exception/executing.php change the line: parent::__construct($message, $code, $previous); to: parent::__construct($message.' '.$query, $code, $previous); That should provide the full MySQL query which will help understand the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 8 years 8 months ago [\#287426](#287426) by [renem](/forum/user/47055-renem "View renem's Profile") Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#287426 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* Hi Nicolas this is the Query Code: 1052 FOUT: 1052 Column 'product_id' in where clause is ambiguous SELECT DISTINCT b.* FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_product AS b ON a.product_id=b.product_id WHERE (b.product_published = 1) AND (b.product_type = 'main') AND (a.category_id IN (2)) AND (product_id = 0) AND (b.product_quantity!=0) AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) ORDER BY a.ordering ASC LIMIT 0, 4 Kind regards René Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14280 - - 8 years 8 months ago [\#287435](#287435) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#287435 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* Hi, Great. Edit the file components/com_hikashop/views/product/view.html.php and change the line: Code: $filters[] = 'product_id = 0'; to: Code: $filters[] = 'b.product_id = 0'; That should fix the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14280 - - 8 years 8 months ago [\#287437](#287437) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#287437 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* Note that you probably want to turn off the "discount only" setting in your products listings menu item/module. Because this means that you have a listing of products without any products that will display because there are no discounts for the products of the listing. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[renem](/forum/user/47055-renem "View renem's Profile")** - [![renem's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar47055.jpg)](/forum/user/47055-renem "View renem's Profile") - [ Offline](/forum/user/47055-renem) Less More - Posts: 198 - Thank you received: 7 - - - [](http://www.muldermedia.nl) - 8 years 8 months ago [\#287440](#287440) by [renem](/forum/user/47055-renem "View renem's Profile") Replied by *[renem](/forum/user/47055-renem "View renem's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#287440 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* Hi Nicolas, I turned off "Discount Only" and that solved the problem. Kind regards René Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Igor\_UA](/forum/user/51250-igor-ua "View Igor_UA's Profile")** - [![Igor_UA's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar51250.jpg)](/forum/user/51250-igor-ua "View Igor_UA's Profile") Topic Author - [ Offline](/forum/user/51250-igor-ua) Less More - Posts: 57 - Thank you received: 0 - - 8 years 8 months ago [\#287701](#287701) by [Igor\_UA](/forum/user/51250-igor-ua "View Igor_UA's Profile") Replied by *[Igor\_UA](/forum/user/51250-igor-ua "View Igor_UA's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#287701 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* [ ![file_ffd86bd.jpg](/forum/attachment/42579) ](/forum/attachment/42579 "file_ffd86bd.jpg") - [ ![file_ffd86bd.jpg](/forum/attachment/42579) ](/forum/attachment/42579 "file_ffd86bd.jpg") [ ](/forum/attachment/42579?download=1 "file_ffd86bd.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 8 years 8 months ago [\#287702](#287702) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1052 column 'product\_id' in where clause is ambiguous](/forum/25-install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous#287702 "-- url of the page with the problem -- : panda-ua.com/мужчинам/мужские-кошельки-портмоне -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0 -- Browser(s) name and version -- : Google Chrome 63.0.3239.132 -- Error-message(debug-mod must be tuned on) -- : 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS After the component version update, error 1052 COLUMN 'PRODUCT_ID' IN WHERE CLAUSE IS AMBIGUOUS appeared. How to fix it? The fix of the Joomla database did not help. Checking the Hikashop database also did not reveal anything ...")* Hello, You have three solutions. 1 - Update to HikaShop 3.3.0 which already contain a patch for that.. 2 - Do than renem wrote > I turned off "Discount Only" and that solved the problem. 3 -edit the file "components/com_hikashop/view/product/view.html.php" and replace Code: if(!$matchingDiscount) { $filters[] = 'product_id = 0'; } By Code: if(!$matchingDiscount) { $filters[] = 'b.product_id = 0'; } Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MzUxOS0xMDUyLWNvbHVtbi1wcm9kdWN0LWlkLWluLXdoZXJlLWNsYXVzZS1pcy1hbWJpZ3VvdXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.089 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)