Project

General

Profile

Bug #4772

RSS feed not working for non-admins

Added by Parcifal Aertssen over 7 years ago. Updated over 7 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
-
Start date:
18/05/2012
Due date:
% Done:

0%

Estimated time:
Complexity:
Normal

Description

in the home block "course menu" (cursusmenu), click on the RSS icon as a non-admin, you will see a blank page. On DEV you will get a SQL syntax error:

[Native message: Unknown column 'alias_waw.user_id' in 'where clause'] [Native code: 1054] [Last executed query: SELECT alias_wcop.*, alias_rco.title,alias_rco.description,alias_rco.type, alias_rco.owner_id FROM `weblcms_content_object_publication` AS alias_wcop JOIN `repository_content_object` AS alias_rco ON `alias_rco`.`id`=`alias_wcop`.`content_object_id` WHERE (`alias_waw`.`user_id` IN (24) OR (`alias_waw`.`user_id` IS NULL AND `alias_waw_a`.`course_group_id` IS NULL)) ORDER BY `alias_wcop`.`published` DESC LIMIT 0, 20] [06/04/2012 - 23:15:39] [Message: MDB2 Error: no such field] [Information: _doQuery: [Error message: Could not execute statement]

As a non-admin, you filter on an alias in the WHERE clause, while as a platform admin, you don't filter in the WHERE clause, so you don't get an exception.

History

#1

Updated by Anthony Hurst over 7 years ago

  • Target version set to Backlog (default)
#2

Updated by Anthony Hurst over 7 years ago

  • Status changed from New to Bug resolved
  • Target version changed from Backlog (default) to LCMS 3

Also available in: Atom PDF