You have bookmarked items
Jump To:
Viewing Topic "Select on Business Category will return SQL error (v4.94)"

4 Item(s)     Sort:  Newest Oldest

per page
 
  Post
Posted By: Robert Bal
Total Posts: 3
Joined Date: Jul 31, 2018

When filtering on category in Business listing (Backend) will return the following message:

 

Error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cg.id' in 'where clause' SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cg.id' in 'where clause'



Posted : Jul 31, 2018
Posted By: George Bara
Total Posts: 1303
Joined Date: Jun 17, 2013

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.

Posted : Aug 2, 2018
Posted By: Robert Bal
Total Posts: 3
Joined Date: Jul 31, 2018

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



Posted : Aug 7, 2018
Posted By: Geoff Grantham
Total Posts: 1
Joined Date: Aug 15, 2018

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.

Posted : Aug 15, 2018

4 Item(s)     Sort:  Newest Oldest

per page
 

Viewing Topic "Select on Business Category will return SQL error (v4.94)"


      You have bookmarked items
Jump To:

Who is online

 
Users browsing this topic 1 logged customers:: 0 and guest 1 (based on users active over the past 5 minutes)