I'm receiving the following error: INVALID SQL: 1054 : Unknown column 'onsale_display' in 'where clause' SQL QUERY FAILURE:SELECT * FROM xcart_onsale ...
Posted by - NA - on 01 December 2010 10:23 AM
This is caused by the On Sale files being updated, but not the database.

Open the file INSTRUCTIONS if upgrading from version 1.17 or earlier.txt. in the On Sale zip distribution. At the bottom there are a number of SQL patches. Insert these one at a time into your patch/upgrade -> SQL Queries section in the X-Cart admin.

Some SQL queries may fail. This is normal.



Related Articles

•I'm receiving this error on the checkout page: "There was an error loading the shipping options, please try again. (You may need to refresh your browser.)"
•I'm receiving a file is corrupt error when download a file using the Download Expander link.
•How do I find files that may have extra line breaks or whitespace after the ?> in a PHP file?
•When the checkout loads the first state is selected by default. How can I force a customer to select a state.


Still Have Questions? If you are unable to find a solution in the knowledgebase please open a support ticket for a personal response from alteredCart support.

Comments (0)
Post a new comment
Full Name: