[Wed Sep 14 11:01:27 2005] An error was found on line '67' of script 'C:\Inetpub\wwwroot\eventum\include\class.pager.php'.

The error message passed to us was:

'DB Error: no such field'

A more detailed error message follows:

'SELECT COUNT(iss_id) AS total_rows FROM                    eventum.tbl_issue,                    eventum.tbl_user                 LEFT JOIN                    eventum.`tbl_group`                 ON                    iss_grp_id=grp_id                 LEFT JOIN                    eventum.tbl_project_category                 ON                    iss_prc_id=prc_id                 LEFT JOIN                    eventum.tbl_project_release                 ON                    iss_pre_id = pre_id                 LEFT JOIN                    eventum.tbl_status                 ON                    iss_sta_id=sta_id                 LEFT JOIN                    eventum.tbl_project_priority                 ON                    iss_pri_id=pri_id                 LEFT JOIN                    eventum.tbl_issue_quarantine                 ON                    iss_id=iqu_iss_id AND                    (iqu_expiration > '2005-09-14 05:31:27' OR iqu_expiration IS NULL)                 WHERE                    iss_prj_id= 1 AND iss_usr_id = usr_id AND sta_is_closed=0                 GROUP BY                    iss_id                  [nativecode=1054 ** Unknown column 'iss_grp_id' in 'on clause']'



A backtrace is available:

Array
(
    [0] => Array
        (
            [file] => C:\Inetpub\wwwroot\eventum\include\class.issue.php
            [line] => 2276
            [function] => gettotalrows
            [class] => pager
            [type] => ::
            [args] => Array
                (
                    [0] => 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.tbl_issue,
                    eventum.tbl_user
                 LEFT JOIN
                    eventum.`tbl_group`
                 ON
                    iss_grp_id=grp_id
                 LEFT JOIN
                    eventum.tbl_project_category
                 ON
                    iss_prc_id=prc_id
                 LEFT JOIN
                    eventum.tbl_project_release
                 ON
                    iss_pre_id = pre_id
                 LEFT JOIN
                    eventum.tbl_status
                 ON
                    iss_sta_id=sta_id
                 LEFT JOIN
                    eventum.tbl_project_priority
                 ON
                    iss_pri_id=pri_id
                 LEFT JOIN
                    eventum.tbl_issue_quarantine
                 ON
                    iss_id=iqu_iss_id AND
                    (iqu_expiration > '2005-09-14 05:31:27' OR iqu_expiration IS NULL)
                 WHERE
                    iss_prj_id= 1 AND iss_usr_id = usr_id AND sta_is_closed=0
                 GROUP BY
                    iss_id
                 ORDER BY
                    pri_rank ASC,
                    iss_id DESC
                )

        )

    [1] => Array
        (
            [file] => c:\inetpub\wwwroot\eventum\list.php
            [line] => 107
            [function] => getlisting
            [class] => issue
            [type] => ::
            [args] => Array
                (
                    [0] => 1
                    [1] => Array
                        (
                            [rows] => 5
                            [pagerRow] => 
                            [hide_closed] => 1
                            [sort_by] => pri_rank
                            [sort_order] => ASC
                            [keywords] => 
                            [search_type] => all_text
                            [users] => 
                            [status] => 
                            [priority] => 
                            [category] => 
                            [customer_email] => 
                            [show_authorized_issues] => 
                            [show_notification_list_issues] => 
                            [reporter] => 
                            [release] => 
                            [custom_field] => 
                        )

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

        )

)
[Wed Sep 14 11:01:27 2005] An error was found on line '2282' of script 'C:\Inetpub\wwwroot\eventum\include\class.issue.php'.

The error message passed to us was:

'DB Error: no such field'

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.tbl_issue,
                    eventum.tbl_user
                 LEFT JOIN
                    eventum.`tbl_group`
                 ON
                    iss_grp_id=grp_id
                 LEFT JOIN
                    eventum.tbl_project_category
                 ON
                    iss_prc_id=prc_id
                 LEFT JOIN
                    eventum.tbl_project_release
                 ON
                    iss_pre_id = pre_id
                 LEFT JOIN
                    eventum.tbl_status
                 ON
                    iss_sta_id=sta_id
                 LEFT JOIN
                    eventum.tbl_project_priority
                 ON
                    iss_pri_id=pri_id
                 LEFT JOIN
                    eventum.tbl_issue_quarantine
                 ON
                    iss_id=iqu_iss_id AND
                    (iqu_expiration > '2005-09-14 05:31:27' OR iqu_expiration IS NULL)
                 WHERE
                    iss_prj_id= 1 AND iss_usr_id = usr_id AND sta_is_closed=0
                 GROUP BY
                    iss_id
                 ORDER BY
                    pri_rank ASC,
                    iss_id DESC
                 LIMIT
                    0, 5 [nativecode=1054 ** Unknown column 'iss_grp_id' in 'on clause']'



A backtrace is available:

Array
(
    [0] => Array
        (
            [file] => c:\inetpub\wwwroot\eventum\list.php
            [line] => 107
            [function] => getlisting
            [class] => issue
            [type] => ::
            [args] => Array
                (
                    [0] => 1
                    [1] => Array
                        (
                            [rows] => 5
                            [pagerRow] => 
                            [hide_closed] => 1
                            [sort_by] => pri_rank
                            [sort_order] => ASC
                            [keywords] => 
                            [search_type] => all_text
                            [users] => 
                            [status] => 
                            [priority] => 
                            [category] => 
                            [customer_email] => 
                            [show_authorized_issues] => 
                            [show_notification_list_issues] => 
                            [reporter] => 
                            [release] => 
                            [custom_field] => 
                        )

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

        )

)