Project

General

Profile

Bug #18323

Bad SQL log users query

Added by Kyle Hazelwood about 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Low
Assignee:
Kyle Hazelwood
Category:
Server
Target version:
Version 2.0
Start date:
11/16/2017
Due date:
% Done:

0%

Estimated time:
Duration:

Description

Apparently there is a bad SQL query in the searchLogsUsers() method that complains. It complains of a missing FROM clause for table logs_categories which should not even be looked at in this method.

1510862166467_elog_tomcat_log_report.txt (22.1 KB) 1510862166467_elog_tomcat_log_report.txt Kyle Hazelwood, 11/16/2017 04:01 PM

History

#1 Updated by Kyle Hazelwood about 2 years ago

  • Status changed from Assigned to Resolved

Found the problem, the query was doing a join on the logs_categories table when it should have been looking at the logs_users table. Fixed on next elog restart.

#2 Updated by Kyle Hazelwood about 2 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF