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

[14 Apr 2007 17:11] Schalk Neethling
A more detailed error message follows:

                 ) VALUES (
                 ) [nativecode=1264 ** Out of range value adjusted for column 'cam_prj_id' at row 1]'

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

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:
I am not sure what exactly triggers this but it seems a certain form field allows a user to enter more data then what the field in the database can hold and thus it errors.

Suggested fix:
Implement JavaScript to validate the forms and ensure the amount of characters are not more then what the database field will accept.
[22 Nov 2007 18:05] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat 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".