RC2 to RC3 Upgrade: Admin Access Denied

[SavageSinister]

OK - I read here: osCMax 2.0 RC3 upgrade :that there was an upgrade file for RC2 installations; I downloaded it and applied it to The Overlook Connection : Welcome .

Then I saw that the RC3 > RC3.01 update only touched these files, according to the documentation: http://www.oscmax.com/projects/relea..._2_0_0_rc3_0_1 :

1. /catalog/.htaccess
2. /catalog/checkout_process.php
3. /catalog/install/osCMax.sql

So I uploaded .htaccess and checkout_process.php from the 3.01 update. I did NOT install the new SQL, since the upgrade documentation said that it wasn't necessary.

Now, at http://www.overlookconnection.com/admin/, I get:

Warning: mysql_connect(): Access denied for user: 'usernamedeleted@localhost' (Using password: NO) in /home/overlook/public_html/admin/includes/functions/database.php on line 19
Unable to connect to database server!

So is the osCMax.sql installer in the 3.01 upgrade, in fact, necessary? If so, will it wipe out existing products in the RC2 database?

If the osCMax.sql installer is NOT necessary for the upgrade, any ideas as to what's causing this error?

I've poked around about this and the only similar threads I found were regarding virgin installations, not RC2 to RC3 upgrades. Any help is, of course, wildly appreciated.

[The primary concern, here, is the retention of the 4,000+ products in the store at the moment - losing them during the upgrade is not acceptable]

[michael_s]

The rc3.01 sql file is only if you have not already installed the database by default, using the osCMax installer. It does nothing for already installed sites, and in fact will kill your entire database if you use it... so don't!

That error you are getting means you overwrote your admin/includes/configure.php file database connection info with incorrect info, or it does not match your actual database info.

[SavageSinister]

Excellent- thank you, Michael. I uploaded the old admin/includes/configure.php file and now it's fine.

Follow-up question, then. If that file was in the RC3 upgrade-only package, one would assume that that means something in that file changed from RC2; should I go into the RC3 upgrade version of the file and input config data, then upload that?

Or did it not really need to be there in the first place? That is to say, did "configure.php" not *really* need to be replaced for the RC3 upgrade?

[michael_s]

The key info in that error message is:

(Using password: NO)

This means that you are not using a password to connect in your configure.php file and you need to add it.

[michael_s]

Excellent- thank you, Michael. I uploaded the old admin/includes/configure.php file and now it's fine.

Follow-up question, then. If that file was in the RC3 upgrade-only package, one would assume that that means something in that file changed from RC2; should I go into the RC3 upgrade version of the file and input config data, then upload that?

Or did it not really need to be there in the first place? That is to say, did "configure.php" not *really* need to be replaced for the RC3 upgrade?

You should never replace your configure.php files. They really never change. I was sure that they were not in the package, but I will have to double check that.

I just confirmed it, and it is a mistake in the package. The configure.php file should NOT be in the package. Sorry about that.

[SavageSinister]

You should never replace your configure.php files. They really never change. I was sure that they were not in the package, but I will have to double check that.

It *is* in the upgrade package, FYI - I just investigated the .ZIP file I downloaded earlier.

Thanks for your help!!

[SavageSinister]

Follow up question - I noticed that the Upgrade-Only RC3 pack also includes /templates/aabox/main_page.tpl.php -- I built the site design using the RC2 version of this file, so obviously if I upload this, it'll kill my design. Is this one necessary and, if so, is there a way to edit the RC2 version to update it to RC3 specs, rather than uploading over the RC2 version?

[JohnW]

Search and download "Beyond Compare" and your life will be much easier. It compares the folders and files of both versions and then you can look at individual files side by side and the changed lines are highlighted. You can then move the lines you want.

[SavageSinister]

Search and download "Beyond Compare" and your life will be much easier. It compares the folders and files of both versions and then you can look at individual files side by side and the changed lines are highlighted. You can then move the lines you want.

Thanks, John - I will!

I wonder, though, given how much I changed the template file for aesthetic purposes, if this will help. We'll see...

[JohnW]

There is a 30 day trial period so it will only cost you the time. It's one of the best tools I have. Even though you've changed it a lot it will highlight the actual characters in the line that are different so it really makes this way easier.