Project

General

Profile

Actions

Bug #1225

closed

SQL Error When Not Logged In

Added by ckayfish almost 13 years ago. Updated almost 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Target version:
Start date:
19 August 2009
Due date:
% Done:

100%

Estimated time:

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`

Actions #1

Updated by ckayfish almost 13 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.

Actions #2

Updated by krileon almost 13 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.

Actions #3

Updated by ckayfish almost 13 years ago

Fix confirmed. Thanks for quick turn around.

Actions #4

Updated by krileon almost 13 years ago

  • Target version set to 1.8 B5
Actions #5

Updated by krileon almost 13 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF