Update Problem from ver. previous 2.1

[winddancer]

Hi all,

 

I have a problem importing data from a osCommerce version prior to MS 2.1.

I am not sure which version this is, which makes it even more difficult.

 

Whenever I try to use the udpate function in the osCommerce install function, I only receive this error message:

 

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 /is/htdocs/50221/www.detmoldshop.de/catalog/install/includes/functions/database.php on line 45

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /is/htdocs/50221/www.detmoldshop.de/catalog/install/includes/functions/database.php on line 45

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /is/htdocs/50221/www.detmoldshop.de/catalog/install/includes/functions/database.php on line 45

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /is/htdocs/50221/www.detmoldshop.de/catalog/install/includes/functions/database.php on line 45

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /is/htdocs/50221/www.detmoldshop.de/catalog/install/includes/functions/database.php on line 45

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /is/htdocs/50221/www.detmoldshop.de/catalog/install/includes/functions/database.php on line 45

 

The database upgrade procedure was successful!

 

When I try to use the backend and frontend functions I encounter several errors.

For example the prices of the products are all reset to 0 and I cannot open past orders.

 

 

Is there any sensible update routine for versions prior to MS 2.1 ??

 

Any help is greatly apreciated!

Thanks in advance

 

Sven

[winddancer]

i additionaly tried to use the extra update.php.

 

unfortunately this didn't work either. I still receive errors.

 

Is there no way to update old databases ???

 

kind regards

 

sven

[winddancer]

hmm does no one have a solution for this ?

 

kind regards

 

Sven

[Guest]

Hi Sven,

 

I managed to upgrade a Sept/02 snapshot to the latelst milestone by installing it in a different directory than the current (old) cart, then pointed it to the old database and changing a few things in the configure.php files. Then do the upgrade, and there will be a couple of more errors (you'll find the fixes here in the forum, I beleive it was something to do with the zones).

I have all working but right now can't get the catalog images to come up... I'm still working on that.

 

Hope that helps,

Violet

[Guest]

Found the image fix... make sure your catalog/includes/configure.php file has this for images:

 

define('DIR_WS_CATALOG', '/catalog/');
define('DIR_WS_IMAGES', 'images/');

 

Hope it all made sense... :D

 

Violet