Creating a local copy

[janetgot]

Hello, I have two osCommerce stores now live, thanks to a lot of help from this generous forum. I am now tasked with some refinements and additions to both sites, but don't want to muck around with the live store.

 

So (yes, probably a bit backwards!) I am trying to make a copy of the store on my local computer. I've downloaded and installed XAMPP, and have copied my store successfully to localhost. I also think I've gotten a copy of the database running. However, I can't seem to get osCommerce to talk to the database successfully.

 

Setting the configure.php files to localhost for the database, I get the following error:

 

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

Unable to connect to database server!

 

Thinking that the username and password are not contained in the database itself, I removed them from the configure.php file, and then I get:

 

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

When I created the copy of the database does the username/password come with it, or do I need to recreate that? Is there a place to do that in phpMyAdmin?

 

So much to learn! :blush: Many thanks!

Janet

[crash3903]

There is an option in xaamp to create a mysql database username/password and then transfer the details to your config.php file

 

regards

[janetgot]

There is an option in xaamp to create a mysql database username/password and then transfer the details to your config.php file

 

regards

<{POST_SNAPBACK}>

 

Thanks... Found it!

 

Janet

[crash3903]

Your welcome - hope you ahve fixed it now

 

regards

 

mark

[janetgot]

Your welcome - hope you ahve fixed it now

 

regards

 

mark

<{POST_SNAPBACK}>

 

 

Getting there! I have the catalog running locally... I get this error in the admin section:

 

Fatal error: Cannot re-assign $this in C:\apachefriends\xampp\htdocs\hellyhansen\catalog\admin\includes\classes\upload.php on line 31

 

Am searching the forums now for clues. I hear it's discussed frequently :)

 

Thanks again,

Janet

[Guest]

you are using php5, should have installed php 4.3.11, however you can comment out line 31 with //

[janetgot]

you are using php5, should have installed php 4.3.11, however you can comment out line 31 with //

<{POST_SNAPBACK}>

 

Oh, I see... xampp defaults the initial intallation to php5, but includes a php switch feature to go to 4.3.11. I've found that now, and switched over to 4, which is good, because if I have to make a lot of edits to the local copy, it sort of defeats the purpose of being a "mirror"!

 

I have my admin back, and now just have to get my catalog images to show up again... close, very close!

 

Thanks for your help, again!

Janet