Welcome, Guest!
By registering with us, you'll be able to discuss, share and private message with other members of our community.
- 0

Can't add new category > missing column in database?
Asked by
Manisch
By registering with us, you'll be able to discuss, share and private message with other members of our community.
Asked by
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
ADDpack_stock_type
int(11) UNSIGNED DEFAULT '3'; ALTER TABLEps_product_shop
ADDpack_stock_type
int(11) UNSIGNED DEFAULT '3'; ALTER TABLEps_pack
ADDid_product_attribute_item
int(10) UNSIGNED NOT NULL AFTERid_product_item
; ALTER TABLEps_pack
DROP PRIMARY KEY;Share this post
Link to post
Share on other sites