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')

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.

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.

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,