Hi,

Found an error!

Thanks,

Matthew

An error was found at 08/08/2005 12:09:33 (1123520973) on line '2225' of script 'path/to/eventum/include/class.issue.php'.

The error message passed to us was:

'DB Error: syntax error'

A more detailed error message follows:

'SELECT iss_id, iss_grp_id, iss_prj_id, iss_sta_id, iss_customer_id, iss_created_date, iss_updated_date, iss_last_response_date, iss_closed_date, iss_last_customer_action_date, iss_usr_id, iss_summary, pri_title, prc_title, sta_title, sta_color status_color, sta_id, iqu_status, grp_name `group`, pre_title, iss_last_public_action_date, iss_last_public_action_type, iss_last_internal_action_date, iss_last_internal_action_type, GREATEST(iss_last_public_action_date, iss_last_internal_action_date) AS last_action_date, IF(iss_last_internal_action_date > iss_last_public_action_date, 'internal', 'public') AS action_type, iss_private, usr_full_name, iss_percent_complete, iss_dev_time, iss_expected_resolution_date FROM eventum.eventum_issue, eventum.eventum_user LEFT JOIN eventum.`eventum_group` ON iss_grp_id=grp_id LEFT JOIN eventum.eventum_project_category ON iss_prc_id=prc_id LEFT JOIN eventum.eventum_project_release ON iss_pre_id = pre_id LEFT JOIN eventum.eventum_status ON iss_sta_id=sta_id LEFT JOIN eventum.eventum_project_priority ON iss_pri_id=pri_id LEFT JOIN eventum.eventum_issue_quarantine ON iss_id=iqu_iss_id AND (iqu_expiration > '2005-08-08 17:09:33' OR iqu_expiration IS NULL) WHERE iss_prj_id= 1 AND iss_usr_id = usr_id AND (

) AND sta_is_closed=0 GROUP BY iss_id ORDER BY pri_rank asc, iss_id DESC LIMIT 0, 9999999 [nativecode=1064 ** You have an error in your SQL syntax near ') AND sta_is_closed=0 GROUP BY iss_id ' at line 64]'

Array ( [0] => Array ( [file] => /path/to/eventum/list.php [line] => 107 [function] => getlisting [class] => issue [type] => :: [args] => Array ( [0] => 1 [1] => Array ( [rows] => ALL [pagerRow] => 0 [hide_closed] => 1 [sort_by] => pri_rank [sort_order] => asc [keywords] => ewa [search_type] => customer [users] => [status] => [priority] => [category] => [customer_email] => [show_authorized_issues] => [show_notification_list_issues] => [reporter] => [release] => [custom_field] => [created_date] => Array ( [past_hour] => [Year] => [Month] => [Day] => [start] => -- [filter_type] => [end] => -- )

[created_date_end] => Array ( [Year] => [Month] => [Day] => )

[updated_date] => Array ( [past_hour] => [Year] => [Month] => [Day] => [start] => -- [filter_type] => [end] => -- )

[updated_date_end] => Array ( [Year] => [Month] => [Day] => )

[last_response_date] => Array ( [past_hour] => [Year] => [Month] => [Day] => [start] => -- [filter_type] => [end] => -- )

[last_response_date_end] => Array ( [Year] => [Month] => [Day] => )

[first_response_date] => Array ( [past_hour] => [Year] => [Month] => [Day] => [start] => -- [filter_type] => [end] => -- )

[first_response_date_end] => Array ( [Year] => [Month] => [Day] => )

[closed_date] => Array ( [past_hour] => [Year] => [Month] => [Day] => [start] => -- [filter_type] => [end] => -- )

[closed_date_end] => Array ( [Year] => [Month] => [Day] => )

)

[2] => 0 [3] => ALL )

)

)