View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0007096mantisbtadministrationpublic2006-05-16 10:502006-09-12 00:52
Reportergoldstift Assigned Tovboctor  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
OSSuSE 9.3 
Product Version1.0.3 
Fixed in Version1.1.0a1 
Summary0007096: fields too short in table "mantis_bug_history_table"
Description

When inserting a value of 255 chars into a custom field there is an uncaught database error. See step details below.

The error message in german is:

Datenbankabfrage fehlgeschlagen. Die Reportmeldung lautet #-1: FEHLER: Wert zu lang für Typ character varying(128) für die Abfrage: INSERT INTO mantis_bug_history_table
( user_id, bug_id, date_modified, field_name, old_value, new_value )
VALUES
( '3', '15499', '2006-05-12 16:43:17', 'AnzahlDerMitglieder', '', '999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999998999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999' )

Steps To Reproduce
  1. create a custom field of length 255
  2. insert a value of 255 characters e.g. '999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999998999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999'
  3. submit

Result is an error message

Additional Information

I changed the fields mantis_bug_history_table.old_value and mantis_bug_history_table.new_value to 255 chars

ALTER TABLE mantis_bug_history_table ALTER old_value TYPE varchar(255);
ALTER TABLE mantis_bug_history_table ALTER new_value TYPE varchar(255);

TagsNo tags attached.

Activities

There are no notes attached to this issue.