lexijade Posted January 3, 2018 Share Posted January 3, 2018 Whenever I try to update to the latest version, it just gets stuck. I just close the window then, and then I get the error in admin "WARNING: Your store appears to be using source code from 6.1.13 but the database is still at 6.0.5.Please complete the upgrade by running the setup process." Help! Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 3, 2018 Share Posted January 3, 2018 Please tell us what you see when you run www.yoursite.com/setup/index.php. Quote Link to comment Share on other sites More sharing options...
lexijade Posted January 4, 2018 Author Share Posted January 4, 2018 It just gets stuck on the "Upgrading from version 6.0.5 to version 6.0.6" forever. Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 4, 2018 Share Posted January 4, 2018 I have found in my personal experience that sometimes a browser will not 'auto-refresh'. Meaning that one would need to keep pressing the "Continue" button - giving about 5 seconds between each click for each step to finish. It has to do with the security settings I have implemented for my browser's behavior. Let us know if clicking Continue five seconds after getting each page still fails for you. Quote Link to comment Share on other sites More sharing options...
lexijade Posted January 4, 2018 Author Share Posted January 4, 2018 I am pretty sure it is auto-refreshing. How many times should I have to click continue, because that doesn't seem to be doing anything either? There aren't any "steps" it's just that same screen going from 6.0.5 to .6. I have had it open since I took the screenshot, and it's still on that same page. Quote Link to comment Share on other sites More sharing options...
lexijade Posted January 4, 2018 Author Share Posted January 4, 2018 Been over 2 hours and nothing has happened. I have tried clicking continue and nothing happens when I do that either. Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 4, 2018 Share Posted January 4, 2018 Nothing happens? There is no page refresh? Or there is a page refresh but the information shown is the same? Quote Link to comment Share on other sites More sharing options...
lexijade Posted January 4, 2018 Author Share Posted January 4, 2018 The page is refreshing, but the screen doesn't change. It's still going from 6.0.5 to 6.0.6 Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 4, 2018 Share Posted January 4, 2018 Let's see if the error_log can show us anything. Quote Link to comment Share on other sites More sharing options...
lexijade Posted January 4, 2018 Author Share Posted January 4, 2018 [04-Jan-2018 14:59:59 America/Tijuana] PHP Notice: `latest` is not allowed as a key in 'CubeCart_inventory' table! in /home/content/88/5118188/html/classes/db/database.class.php on line 900 Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 4, 2018 Share Posted January 4, 2018 That may be from an instance of CubeCart delivering the Homepage (has Latest Products). In upgrading the database (which is what setup does), the upgrade step for 6.1.0 adds the 'latest' column (the 'key') in CubeCart_inventory. So, the CubeCart code uses 'latest' in a query, but the database is not ready to use that query as specified - which is why setup is being run. So, see if there is an error_log file in the /setup/ folder. Quote Link to comment Share on other sites More sharing options...
lexijade Posted January 5, 2018 Author Share Posted January 5, 2018 [04-Jan-2018 23:07:39 UTC] PHP Notice: Undefined index: db_converted in /home/content/88/5118188/html/setup/setup.upgrade.php on line 111 [04-Jan-2018 23:07:39 UTC] PHP Notice: Undefined index: config_converted in /home/content/88/5118188/html/setup/setup.upgrade.php on line 142 that's what in the error_log file in the setup folder Quote Link to comment Share on other sites More sharing options...
lexijade Posted January 5, 2018 Author Share Posted January 5, 2018 Here's the code from line 110 to line 155 ## If version is less then 4 or 5 try to fix database encoding if (!$_SESSION['setup']['db_converted'] && version_compare($current, '5.0.0', '<')) { /* ######################## ## Following code based on; ## Migrating MySQL Data to Unicode ## http://daveyshafik.com/archives/166-migrating-mysql-data-to-unicode.html ## Thanks to Davey Shafik ## ######################## */ $tables = $db->getRows(); foreach ($tables as $table) { ## Get Schema if ($schema = $db->misc('SHOW CREATE TABLE '.$table['Name'])) { ## Fix Schema and Create Temp Table $find = array("latin1", $table['Name']); $replace = array("utf8", $table['Name'].'_utf8'); if($db->misc(str_replace($find, $replace, $schema[0]['Create Table']))) { if ($db->misc("SHOW TABLES LIKE '".$table['Name']."_utf8'", false)) { ## Copy Data $db->misc('INSERT INTO '.$table['Name'].'_utf8 SELECT * FROM '.$table['Name']); ## Deleting Original Table $db->misc('DROP TABLE '.$table['Name']); ## Renaming Temporary Table $db->misc('ALTER TABLE '.$table['Name'].'_utf8 RENAME TO '.$table['Name']); } } } } $_SESSION['setup']['db_converted'] = true; } ## Updates from version 3 if (!$_SESSION['setup']['config_converted'] && version_compare($current, '4.0.0', '<')) { ## Version 3: Upgrade config data $config_string = $db->select('CubeCart_config', array('array'), array('name' => 'config')); if ($config_string) { $old_config = unserialize($config_string[0]['array']); foreach ($old_config as $key => $value) { $new_config[base64_decode($key)] = stripslashes(base64_decode($value)); } $db->update('CubeCart_config', array('array' => base64_encode(json_encode($new_config))), array('name' => 'config')); } $_SESSION['setup']['short_lang_identifier'] = $new_config['defaultLang']; unset($old_config, $new_config, $config_string); Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 5, 2018 Share Posted January 5, 2018 Nothing useful in here. 'Undefined index' notices will not cause PHP to crash (that is, if PHP is crashing - which has not been proven yet). More thoughts later. Quote Link to comment Share on other sites More sharing options...
lexijade Posted January 10, 2018 Author Share Posted January 10, 2018 Any new thoughts? I'd love to get our site to be completely updated! Quote Link to comment Share on other sites More sharing options...
lexijade Posted March 20, 2018 Author Share Posted March 20, 2018 Still having this issue. Would love to upgrade to 6.1.14 and stop having the "WARNING: Your store appears to be using source code from 6.1.14 but the database is still at 6.0.5. Please complete the upgrade by running the setup process." Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted March 20, 2018 Share Posted March 20, 2018 It is almost impossible to say what is causing your issue based on the information we have to date. It could be lack of Server resources, it could be that the files haven’t been correctly updated (a manual upgrade instead of the built in admin function is the only reliable way to upgrade)or it could be any number of other causes. If you previously tried to follow the Admin upgrade, then I suggest that you try a manual upgrade from scratch Ian Quote Link to comment Share on other sites More sharing options...
lexijade Posted March 21, 2018 Author Share Posted March 21, 2018 16 hours ago, havenswift-hosting said: It is almost impossible to say what is causing your issue based on the information we have to date. It could be lack of Server resources, it could be that the files haven’t been correctly updated (a manual upgrade instead of the built in admin function is the only reliable way to upgrade)or it could be any number of other causes. If you previously tried to follow the Admin upgrade, then I suggest that you try a manual upgrade from scratch Ian How do I do a manual upgrade without losing all of the changes/customization that I've done? Quote Link to comment Share on other sites More sharing options...
1pdeals.co.uk Posted November 11, 2020 Share Posted November 11, 2020 I found that rather than press continue, press start over instead and that works. I also found, unfortunately that this upgrade did not upgrade my database and I had to use the host restore to get the shop working again. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.