Guest Posted July 13, 2003 Share Posted July 13, 2003 I am trying to upgrade from ms1 to ms2, but when I run the install/index.php and do the upgrade, it seems to work here is what I get on the final screen: Upgrade * Address Book * Banners * Categories * Configuration * Currencies * Customers * Images * Languages * Manufacturers * Orders * Products * Reviews * Sessions * Specials * Taxes * Whos Online Status: Update Complete! Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prospect/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prospect/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prospect/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prospect/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prospect/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prospect/public_html/catalog/install/includes/functions/database.php on line 45 The database upgrade procedure was successful! It says it was sucessful but it has all the errors. After I ran this it double many of my 'My Store" settings and now there is two of everything that was already in my last install, and if I try to do it again, I get yet another copy of all of them, I browsed my configuration table in my database and I only show the old setting not the new??? Anyone that has any ideas, they would be greatly appreciated. Doug Link to comment Share on other sites More sharing options...
Harald Ponce de Leon Posted July 13, 2003 Share Posted July 13, 2003 The upgrade procedure in the main install/upgrade module is for The Exchange Project 2.1 to osCommerce 2.2 MS2. The osCommerce 2.2 MS1 to MS2 upgrade script is available in the extras directory. , osCommerce Link to comment Share on other sites More sharing options...
John Posted August 11, 2003 Share Posted August 11, 2003 and whats about uppgrading from 2.2 CVS version to 2.2 ms2. How it can be done to upgrade the snapshot version to this latest version. Link to comment Share on other sites More sharing options...
shawngiese Posted August 13, 2003 Share Posted August 13, 2003 I have copied the update.php file to the /catalog/install directory and the mysql.php to the /catalog directory. Then it says: Select an SQL file to install. oscommerce.sql If I select oscommerce.sql (the only choice) then I get one last review of what will happen and I see that a whole bunch of tables are getting dropped. This does not seem to be the correct upgrade path since I will loose many tables. Is there a different .sql file that I should also upload or instructions that I cannot find? Thanks for the help. Link to comment Share on other sites More sharing options...
solardirect Posted August 17, 2003 Share Posted August 17, 2003 John, try this link for instructions for upgrading from 2.2CVS to 2.2MS2: http://www.oscommerce.com/forums/viewtopic.php...lardirect[/url] Look at bottom of page two for how I did it. Kirk Boom... Big butta boom. Link to comment Share on other sites More sharing options...
John Posted August 26, 2003 Share Posted August 26, 2003 John, try this link for instructions for upgrading from 2.2CVS to 2.2MS2: http://www.oscommerce.com/forums/viewtopic.php...lardirect[/url] Look at bottom of page two for how I did it. Kirk Its ok for the customers table, Whats about orders table, I am running a pure downloadable products. How I will migrate the whole previous orders from the old DB structure to new one. Link to comment Share on other sites More sharing options...
solardirect Posted August 26, 2003 Share Posted August 26, 2003 the only change in the db structure that I found was the customer table and the address_book table. I do not use downloads, so I am not positive, but when I looked at the db with Beyond Compare diff program I did not see any changes to any other tables. You may want to look for yourself. Basically you start with your old db structure and data and then make the changes in the link above. That way you have your old data and make the changes in the two tables that changed so that it will work with the new code. hth, Kirk Boom... Big butta boom. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.