tags 566252 + pending
thanks
Gregory Colpart wrote:
Package: sympa
Version: 5.3.4-6.1
Severity: normal
Tags: patch fixed-upstream
Hello,
I upgraded from Etch to Lenny, and I discover a bug when searching in
"logs" (on "Admin" section on web interface):
Jan 22 12:40:25 serveur wwsympa[15628]: Log::get_first_db_log() Unable to execute SQL statement
"SELECT date_logs AS date, robot_logs AS robot, list_logs AS list, action_logs AS action,
parameters_logs AS parameters, target_email_logs AS target_email,msg_id_logs AS msg_id, status_logs
AS status, error_type_logs AS error_type, user_email_logs AS user_email, client_logs AS client,
daemon_logs AS daemon FROM logs_table WHERE robot_logs='example.com' AND list_logs = 'testlist'
GROUP BY date_logs " : ERROR: column "logs_table.robot_logs" must appear in the
GROUP BY clause or be used in an aggregate function
It seems like a typo bug in /usr/lib/sympa/bin/Log.pm where
there is "GROUP BY" instead of "ORDER BY"!
Regards,
I verified that the bug is fixed in Sympa 6.
Regards
Racke
--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
