Bug #27825 'DB Error: unknown error' on class.issue.php
Submitted: 14 Apr 2007 17:15 Modified: 22 Dec 2007 18:54
Reporter: Schalk Neethling Email Updates:
Status: No Feedback Impact on me:
None 
Category:Eventum Severity:S3 (Non-critical)
Version:2.0 beta 1 OS:Any
Assigned to: CPU Architecture:Any
Tags: db error

[14 Apr 2007 17:15] Schalk Neethling
Description:
Hello,

An error was found at 04/12/2007 12:39:59 (1176370799) on line '4045' of script 'C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\eventum\include\class.issue.php'.

The error message passed to us was:

'DB Error: unknown error'

A more detailed error message follows:

'UPDATE
                    eventum.eventum_issue
                 SET
                    iss_closed_date = null,
                    iss_res_id = null
                 WHERE
                    iss_id=86 [nativecode=1263 ** Column was set to data type implicit default; NULL supplied for NOT NULL column 'iss_res_id' at row 1]'

That happened on page '/eventum/post_note.php' from IP Address '0.0.0.0' coming from the page (referrer) 'http://10.200.64.234:90/eventum/post_note.php?issue_id=86'.

The user agent given was 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)'.

How to repeat:
Not sure how this event is triggered.

Suggested fix:
Provide more useful feedback to user when this error occurs. As far as I know these errors happen silently in the background and the user is not notified.

These errors are only sent out via email.
[22 Nov 2007 18:54] Valeriy Kravchuk
Thank you for a problem report. Please, check with a newer version, 2.1, and inform about the results.
[23 Dec 2007 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".