DeacoN_Carr Posted July 25, 2019 Share Posted July 25, 2019 (edited) 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 Edited July 25, 2019 by DeacoN_Carr (see edit history) Link to comment Share on other sites More sharing options...
joseantgv Posted July 25, 2019 Share Posted July 25, 2019 As ps_layered_price_index is from blocklayered/ps_facetedsearch, just reset the module. 1 Link to comment Share on other sites More sharing options...
DeacoN_Carr Posted July 25, 2019 Author Share Posted July 25, 2019 Hello - thanks for the reply. Can you tell me how this is done? Link to comment Share on other sites More sharing options...
joseantgv Posted July 25, 2019 Share Posted July 25, 2019 Search this module in the module list and reset it. 1 Link to comment Share on other sites More sharing options...
DeacoN_Carr Posted July 25, 2019 Author Share Posted July 25, 2019 Thank you - when I try to do this - I get an error message: " Could not perform action reset for module defined " I can't seem to do anything with it... Link to comment Share on other sites More sharing options...
DeacoN_Carr Posted July 25, 2019 Author Share Posted July 25, 2019 Hi there - I turns out the module needed to be upgraded. Once I did that - the problem went away! Thanks so much for your help! Link to comment Share on other sites More sharing options...
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