List:Eventum General Discussion« Previous MessageNext Message »
From:Todd.Morgan Date:February 29 2004 11:56am
Subject:Unable to create an issue on a fresh system from eventum-nightly-20040213.tar.gz
View as plain text  




Hi everyone,
I have a freshly installed version of eventum (eventum-nightly-20040213) on
the following system

Apache (1.3.29 - win) C:\Apache
PHP 4.3.4 win
MySQL 4.0.17 win
on a win2k Server box

I have managed to create the system properly, create projects, users, email
integration - all working properly.

When I tried to submit my first test issue I got the email messages
attached below.

I used MySQLCC to check the database and there is a "eventum_issue" table
and all the fields iss_* are appropriately filled out as per my issue.

The error_handler.log had the following entries contained within it

[Fri Feb 27 16:30:55 2004] Found error 'DB Error: no such table' on line
'1924' of script 'c:\apache\htdocs\eventum\include\class.issue.php' on page
'/eventum/new.php'.
[Fri Feb 27 16:30:55 2004] Found error 'DB Error: syntax error' on line
'338' of script 'c:\apache\htdocs\eventum\include\class.custom_field.php'
on page '/eventum/new.php'.
[Fri Feb 27 16:31:01 2004] Found error 'DB Error: no such table' on line
'1924' of script 'c:\apache\htdocs\eventum\include\class.issue.php' on page
'/eventum/view.php'.
[Fri Feb 27 16:31:02 2004] Found error 'DB Error: no such table' on line
'73' of script 'c:\apache\htdocs\eventum\include\class.phone_support.php'
on page '/eventum/view.php'.


If anyone has any thoughts on how to fix this I would appreciate some help.

thanks
Todd


Todd Morgan
Consultant
eGlobalSecurix
eSecurity ● eBusiness ● eGlobal
Level 1, 173 Burke Road
Glen Iris, VIC 3146, Australia
Phone(Switch): +61 (0)3 9500 2990  Phone(direct): +61 (0)3 9508 9243  Fax:
+61 (0)3 9500 2770  Mobile: +61 (0)422 754 517
Brisbane • Sydney • Canberra • Melbourne • Hong Kong • Beijing • Shenyang •
Shenzhen • Atlanta
www.eglobalsecurix.com        www.citadel.com.au

----- Forwarded by Todd Morgan/MEL/eGlobal on 27/02/2004 04:32 PM -----

ERROR_HANDLER_EMAIL
27/02/2004 04:30 PM

To
todd_morgan@stripped


cc



Subject
Eventum - Error found! - 02/27/2004 16:30:55



Hello,

An error was found at 02/27/2004 16:30:55 (1077859855) on line '1924' of
script 'c:\apache\htdocs\eventum\include\class.issue.php'.

The error message passed to us was:

'DB Error: no such table'

A more detailed error message follows:

'SELECT
                   eventumDB.eventum_issue.*,
                   prc_title,
                   pre_title,
                   pri_title,
                   sta_title,
                   sta_is_closed
                FROM
                   eventumDB.eventum_issue
                LEFT JOIN
                   eventumDB.eventum_priority
                ON
                   iss_pri_id=pri_id
                LEFT JOIN
                   eventumDB.eventum_status
                ON
                   iss_sta_id=sta_id
                LEFT JOIN
                   eventumDB.eventum_project_category
                ON
                   iss_prc_id=prc_id
                LEFT JOIN
                   eventumDB.eventum_project_release
                ON
                   iss_pre_id=pre_id
                WHERE
                   iss_id=3 [nativecode=1051 ** Unknown table
                   'eventum_issue']'

That happened on page '/eventum/new.php' from IP Address '192.168.1.211'
coming from the page (referrer)
'http://mel-serv-04.eglobal.net.au/eventum/new.php'.

Sincerely yours,
Automated Error_Handler Class


Hello,

An error was found at 02/27/2004 16:30:55 (1077859855) on line '338' of
script 'c:\apache\htdocs\eventum\include\class.custom_field.php'.

The error message passed to us was:

'DB Error: syntax error'

A more detailed error message follows:

'SELECT
                   fld_id,
                   fld_title,
                   fld_type,
                   fld_report_form_required,
                   fld_anonymous_form_required,
                   icf_value
                FROM
                   eventumDB.eventum_custom_field,
                   eventumDB.eventum_project_custom_field
                LEFT JOIN
                   eventumDB.eventum_issue_custom_field
                ON
                   pcf_fld_id=icf_fld_id AND
                   icf_iss_id=3
                WHERE
                   pcf_fld_id=fld_id AND
                   pcf_prj_id= [nativecode=1064 ** 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 '' at line 18]'

That happened on page '/eventum/new.php' from IP Address '192.168.1.211'
coming from the page (referrer)
'http://mel-serv-04.eglobal.net.au/eventum/new.php'.

Sincerely yours,
Automated Error_Handler Class

Hello,

An error was found at 02/27/2004 16:31:01 (1077859861) on line '1924' of
script 'c:\apache\htdocs\eventum\include\class.issue.php'.

The error message passed to us was:

'DB Error: no such table'

A more detailed error message follows:

'SELECT
                   eventumDB.eventum_issue.*,
                   prc_title,
                   pre_title,
                   pri_title,
                   sta_title,
                   sta_is_closed
                FROM
                   eventumDB.eventum_issue
                LEFT JOIN
                   eventumDB.eventum_priority
                ON
                   iss_pri_id=pri_id
                LEFT JOIN
                   eventumDB.eventum_status
                ON
                   iss_sta_id=sta_id
                LEFT JOIN
                   eventumDB.eventum_project_category
                ON
                   iss_prc_id=prc_id
                LEFT JOIN
                   eventumDB.eventum_project_release
                ON
                   iss_pre_id=pre_id
                WHERE
                   iss_id=3 [nativecode=1051 ** Unknown table
                   'eventum_issue']'

That happened on page '/eventum/view.php' from IP Address '192.168.1.211'
coming from the page (referrer) ''.

Sincerely yours,
Automated Error_Handler Class

Hello,

An error was found at 02/27/2004 16:31:02 (1077859862) on line '73' of
script 'c:\apache\htdocs\eventum\include\class.phone_support.php'.

The error message passed to us was:

'DB Error: no such table'

A more detailed error message follows:

'SELECT
                   eventumDB.eventum_phone_support.*,
                   usr_full_name
                FROM
                   eventumDB.eventum_phone_support,
                   eventumDB.eventum_user
                WHERE
                   phs_usr_id=usr_id AND
                   phs_iss_id=3
                ORDER BY
                   phs_created_date ASC [nativecode=1051 ** Unknown table
                   'eventum_phone_support']'

That happened on page '/eventum/view.php' from IP Address '192.168.1.211'
coming from the page (referrer) ''.

 Sincerely yours,
Automated Error_Handler Class
Thread
Unable to create an issue on a fresh system from eventum-nightly-20040213.tar.gzTodd.Morgan29 Feb
  • RE: Unable to create an issue on a fresh system from eventum-nightly-20040213.tar.gzJoao Prado Maia1 Mar
    • RE: Unable to create an issue on a fresh system from eventum-nightly-20040213.tar.gzJoao Prado Maia1 Mar
RE: Unable to create an issue on a fresh system fromeventum-nightly-20040213.tar.gzTodd.Morgan3 Mar
  • RE: Unable to create an issue on a fresh system from eventum-nightly-20040213.tar.gzJoao Prado Maia3 Mar