• From: UK
  • Registered: 10/02/2012
  • Posts: 146

Topic: Error/Bug on Standard Material Cost Per Unit of an item

Hi

I'm getting this error when I insert Standard Material Cost Per Unit of an item.

DATABASE ERROR : Cannot add audit info
error code : 1264
error message : Out of range value for column 'trans_no' at row 1
sql that failed was : INSERT INTO audit_trail (type, trans_no, user, fiscal_year, gl_date, description, gl_seq) VALUES('35', '-1',1,3,'2013-02-01','', 0)

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Error/Bug on Standard Material Cost Per Unit of an item

Hi,

This is a bug. This would normally happen when there are no stock on hand for the item.

Fixed and HG repository updated.

You can download items_trans_db.inc, and replace existing /inventory/includes/db/items_trans_db.inc

/Joe

Post's attachments

items_trans_db.inc 2.8 kb, 3 downloads since 2013-02-01 

You don't have the permssions to download the attachments of this post.