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

#   Random Error 1064 after Upgrade

##

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

Less More

- Posts: 41
- Thank you received: 1
-
-

12 years 10 months ago -  12 years 10 months ago [\#136297](#136297) by [wild4gsus](/forum/user/28153-wild4gsus "View wild4gsus's Profile")  *[Random Error 1064 after Upgrade](/forum/25-install-update/864302-random-error-1064-after-upgrade#136297 "-- url of the page with the problem -- :   www.showcarcustoms.com/fbs  -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox, Chrome -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  Just upgraded Joomla version and Hikashop. All seemed well until I randomly got this message (below). I've got it on a few different products that were all previously there before the upgrade. One product that I added before the upgrade, but updated after the upgrade, I seem to get it on the most, so I temporarily disabled it. One minute it will work, the next, it won't. Any insight as to where the problem is? I'd like to start selling the product that I'm having the most issues with today, but I won't enable it until I know it is fixed.  Error: 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 ') AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access ' at line 1 SQL=SELECT DISTINCT b.&#42; FROM &#91;strike&#93;XXXX&#91;/strike&#93;&#95;hikashop&#95;product AS b WHERE b.product&#95;published=1 AND b.product&#95;id IN () AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;id ASC LIMIT 0, 3  You may not be able to visit this page because of:  an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request.")* was created by *[wild4gsus](/forum/user/28153-wild4gsus "View wild4gsus's Profile")*

-- url of the page with the problem -- : [ www.showcarcustoms.com/fbs](http://www.showcarcustoms.com/fbs)
-- HikaShop version -- : 2.2.3
-- Joomla version -- : 3.2
-- PHP version -- : 5.3.27
-- Browser(s) name and version -- : Firefox, Chrome
-- Error-message(debug-mod must be tuned on) -- : Error_message

Just upgraded Joomla version and Hikashop. All seemed well until I randomly got this message (below). I've got it on a few different products that were all previously there before the upgrade. One product that I added before the upgrade, but updated after the upgrade, I seem to get it on the most, so I temporarily disabled it. One minute it will work, the next, it won't. Any insight as to where the problem is? I'd like to start selling the product that I'm having the most issues with today, but I won't enable it until I know it is fixed.

Error: 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 ') AND b.product_type = 'main' AND (b.product_access = 'all' OR b.product_access ' at line 1 SQL=SELECT DISTINCT b.* FROM [strike]XXXX[/strike]_hikashop_product AS b WHERE b.product_published=1 AND b.product_id IN () AND b.product_type = 'main' AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY b.product_id ASC LIMIT 0, 3

You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.

Last edit: 12 years 10 months ago by [wild4gsus](/forum/user/28153-wild4gsus "View wild4gsus's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NDMwMi1yYW5kb20tZXJyb3ItMTA2NC1hZnRlci11cGdyYWRlP3RtcGw9bWFya2Rvd24=) 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
-
-

12 years 10 months ago [\#136316](#136316) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Random Error 1064 after Upgrade](/forum/25-install-update/864302-random-error-1064-after-upgrade#136316 "-- url of the page with the problem -- :   www.showcarcustoms.com/fbs  -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox, Chrome -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  Just upgraded Joomla version and Hikashop. All seemed well until I randomly got this message (below). I've got it on a few different products that were all previously there before the upgrade. One product that I added before the upgrade, but updated after the upgrade, I seem to get it on the most, so I temporarily disabled it. One minute it will work, the next, it won't. Any insight as to where the problem is? I'd like to start selling the product that I'm having the most issues with today, but I won't enable it until I know it is fixed.  Error: 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 ') AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access ' at line 1 SQL=SELECT DISTINCT b.&#42; FROM &#91;strike&#93;XXXX&#91;/strike&#93;&#95;hikashop&#95;product AS b WHERE b.product&#95;published=1 AND b.product&#95;id IN () AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;id ASC LIMIT 0, 3  You may not be able to visit this page because of:  an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request.")*

Hi,

That's a simple check which is missing somewhere because the condition b.product_id IN () shouldn't be in the query if there are no products.
The issue is that such query is at several places in HikaShop so I need more debug data to be able to tel you what to do exactly to fix that.
Please turn on the debug mode of the joomla configuration and try again. That should display the error with more information (a backtrace). If you could copy/paste it here, that would be great.

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

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

Less More

- Posts: 41
- Thank you received: 1
-
-

12 years 10 months ago -  12 years 10 months ago [\#136327](#136327) by [wild4gsus](/forum/user/28153-wild4gsus "View wild4gsus's Profile")  Replied by *[wild4gsus](/forum/user/28153-wild4gsus "View wild4gsus's Profile")* on topic *[Random Error 1064 after Upgrade](/forum/25-install-update/864302-random-error-1064-after-upgrade#136327 "-- url of the page with the problem -- :   www.showcarcustoms.com/fbs  -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox, Chrome -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  Just upgraded Joomla version and Hikashop. All seemed well until I randomly got this message (below). I've got it on a few different products that were all previously there before the upgrade. One product that I added before the upgrade, but updated after the upgrade, I seem to get it on the most, so I temporarily disabled it. One minute it will work, the next, it won't. Any insight as to where the problem is? I'd like to start selling the product that I'm having the most issues with today, but I won't enable it until I know it is fixed.  Error: 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 ') AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access ' at line 1 SQL=SELECT DISTINCT b.&#42; FROM &#91;strike&#93;XXXX&#91;/strike&#93;&#95;hikashop&#95;product AS b WHERE b.product&#95;published=1 AND b.product&#95;id IN () AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;id ASC LIMIT 0, 3  You may not be able to visit this page because of:  an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request.")*

The errors relate to duplicates. I'll PM you a login so you can see the list of duplicates. Not sure why that happened.

The product that it happens to the most is the Calendar under the "Household" link.

Last edit: 12 years 10 months ago by [wild4gsus](/forum/user/28153-wild4gsus "View wild4gsus's Profile"). Reason: added product

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NDMwMi1yYW5kb20tZXJyb3ItMTA2NC1hZnRlci11cGdyYWRlP3RtcGw9bWFya2Rvd24=) 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
-
-

12 years 10 months ago [\#136333](#136333) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Random Error 1064 after Upgrade](/forum/25-install-update/864302-random-error-1064-after-upgrade#136333 "-- url of the page with the problem -- :   www.showcarcustoms.com/fbs  -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox, Chrome -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  Just upgraded Joomla version and Hikashop. All seemed well until I randomly got this message (below). I've got it on a few different products that were all previously there before the upgrade. One product that I added before the upgrade, but updated after the upgrade, I seem to get it on the most, so I temporarily disabled it. One minute it will work, the next, it won't. Any insight as to where the problem is? I'd like to start selling the product that I'm having the most issues with today, but I won't enable it until I know it is fixed.  Error: 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 ') AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access ' at line 1 SQL=SELECT DISTINCT b.&#42; FROM &#91;strike&#93;XXXX&#91;/strike&#93;&#95;hikashop&#95;product AS b WHERE b.product&#95;published=1 AND b.product&#95;id IN () AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;id ASC LIMIT 0, 3  You may not be able to visit this page because of:  an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request.")*

Change the line: Code:

$filters[]='b.product_id IN ('.implode(',',$ids_for_the_query).')';

to: Code:

if(count($ids_for_the_query)){ $filters[]='b.product_id IN ('.implode(',',$ids_for_the_query).')'; }else{ $filters[]='b.product_id=0'; }

in the file components/com_hikashop/views/product/view.html.php and that should help.

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

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

Less More

- Posts: 41
- Thank you received: 1
-
-

12 years 10 months ago [\#136337](#136337) by [wild4gsus](/forum/user/28153-wild4gsus "View wild4gsus's Profile")  Replied by *[wild4gsus](/forum/user/28153-wild4gsus "View wild4gsus's Profile")* on topic *[Random Error 1064 after Upgrade](/forum/25-install-update/864302-random-error-1064-after-upgrade#136337 "-- url of the page with the problem -- :   www.showcarcustoms.com/fbs  -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox, Chrome -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  Just upgraded Joomla version and Hikashop. All seemed well until I randomly got this message (below). I've got it on a few different products that were all previously there before the upgrade. One product that I added before the upgrade, but updated after the upgrade, I seem to get it on the most, so I temporarily disabled it. One minute it will work, the next, it won't. Any insight as to where the problem is? I'd like to start selling the product that I'm having the most issues with today, but I won't enable it until I know it is fixed.  Error: 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 ') AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access ' at line 1 SQL=SELECT DISTINCT b.&#42; FROM &#91;strike&#93;XXXX&#91;/strike&#93;&#95;hikashop&#95;product AS b WHERE b.product&#95;published=1 AND b.product&#95;id IN () AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;id ASC LIMIT 0, 3  You may not be able to visit this page because of:  an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request.")*

So far, so good! I'll keep an eye on it for a few days to make sure it solved the problem!

Thanks for the fast response!

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

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

Less More

- Posts: 2
- Thank you received: 0
-
-

11 years 3 months ago [\#208668](#208668) by [chrisjclay](/forum/user/38019-chrisjclay "View chrisjclay's Profile")  Replied by *[chrisjclay](/forum/user/38019-chrisjclay "View chrisjclay's Profile")* on topic *[Random Error 1064 after Upgrade](/forum/25-install-update/864302-random-error-1064-after-upgrade#208668 "-- url of the page with the problem -- :   www.showcarcustoms.com/fbs  -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox, Chrome -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  Just upgraded Joomla version and Hikashop. All seemed well until I randomly got this message (below). I've got it on a few different products that were all previously there before the upgrade. One product that I added before the upgrade, but updated after the upgrade, I seem to get it on the most, so I temporarily disabled it. One minute it will work, the next, it won't. Any insight as to where the problem is? I'd like to start selling the product that I'm having the most issues with today, but I won't enable it until I know it is fixed.  Error: 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 ') AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access ' at line 1 SQL=SELECT DISTINCT b.&#42; FROM &#91;strike&#93;XXXX&#91;/strike&#93;&#95;hikashop&#95;product AS b WHERE b.product&#95;published=1 AND b.product&#95;id IN () AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;id ASC LIMIT 0, 3  You may not be able to visit this page because of:  an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request.")*

I just downloaded and installed the latest Business version of Hikashop (with the sample content) on a Joomla 3.4.3 site. When I browse the sample categories and get to a child category here products should appear, like Shoes &gt; Men, or English &gt; Ebooks I see a white page and get this error:

"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 ')' at line 1"

I turned on debug and found this additional info right after the error message:

SELECT category_name FROM z1exu_hikashop_category WHERE category_id IN()

Here's part of the URL, in case it's helpful:

index.php?option=com_hikashop&amp;ctrl=category&amp;task=listing&amp;cid=27&amp;name=english-books&amp;Itemid=460

Any ideas?

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

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

11 years 3 months ago [\#208689](#208689) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Random Error 1064 after Upgrade](/forum/25-install-update/864302-random-error-1064-after-upgrade#208689 "-- url of the page with the problem -- :   www.showcarcustoms.com/fbs  -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox, Chrome -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  Just upgraded Joomla version and Hikashop. All seemed well until I randomly got this message (below). I've got it on a few different products that were all previously there before the upgrade. One product that I added before the upgrade, but updated after the upgrade, I seem to get it on the most, so I temporarily disabled it. One minute it will work, the next, it won't. Any insight as to where the problem is? I'd like to start selling the product that I'm having the most issues with today, but I won't enable it until I know it is fixed.  Error: 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 ') AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access ' at line 1 SQL=SELECT DISTINCT b.&#42; FROM &#91;strike&#93;XXXX&#91;/strike&#93;&#95;hikashop&#95;product AS b WHERE b.product&#95;published=1 AND b.product&#95;id IN () AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;id ASC LIMIT 0, 3  You may not be able to visit this page because of:  an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request.")*

Hello,
It's properly working on my end so can you give me more information like :
- How your category which have the ID number 27 is configured ?
- Does it work if you try it with categories that you have manually created ?

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

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

Less More

- Posts: 1
- Thank you received: 0
-
-

11 years 3 months ago [\#208876](#208876) by [cancam](/forum/user/36344-cancam "View cancam's Profile")  Replied by *[cancam](/forum/user/36344-cancam "View cancam's Profile")* on topic *[Random Error 1064 after Upgrade](/forum/25-install-update/864302-random-error-1064-after-upgrade#208876 "-- url of the page with the problem -- :   www.showcarcustoms.com/fbs  -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : Firefox, Chrome -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  Just upgraded Joomla version and Hikashop. All seemed well until I randomly got this message (below). I've got it on a few different products that were all previously there before the upgrade. One product that I added before the upgrade, but updated after the upgrade, I seem to get it on the most, so I temporarily disabled it. One minute it will work, the next, it won't. Any insight as to where the problem is? I'd like to start selling the product that I'm having the most issues with today, but I won't enable it until I know it is fixed.  Error: 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 ') AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access ' at line 1 SQL=SELECT DISTINCT b.&#42; FROM &#91;strike&#93;XXXX&#91;/strike&#93;&#95;hikashop&#95;product AS b WHERE b.product&#95;published=1 AND b.product&#95;id IN () AND b.product&#95;type = 'main' AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') ORDER BY b.product&#95;id ASC LIMIT 0, 3  You may not be able to visit this page because of:  an out-of-date bookmark/favourite a search engine that has an out-of-date listing for this site a mistyped address you have no access to this page The requested resource was not found. An error has occurred while processing your request.")*

It seems to be working now. All I did was create a test category with a test product and update the menu item to point to the new category. My test category displayed okay... Then I changed it back to the default Hikashop demo category and it worked too. No more error.

Strange... At least it's working now!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NDMwMi1yYW5kb20tZXJyb3ItMTA2NC1hZnRlci11cGdyYWRlP3RtcGw9bWFya2Rvd24=) 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.370 seconds

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

[](#top)
