#2297 Problem in Moregroupware found!
This is submitted by:
larriefunk@comcast.net
Phone: 847-917-2131
I was on the site [http://class.elgin62.com/modules/news/index.php?id=20&action=details&], clicked on "forum" and got the following message as displayed below.
Thank you,
Larrie R. Funk
P.S. The below URL was displayed at the top of the message page.
[http://class.elgin62.com/modules/forum/index.php?]
Problem in Moregroupware found!
Version (config.inc.php): 0.6.8 - Nick
Version (version.inc): 0.6.8 - Nick
PHP version: 5.1.2
register_globals: 0
safe_mode: 0
Server software: Apache/2.2.0 (Linux/SUSE)
Database: 5.0.18-log (5.0.18)
Program: /modules/forum/index.php
File: /srv/www/elgin62/modules/forum/inc/forum.class.inc
Line: 152
Error (SQL):
SELECT SUM( CASE WHEN b.reply_id=0 THEN 1 ELSE 0 END) AS n_frm_num_threads, SUM( CASE WHEN b.thread_id IS NULL THEN 0 ELSE 1 END) AS n_frm_num_posts, CASE WHEN (SUM( CASE WHEN b.thread_id IS NULL THEN 0 ELSE 1 END) > SUM( CASE WHEN ''2009-02-27 23:45:14'' > b.thread_date THEN 1 ELSE 0 END)) THEN 'NEW_MESSAGES' ELSE 'NO_NEW_MESSAGES' END AS n_frm_new_posts, CASE WHEN (SUM( CASE WHEN b.thread_id IS NULL THEN 0 ELSE 1 END) > SUM( CASE WHEN ''2009-02-27 23:45:14'' > b.thread_date THEN 1 ELSE 0 END)) THEN 'grp_newMsg_0.gif' ELSE 'grp_noNewMsg_0.gif' END AS n_frm_new_posts_image, MAX(b.thread_date) AS last_thread_date, a.frm_id AS n_frm_id, a.frm_name AS n_frm_name, a.frm_info AS n_frm_info, a.frm_rightsLevel AS n_frm_rightslevel FROM mgw_forum_forums a LEFT JOIN mgw_forum_threads b ON a.frm_id=b.frm_id WHERE a.grp_id='0' GROUP BY a.frm_id, a.frm_name, a.frm_info, a.frm_rightsLevel
Error (MSG):
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2009-02-27 23:45:14'' > b.thread_date THEN 1 ELSE 0 END)) THEN 'NEW_MESSAGES' EL' at line 4
Dump:
POST:
Array
(
)
GET:
Array
(
)
Please report this error to our Bugtracker on sourceforge.net. Make sure to include the complete output on this screen into the bug report, along with a description of the steps that led to the error. Thanks for using moregroupware!