I have an odd error that just arose in a 4.3 installation SqlException: Invalid column name 'PriceRanges'
Not aware of any changes having been made, but, I did connect to the database from a 4.4 installation. Might that have triggered a change in the database?
Got it. The database structure must have been modified when I connected and in particular the attribute PriceRanges in Category might now named PriceRangeFiltering. Adding an attribute PriceRanges has allowed the site to run again. I'm about to go through other pages to find what else is now generating an error.
Part of the problem here is that I didn't realise it would make a change when all I did was modify a connection string and so the nearest backup I have is from last night and transactions have occurred today. Other pages are also returning the same error so off to learn what other attributes may have changed. I would have though that whoever wrote this script that is clearly designed to modify a database that the first thing they would do is to create a backup. If that happened I' cannot see it!
in v4.4 code there is no need of 'PriceRanges' field in Category, Manufacturer and Vendor tables but instead should be PriceRangeFiltering PriceFrom PriceTo ManuallyPriceRange
so if you are running v4.4 code but it still needs PriceRanges - may be it is not 4.4?) as well you can check migration history in db table MigrationVersionInfo
It is nopCommerce version 4.40.2. It has been running for a few months now but only after I recreated the field as stated earlier. NOTE this is an old thread.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.