Jump to content

Edit History

DeacoN_Carr

DeacoN_Carr

Hello all,

After a failed upgrade and restore - my site looks fine, but when I attempt to update an items quantity, I get the below error.

When I search the database - I can see the column id_country is indeed missing under ps_layered_price_index (the rest of the columns appear there as expected).  Is there an easy way to correct this issue?  Is there a way to rebuild the database - yet keep all of my data?  Are there any modules that looks for missing database entries so I can see the extent of what is missing?

Any help would be greatly appreciated!

Unknown column 'id_country' in 'field list'
INSERT INTO `ps_layered_price_index` (id_product, id_currency, id_shop, price_min, price_max, id_country)

VALUES (22, 2, 1, 8, 8, 21),(22, 5, 1, 8, 8, 21),(22, 4, 1, 5, 5, 21),(22, 3, 1, 4, 4, 21),(22, 1, 1, 6, 6, 21) ON DUPLICATE KEY UPDATE id_product = id_product

 

DeacoN_Carr

DeacoN_Carr

Hello all,

After a failed upgrade and restore - my site looks fine, but when I attempt to update an items quantity, I get the below error.

When I search the database - I can see the column is indeed missing.  Is there an easy way to correct this issue?  Is there a way to rebuild the database - yet keep all of my data?

Any help would be greatly appareciated!

 

×
×
  • Create New...