• From: Addis Ababa, Ethiopia
  • Registered: 11/28/2019
  • Posts: 109

Topic: Fixed Asset Category cannot be added

DATABASE ERROR : an item category could not be added
error code : 1364
error message : Field 'category_id' doesn't have a default value
sql that failed was : INSERT INTO stock_category (description, dflt_tax_type, dflt_units, dflt_mb_flag, dflt_sales_act, dflt_cogs_act, dflt_inventory_act, dflt_adjustment_act, dflt_wip_act, dflt_dim1, dflt_dim2, dflt_no_sale, dflt_no_purchase) VALUES ('ii','1','each','F','4010','5010','1510','5040','1530','0','0','0','0')

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,181

Re: Fixed Asset Category cannot be added

The category_id is a primary key and auto increment. Guess it's does not in ur server. Just try to make to it. It will work.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Addis Ababa, Ethiopia
  • Registered: 11/28/2019
  • Posts: 109

Re: Fixed Asset Category cannot be added

@kvvaradha millions thanks.

When I checked my database even though I didn't make any changes to the database I downloaded from the Official Repo,
In the table stock_category , category_id was not set to auto-increment.
I have just amended that, now I can create fixed asset category.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Fixed Asset Category cannot be added

Which sql Chart of Accounts did you take?
Refer line 1325 in https://github.com/FrontAccountingERP/FA/blob/master/sql/en_US-new.sql :

 `category_id` int(11) NOT NULL AUTO_INCREMENT,

apmuthu's Website