FrontAccounting forum — Fixed Asset Category cannot be added

Re: Fixed Asset Category cannot be added

null@example.com (apmuthu) — Tue, 24 Nov 2020 10:14:36 +0000

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,

Re: Fixed Asset Category cannot be added

null@example.com (cedricktshiyoyo) — Mon, 23 Nov 2020 08:48:40 +0000

@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

null@example.com (kvvaradha) — Mon, 23 Nov 2020 05:35:08 +0000

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.

Fixed Asset Category cannot be added

null@example.com (cedricktshiyoyo) — Sun, 22 Nov 2020 10:57:20 +0000

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