Project

General

Profile

Actions

Bug #5150

closed

CBSubs History log search fails due to join not adding to query

Added by krileon over 10 years ago. Updated over 10 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
Target version:
-
Start date:
27 February 2015
Due date:
% Done:

100%

Estimated time:

Description

When searching the history log it's trying to filter on user_name, but it has no join data associated with it.

Unknown column 'I.user_name' in 'where clause' SQL=SELECT COUNT(*) FROM `jos_cbsubs_history` AS a WHERE ( ( I.`user_name` LIKE '%admin%' ) OR ( I.`user_full_name` LIKE '%admin%' ) OR ( a.`old_value` LIKE '%admin%' ) OR ( a.`new_value` LIKE '%admin%' ) OR ( a.`ip_addresses` LIKE '%admin%' ) )

https://www.joomlapolis.com/forum/277-cbsubs-gpl-support/228546-history-log-error

The table as is working fine, but the join is never added because the filter has no data. It should check for a join by filter name if no data is supplied encase a join does need to be added.

Actions

Also available in: Atom PDF