Category not found error after upgrade to Hikashop Business v4.2.1

-- HikaShop version -- : 4.2.1
-- Joomla version -- : 3.9.12
-- PHP version -- : 7.2.21
-- Browser(s) name and version -- : Version 77.0.3865.90 (Official Build) (64-bit)
-- Error-message(debug-mod must be tuned on) -- : Category not found
/mnt/data/vhosts/casite-620018.cloudaccess.net/httpdocs/components/com_hikashop/views/category/view.html.php:187

Hi all, as soon as I upgrade to 4.2.1 (from 4.0.3), you can no longer login to the front end of the site without receiving a 404 Category not found error.

I use Community Builder v2.4.2 for the login functions, and my Joomla version is 3.9.12.


The basics of how it *should* work are:

1. Client logs in with CB login module on home page

2. They are immediately redirected on login to their main category page using the 'Redirect on Login' plugin. I removed this plugin entirely in my testing and I still got the error.


I can confirm that it is the Hikashop update that triggers the issue, as I am testing the update on my staging server. I have updated everything except Hika and everything works as it should, but the instant I update Hika the problem occurs.

I thought it might be some kind of canonical url issue, but no amount of wrangling with the settings, including removing them entirely affects the problem. I've even turned off Joomla SEF completely with no effect.

A couple of odd things:

• You can't login using the CB Login module on the home page, but you CAN login using the CB Login default page.

• once you get the error, clicking the Home Page link to the index.php page generates another error, but if I put in one of the urls by hand it loads fine.

• I'm getting these issues in Chrome and Safari, but in Firefox sometimes instead of the 404, it just kicks you over to the CB Login page.

My fault, I'll provide the necessary details.

Hi Nicolas, thanks for checking on this one.

Were you trying in Firefox? As I wrote Firefox seemed to kick you back to the login page, while Chrome/Safari kicked up the 404 category not found error. The whole thing is odd.

As for the Redirect on Login plugin, as I wrote before I disabled, then removed that plugin entirely and the error still occurs. Without the plugin (and without the 4.2.1 update), when you login instead of redirecting you just stay on that home page. As soon as 4.2.1 is applied then you get the error.

I did turn on the error reporting and debug settings, and I pasted the result into the first post which was:

-- Error-message(debug-mod must be tuned on) -- : Category not found
/mnt/data/vhosts/casite-620018.cloudaccess.net/httpdocs/components/com_hikashop/views/category/view.html.php:187

I looked in that file around that line number and found this block of code:

$acl_filters[] = 'category_type=\''.$content_type.'\'';
				$acl_filters[] = 'category_id IN ('.implode(',',$pageInfo->filter->cid).')';
				$query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE '.implode(' AND ',$acl_filters);
				$database->setQuery($query);
				$pageInfo->filter->cid = $database->loadColumn();
				if(!count($pageInfo->filter->cid)) {
					throw new Exception(JText::_('CATEGORY_NOT_FOUND'), 404);
				}
			}
		}

Alright, so my home page menu item is a basic Joomla category that is set to 'Public' access.

However the homepage has many, many modules set to display. Some are Joomla menu items and some are Hikashop category listings, but each is set to the access level of it's respective client.

So there would be over 200 menus and category listing on that page, and each client on login would only see 1 top menu, and 1 Hika Category listing on that home page.

Could this be the problem?

Yes, that did it! Thanks!

Now, is this something I can manage in an override? Or must I always apply this change each time I update?

I went to Display > Views and chose Category view for the front end of my template, but I can't seem to find this code in any of them.