J-BusinessDirectory - Select on Business Category will return SQL error (v4.94)
Support Forum
R.B.
Select on Business Category will return SQL error (v4.94)
When filtering on category in Business listing (Backend) will return the following message:
Error
3 replies
G.B.
posted: 7 years ago
- total posts 2299
- joined 12 years ago
Hi,
It seems that something went wrong with the update or you have an out of date template override.
Please create a ticket on our store and provide us joomla admin access.
R.B.
posted: 7 years ago
- total posts 205
- joined 7 years ago
Seems that the update from 4.9.3 to 4.9.4 is creating the issue. With 4.9.3 no issues, after updating to 4.9.4 the error message is popping-up. Only fter logout / login able to access business lisitngs again
G.G.
posted: 7 years ago
- total posts 2
- joined 7 years ago
The following works for me ...
FIX FOR THIS problem
In the file .... / administrator / components / com_jbusinessdirectory / models / companies.php
LINE 175 $where.=" and cg.id in ($categoriesIds)"; <<<<<<< INCORRECT
LINE 175 $where.=" and cc.categoryId in ($categoriesIds)"; <<<<<<< CORRECT
Hope this helps you.