Actions
Bug #5150
closedCBSubs History log search fails due to join not adding to query
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