Note on database migration from PrestaShop 1.7.4.x to newer

If you are migrating tables from PrestaShop 1.7.4.x, please check out the table with name "ps_stock_available"

As new column "location" is added on, you shop will not be functioning well if this column is missing

Below SQL can help to create the column:

ALTER TABLE `ps_stock_available`
ADD `location` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ''
AFTER `out_of_stock`;

Article Details

Article ID:
Rating :

Related articles