#609 vendor invoice # can be too long

closed-fixed
nobody
None
5
2012-04-24
2012-04-09
No

If the vendor invoice# is too long, then one gets:
UPDATE invoice
SET trans_id = ?,
parts_id = ?,
description = ?,
qty = ?,
sellprice = ?,
fxsellprice = ?,
discount = ?,
allocated = ?,
unit = ?,
deliverydate = ?,
project_id = ?,
serialnumber = ?,
precision = ?,
notes = ?
WHERE id = ?
ERROR: value too long for type character varying(5)

(my guess it's the vendor invoice, which was: 2309201000460)

Discussion

  • Chris Travers
    Chris Travers
    2012-04-24

    This table doesn't hold the invoice number. The error is due to the unit measurement being too long. For 1.4 we should probably change to unrestricted varchar?

     
  • Chris Travers
    Chris Travers
    2012-04-24

    • status: open --> closed-fixed
     
  • Chris Travers
    Chris Travers
    2012-04-24

    The actual full fix for this has been added to trunk (for 1.4), with documentation about the error to the release notes in 1.3.

    svn 4674 for trunk
    svn 4675 for docs in 1.3