Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#161 notes and address description fields are small

closed
Steffen Macke
None
5
2006-11-09
2006-10-15
sammer
No

Hello,

The GEDWSA is complaining because the notes and address
description fields in wrokorder table can only fit to
128 character which is not enough for them.

They want those fields to be larger.

Discussion

  • Steffen Macke
    Steffen Macke
    2006-11-05

    • assigned_to: nobody --> sdteffen
     
  • Steffen Macke
    Steffen Macke
    2006-11-05

    Logged In: YES
    user_id=30248

    This is rather a feature request.

    A fix for this has been committed to the MS4W branch.
    What needs to be done is the following:

    * Drop the Views

    * Execute the following SQL statements:

    alter table Workorder alter Note type varchar(256);
    alter table Workorder alter LocationDescription type
    varchar(256);

    * Create the views

    * Adjust include/dataobject/Workorder.php: Change the
    constraints from 128 to 255 for the Note
    and LocationDescription fields.

     
  • sammer
    sammer
    2006-11-09

    • status: open --> closed
     
  • sammer
    sammer
    2006-11-09

    Logged In: YES
    user_id=1251979

    Hello,

    The problem was fixed as you have mentioned, and I have
    adjust the file
    include/dataobject/translation.php to change from 128 to 256.

    And GEDWSA have asked to make the same change to note field
    in maintenance table, so I did it to.

    Regards
    Sammer