oscommerce upgrade script errors

L

LegalAlien

Perch
Wondering if anyone can help. I have been looking at using oscommerce, and am quite impressed so far. Anyhow, I used the Hsphere link to upgrade to store to version 2.2 and I got the following:

Status: Update Complete!


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\hshome\user\domain.com\catalog\install\includes\functions\database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\hshome\user\domain.com\catalog\install\includes\functions\database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\hshome\user\domain.com\catalog\install\includes\functions\database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\hshome\user\domain.com\catalog\install\includes\functions\database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\hshome\user\domain.com\catalog\install\includes\functions\database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\hshome\user\domain.com\catalog\install\includes\functions\database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\hshome\user\domain.com\catalog\install\includes\functions\database.php on line 45

The database upgrade procedure was successful!

OK - it says it was successful, but should I be worried about all the errors listed?
 
I have some advice from oscommerce. They advise the following:

You are upgrading from MS-1 to MS-2. The upgrade script you are using is not built for that purpose

If you want to upgrade from MS-1 to MS-2 then look in the catalog/extras folder and you will see scripts available there.

You will prob need to restore the DB from a backup as you are likely to have duplicate rows in the configuration table.

The script that is launched from Hsphere seems to be the wrong one... Is this likely to be fixed? If not, can I turn oscommerce off and then back on again to install a clean version, since the bad upgrade has probably duplicated db entries?
 
Reply from support in case anyone gets this problem:

We had contacted Psoft regarding this, and they told us that as the account was migrated, the migration did'nt happen properly. So if you want then we can try migrating it again.

Enabling and disabling in Hsphere will do a clean install but will also delete the DB tables and all the settings. As you'll have to configure it from scratch.
Click to expand...
 
You must log in or register to reply here.
Back
Top