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
