Can't add new category > missing column in database?

[Manisch]

Hi there,

I noticed that I can't add new categories on a shop and guess it's probably a migration-error (Database).

After turning on the developer mode it says: ``` Unknown column 'displayfromsub' in 'field list'

INSERT INTO ps_category (nleft, nright, level_depth, active, display_from_sub, id_parent, id_shop_default, is_root_category, position, date_add, date_upd) VALUES ('0', '0', '3', '1', '1', '3', '1', '0', '0', '2018-06-23 11:51:48', '2018-06-23 11:51:48')```

``` Can somebody tell me which SQL command could fix this? :slightlysmilingface:

I found something like this for a similar problem concerning products: ``` ALTER TABLE ps_product ADD pack_stock_type int(11) UNSIGNED DEFAULT '3'; ALTER TABLE ps_product_shop ADD pack_stock_type int(11) UNSIGNED DEFAULT '3'; ALTER TABLE ps_pack ADD id_product_attribute_item int(10) UNSIGNED NOT NULL AFTER id_product_item; ALTER TABLE ps_pack DROP PRIMARY KEY;

[yaniv14]

You can try: ALTER TABLE `ps_category` ADD COLUMN `display_from_sub` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `active`;

[yaniv14]

After fresh installation, did you deleted the root & home categories?

[Traumflug]

You're manipulating the database directly? Uh-oh :-/

It'd be better to create categories using web requests mimicking a manual creation. Or to write some PHP code calling the appropriate methods. Which code to write? See AdminCategoriesController.php

[Manisch]

@yaniv14 said in Can't add new category > missing column in database?:

ALTER TABLE ps_category ADD COLUMN display_from_sub tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER active;

Thanks, this seems to work :slightlysmilingface:

[halogen1]

hi .. this unfortunately does not help when import csv .. when importing csv, an error is always reported.. the first import on clean installation will be fine.. the second import is already faulty..

[danwarrior]

On 6/27/2018 at 8:06 AM, Manisch said:

@yaniv14 said in Can't add new category > missing column in database?:

ALTER TABLE ps_category ADD COLUMN display_from_sub tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER active;

Thanks, this seems to work :slightlysmilingface:

This saved me, thanks so much!