slic535 Posted September 27, 2020 Share Posted September 27, 2020 File: [catalogue.class.php] Line: [70] "SELECT SQL_CALC_FOUND_ROWS MIN(`live_from`) AS `next_time` FROM `store1CubeCart_inventory` WHERE `live_from` > UNIX_TIMESTAMP() LIMIT 1;" - Unknown column 'live_from' in 'field list' i am getting this in my errors log. what is it? can it be fixed? i am using 6.2.9 and i updated from 6.1 recently Link to comment Share on other sites More sharing options...
bsmither Posted September 27, 2020 Share Posted September 27, 2020 Somehow, the upgrade did not execute a SQL statement that added this column to the database. If all you did was to replace the codebase with the latest version, that would explain why the database schema did not get upgraded. In admin, Maintenance, Upgrade tab, the Upgrade History shows the series of versions that the database went through. Link to comment Share on other sites More sharing options...
slic535 Posted September 27, 2020 Author Share Posted September 27, 2020 it says 6.1.14 is the latest. there is a button to revert back to the old version. should i go back? Link to comment Share on other sites More sharing options...
bsmither Posted September 27, 2020 Share Posted September 27, 2020 No, do not go back. Instead, make sure you have the /setup/ folder from CC629 on your site, then go to: http://www.example.com/setup/index.php CubeCart should ask if you want to upgrade the database or to create a new database. Select to upgrade. If this choice (upgrade|new) is not presented to you, do not proceed. We need to figure out why that is. Afterward, you will be shown a new admin URL to use to log in to admin. Link to comment Share on other sites More sharing options...
slic535 Posted September 27, 2020 Author Share Posted September 27, 2020 that worked. thanks bsmither Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.