Bugs item #2647904, was opened at 2009-02-28 06:41
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=404018&aid=2647904&group_id=32034
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Problem in Moregroupware found!
Initial Comment:
This is submitted by:
larriefunk@...
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!
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=404018&aid=2647904&group_id=32034
|