Bug #1225
closed
SQL Error When Not Logged In
100%
Description
After installing and configuring Beta4 I get the following error when accessing the GJ front page if not logged it. When logged in, there is no error. I dont see where a table is being aliased with 'x'.
DB function failed with error number 1054
Unknown column 'x.id_user' in 'where clause' SQL=SELECT b.*, COUNT AS CAT_ISONLINE FROM `jos_gj_groups` AS a INNER JOIN `jos_gj_grcategory` AS b ON a.`category` = b.`id` INNER JOIN `jos_gj_users` AS c ON a.`id` = c.`id_group` INNER JOIN `jos_users` AS u ON c.`id_user` = u.`id` WHERE a.`active` = '1' AND b.`published` = '1' AND b.`access` <= 0 AND c.`status` = 'active' AND ( ( a.`type` IN ( '1', '2' ) ) OR ( a.`type` IN ( '3' )AND x.`id_user` = 0 ) ) GROUP BY b.`id`, b.`catname`, b.`cat_image`, b.`type` ORDER BY b.`ordering`
Updated by ckayfish over 15 years ago
Update: This happens to registered & not-logged in users. Not Super Administrators. More importantly, this only occurs when the Front End option "Do you want invite-only groups to be hidden from non-members on the group listing pages?" is set to yes. All users see the GJ front page as expected if this is set to No.
Updated by krileon over 15 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Resolved in B5
Quickfix!
In: components/com_groupjive/gj/core/categories.php
On: 42 & 132
From: AND x.
To: AND c.
Updated by ckayfish over 15 years ago
Fix confirmed. Thanks for quick turn around.