```
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;
Question
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;Link to comment
Share on other sites
7 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now