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

#   1064 You have an error in your SQL syntax

##

- **[MichelH](/forum/user/32735-michelh "View MichelH's Profile")**
- [![MichelH's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32735-michelh "View MichelH's Profile") Topic Author
- [ Offline](/forum/user/32735-michelh)

Less More

- Posts: 7
- Thank you received: 0
-
-

10 years 9 months ago [\#225375](#225375) by [MichelH](/forum/user/32735-michelh "View MichelH's Profile")  *[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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;loadResult();")* was created by *[MichelH](/forum/user/32735-michelh "View MichelH's Profile")*

-- 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-&gt;getRoot().' AND category_type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1';
$this-&gt;database-&gt;setQuery($query);
$element = (int)$this-&gt;database-&gt;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-&gt;getRoot().' AND category_type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1';
$this-&gt;database-&gt;setQuery($query);
$element = (int)$this-&gt;database-&gt;loadResult();

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4MTMzMS0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

10 years 9 months ago [\#225378](#225378) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#225378 "-- 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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;loadResult();")*

Hi,

Change the line: Code:

$ids[] = $mainProduct-&gt;product_id;

to: Code:

$ids[] = (int)$mainProduct-&gt;product_id;

and change the line: Code:

$query-&gt;where = array('product_id IN ('.implode(',',$ids).') OR product_parent_id IN ('.implode(',',$ids).')');

to: Code:

if(count($ids)) $query-&gt;where = array('product_id IN ('.implode(',',$ids).') OR product_parent_id IN ('.implode(',',$ids).')'); else $query-&gt;where = array('product_id=0');

in the file plugins/hikashop/massaction_product/massaction_product.php

and that should fix that problem.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4MTMzMS0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

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

Less More

- Posts: 11
- Thank you received: 0
-
-

8 years 5 months ago [\#292611](#292611) by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile")  Replied by *[kaimor](/forum/user/33061-kaimor "View kaimor's Profile")* on topic *[1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292611 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.4.3 -- Error-message(debug-mod must be tuned on) -- : I receive the error message when i do mass action on root category:  1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;loadResult();")*

I've got this message when trying to access Dashboard for HikaShop:
An error has occurred.
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 '*, COUNT(a.order_id) AS total FROM #__hikashop_order AS a LEFT JOIN #__hik' at line 1

What to do?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4MTMzMS0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

8 years 5 months ago [\#292622](#292622) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292622 "-- 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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;loadResult();")*

Hi,

Do that modification in order to get the full MySQL query leading to that error:
[ www.hikashop.com/support/forum/2-general...ror-1054.html#287524](https://www.hikashop.com/support/forum/2-general-talk-about-hikashop/893728-sort-by-price-for-variants-error-1054.html#287524)
That will allow us to have a better picture of the situation.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4MTMzMS0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

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

Less More

- Posts: 11
- Thank you received: 0
-
-

8 years 5 months ago -  8 years 5 months ago [\#292630](#292630) by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile")  Replied by *[kaimor](/forum/user/33061-kaimor "View kaimor's Profile")* on topic *[1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292630 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.4.3 -- Error-message(debug-mod must be tuned on) -- : I receive the error message when i do mass action on root category:  1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;loadResult();")*

Hi,

New MySQL query leading to that error:
([ www.hikashop.com/support/forum/2-general...ror-1054.html#287524](http://www.hikashop.com/support/forum/2-general...ror-1054.html#287524))

An error has occurred.
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 '*, COUNT(a.order_id) AS total FROM #__hikashop_order AS a LEFT JOIN #__hik' at line 1 SELECT DISTINCT(prod.order_product_id), *, COUNT(a.order_id) AS total FROM hklco_hikashop_order AS a LEFT JOIN hklco_hikashop_order_product AS prod ON prod.order_id = a.order_id LEFT JOIN hklco_hikashop_product AS p ON prod.product_id = p.product_id LEFT JOIN hklco_hikashop_product_category AS cat ON cat.product_id = p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN hklco_hikashop_category AS categ ON cat.category_id = categ.category_id LEFT JOIN hklco_hikashop_address AS b ON a.order_billing_address_id=b.address_id LEFT JOIN hklco_hikashop_zone AS z ON b.address_country=z.zone_namekey WHERE a.order_type='sale' AND a.order_status IN ('confirmed') AND cat.category_id IN ('40','41','42','43','44','45') AND a.order_created &gt; 1493622000 AND a.order_created &lt; 1554069540 GROUP BY z.zone_namekey

Last edit: 8 years 5 months ago by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4MTMzMS0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

8 years 5 months ago [\#292638](#292638) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292638 "-- 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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;loadResult();")*

Hi,

It's apparently coming from a report which has been configured in a strange way. Disable them one by one via the menu Orders&gt;Reports in order to find the one causing the issue. Then, delete it, or keep it unpublished and reconfigure it.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4MTMzMS0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

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

Less More

- Posts: 11
- Thank you received: 0
-
-

8 years 5 months ago [\#292666](#292666) by [kaimor](/forum/user/33061-kaimor "View kaimor's Profile")  Replied by *[kaimor](/forum/user/33061-kaimor "View kaimor's Profile")* on topic *[1064 You have an error in your SQL syntax](/forum/25-install-update/881331-1064-you-have-an-error-in-your-sql-syntax#292666 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.4.3 -- Error-message(debug-mod must be tuned on) -- : I receive the error message when i do mass action on root category:  1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;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&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500' at line 1 SQL=SELECT hk&#95;product.&#42; FROM Chau&#95;hikashop&#95;product as hk&#95;product WHERE (product&#95;id IN () OR product&#95;parent&#95;id IN ()) ORDER BY product&#95;code DESC LIMIT 0, 500  I make the following change and same problem  $query = 'SELECT category&#95;id FROM '.hikashop&#95;table('category').' WHERE category&#95;parent&#95;id='.(int)$this-&gt;getRoot().' AND category&#95;type='.(int)$this-&gt;database-&gt;Quote($element).' LIMIT 1'; $this-&gt;database-&gt;setQuery($query); $element = (int)$this-&gt;database-&gt;loadResult();")*

Thank you,
It was "Map" report.
Now all is all right! ![:)](/media/kunena/emoticons/8.png ":)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4MTMzMS0xMDY0LXlvdS1oYXZlLWFuLWVycm9yLWluLXlvdXItc3FsLXN5bnRheD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; 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.234 seconds

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

[](#top)
