Need download of v2.2 RC2 for client upgrade

[dvharrison]

Hi

 

One of my websites has had a problem with security on. As a result I would like to upgrade the current website and follow your security advice post like a bible.

 

However, I am doing all of this offline first just to be doubly sure I don't mess anything up (as its a big site we are talking 5000+ lines here). As a result In wondered if there was somewhere where I could download the v2.2 rc2 verison of OSCommerce so I can set the website up in its current state on my virtual server?

 

Please could anyone advise me? Or can anyone recommend an alternative method (eg fresh version of OSCOmmerce or a general guide) so I can secure this website.

 

Many thanks in advance

[♥geoffreywalton]

Download the current site to your local sever.

 

Take a backup of the live db and import to MYSQL on your virtual server

 

Edit the 2 config files to reflect the settings on your virtual server and away you go.

 

HTH

 

G

[dvharrison]

Thanks Geoffrey

 

I have downloaded my current website and tried to import the database in phpmyadmin home. And when I try to download the sql.gz database I get the following message:

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'You do not have access to that database (name_of_my_database)!' at line 1

 

As a result on the home page the message is

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'myusername'@'localhost' (using password: YES) in C:\path_to\includes\functions\database.php on line 19

Unable to connect to database server!

 

 

Eeeek! Please help.

[♥geoffreywalton]

Try unzipping the file and importing it.

 

Also do you have a db to import it into?

 

HTH

 

G

[dvharrison]

Hi Geoffrey

 

I tried unzipping, but literally the message I get (and I quote):

 

You do not have access to that database (my_database)!

 

I think its to do with login. I have changed the config files which still had the old Mysql logins details.

 

I have changed both config files, according to http://www.oscommerce.com/forums/topic/193738-a-guide-to-the-configurephp-files/page__hl__localhost+setup__fromsearch__1

 

And still no success. I have attached these. Please could you shed some light?

[♥geoffreywalton]

If you are importing using phpmyadmin it does not refer to the config files.

 

Does the db kbowditch1_kelscrafts_co_uk_products exist?

 

This db is probably specified in the import file.

 

You can edit it and remove/delete "instuctions" that are not required.

 

HTH

 

G

[Jan Zonjee]

And still no success. I have attached these.

In one of your configure.php files you didn't fill in the password for the database.

define('DB_SERVER_PASSWORD', '');

[dvharrison]

Jan, on the localhost database, I haven't got a password. This is why I wondered if it would've been easier to set up a fresh configuration of the software. Please advise.

[dvharrison]

I have created the user "database_user" with the existing password, but I am still getting:

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'You do not have access to that database (name_of_your_database)!' at line 1

 

I have some knowledge of MySQL, so please could anyone advise?

[♥geoffreywalton]

If you are importing using phpmyadmin it does not refer to the config files.

 

Does the db kbowditch1_kelscrafts_co_uk_products exist?

 

This db is probably specified in the import file.

 

You can edit it and remove/delete "instuctions" that are not required.

 

HTH

 

G

 

Are you using phpmyadmin to import the dump file and are getting this error message?

 

G

[dvharrison]

Yes that is correct. Its in a thatnameDB.sql.gz file

[♥geoffreywalton]

Try unzipping the sql file and look at the first few lines.

 

Delete those before the section that refers to address books.

 

Then try importing it again.

 

G

[dvharrison]

All it says when I open it up is: You do not have access to that database (kbowditch1_kelscrafts_co_uk_products)!

 

:sweating: This is freaking me out!

[♥geoffreywalton]

Well go into phpmyadmin and give root permissions to the db also set up a user and give them permissions to the db as well so you can use that in the config files.

 

Cheers

 

G

[dvharrison]

Right good news - I managed to export the database as a sql and that has installed successfully.

 

However, now I get Object not found 404 page on every link except the main page. I have a feeling thats down to .htaccess

 

I shall look and keep you posted.

 

Thanks fr your help as always Geoffrey

[FrostyFred]

I suspect it is more likely to be the values in the config files.

 

define('DIR_FS_ADMIN', 'C:/Program Files/xampp_15/xampp/htdocs/xxxxxx

 

FF

[dvharrison]

Cool. My only problem is I cannot view the admin folder. Because it's password-protected online, I get a 500 page despite having the correct login. Please advise.

 

Error is:

 

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.

If you think this is a server error, please contact the webmaster.

[♥geoffreywalton]

Contact your host or remove the security entries from the htacess file.

 

HTH

 

G

[dvharrison]

Hi G

 

Sort of. I can now get onto the admin login page but when I sign in I now get an Object Not Found saying the link is out of date. It is the same link as the admin page but it ends with ?action=process&osCAdminID=AnAdminID

 

I do have search engine friendly URLs as an addon but I thought that would have only been effective on the catalogue pages.

 

I'm sort of progressing forwards slowly but my goodness this has been a long journey. Please help :sweating:

[dvharrison]

I went through my configure.php files and that sorted it. So so far so good.

 

Just a minor detail: When I access the catalog on admin panel I get the following message in pink:

 

Error: Catalog images directory does not exist: /htdocs/myfolder/images/

 

But it clearly does exist because you can view files from it.

 

Is this something I need to threat about? :unsure:

[♥geoffreywalton]

Either your file system path or web path is wrong in your config file.

 

Best to correct it.

 

Cheers

 

G

[dvharrison]

Actually it is worrying because it cannot find the includes/modules directory either. Actually I've sorted that with full root. Thanks guys for all your help.

[dvharrison]

Actually (sorry going back to my original question). To upgrade, would it simply be a case of following http://www.oscommerce.info/confluence/display/OSCOM23/v2.2+to+v2.3.0 ? Please advise.

[♥geoffreywalton]

Unfortunatly it is not a complete upgrade

 

This upgrade guide only provides the minimum required changes in the form of security updates and bug fixes. [b]These changes will not upgrade your store to a complete v2.3 version.[/b] Please continue to use v2.2 add-ons and do not install v2.3 optimized add-ons as the may not function with your installation. If you wish to upgrade to a full v2.3 version, perform only (SQL) Database Changes and use the database with a new v2.3 installation.

 

Cheers

 

G

[dvharrison]

Thanks G. So really upgrade to 2.3.1 such as http://www.oscommerce.com/forums/topic/379473-22rc2a-to-302-step-by-step-manual-or-plugin/ ?