MySQL Bugs: #27824: 'DB Error: unknown error'

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:	None
Category:	Eventum	Severity:	S3 (Non-critical)
Version:	2.0 beta 1	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	eventum db error

Description:
A more detailed error message follows:

'INSERT INTO
                    eventum.eventum_customer_account_manager
                 (
                    cam_prj_id,
                    cam_customer_id,
                    cam_usr_id,
                    cam_type
                 ) VALUES (
                    -1,
                    0,
                    0,
                    'primary'
                 ) [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 '0.0.0.0' coming from the page (referrer) 'http://10.200.64.234:90/eventum/manage/account_managers.php';.

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.

Thank you for a problem report. Please, try to repeat with a newer version, 2.1, and inform about the results.

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".