OScommerce works great on local Wamp but not after ftp upload

[lwilliams114]

I have installed OScommerce 2 on my local Wamp server and worked on it for several days to get it just the way I want it to look and work. Now I ftp's it to my website and it says can't find database which is understandable. I went to web hoster and created a database but now how do I go link it to my uploaded website without losing all the work I did on the website? I really need and would appreciate your help on this. I am lost.

Thanks in Advance.

Leon

[♥FWR Media]

I have installed OScommerce 2 on my local Wamp server and worked on it for several days to get it just the way I want it to look and work. Now I ftp's it to my website and it says can't find database which is understandable. I went to web hoster and created a database but now how do I go link it to my uploaded website without losing all the work I did on the website? I really need and would appreciate your help on this. I am lost.

Thanks in Advance.

Leon

 

the two configure files will be still set to your localhost paths etc .. namely ..

 

catalog/includes/configure.php

 

catalog/admin/includes/configure.php

 

If you do not need to retain the database settings of your localhost install I would recommend the following: -

 

1) Replace the two configure files mentioned above with the blank ones from the downloaded package.

 

2) Upload the catalog/install directory

 

3) Browse to your site and it will reinstall creating the correct configure files.

 

WARNING: You will lose ALL database settings so only do this if you do not care about the database being renewed.

 

Having said that you can still do the above if you have a database backup because after install you could just delete the DB and upload your backup.

[lwilliams114]

the two configure files will be still set to your localhost paths etc .. namely ..

 

catalog/includes/configure.php

 

catalog/admin/includes/configure.php

 

If you do not need to retain the database settings of your localhost install I would recommend the following: -

 

1) Replace the two configure files mentioned above with the blank ones from the downloaded package.

 

2) Upload the catalog/install directory

 

3) Browse to your site and it will reinstall creating the correct configure files.

 

WARNING: You will lose ALL database settings so only do this if you do not care about the database being renewed.

 

Having said that you can still do the above if you have a database backup because after install you could just delete the DB and upload your backup.

 

I did exactly as you said and then ftp'd to my server and now when I hit the website address it gives me the following error:

 

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/l/w/i/lwilliams114/html/includes/functions/database.php on line 19

Unable to connect to database server!

 

I hope you can help me.

Thanks again,

Leon

[Guest]

Did you ftp your configure files to the server? The point of it was to reinstall osC on your web server so it would create NEW configure.php files so you can use them on your hosted site. You would end up with 2 sets of configure.php files, one for your desktop computer and one for the hosted site (both different).

[lwilliams114]

Did you ftp your configure files to the server? The point of it was to reinstall osC on your web server so it would create NEW configure.php files so you can use them on your hosted site. You would end up with 2 sets of configure.php files, one for your desktop computer and one for the hosted site (both different).

 

I took the 2 configure files from a new download of oscommerce and replaced them as instructed and then uploaded my oscommerce with the 2 new files. I didn't upload the whole catalog folder. I just opened catalog up and uploaded all the folders and files inside. I am sure I messed something up. What do you think. I will do it again just to be sure I didn't accidently upload configured files.

 

Thanks

Leon

[lwilliams114]

I took the 2 configure files from a new download of oscommerce and replaced them as instructed and then uploaded my oscommerce with the 2 new files. I didn't upload the whole catalog folder. I just opened catalog up and uploaded all the folders and files inside. I am sure I messed something up. What do you think. I will do it again just to be sure I didn't accidently upload configured files.

 

Thanks

Leon

You were exactly right I uploaded the new configure.php files by accident. I have now uploaded new ones and it is giving me setup when I start to put in the database server, user name, password and database now I get this error:

 

There was a problem connecting to the database server. The following error had occured:

 

Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2)

 

I am using Godaddy to host. I typed in localhost for the server. Should that be something else as that is what I was using on my local computer?

Thanks for helping me get this running. I really have been pulling my hair out.

Leon

[lwilliams114]

You were exactly right I uploaded the new configure.php files by accident. I have now uploaded new ones and it is giving me setup when I start to put in the database server, user name, password and database now I get this error:

 

There was a problem connecting to the database server. The following error had occured:

 

Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2)

 

I am using Godaddy to host. I typed in localhost for the server. Should that be something else as that is what I was using on my local computer?

Thanks for helping me get this running. I really have been pulling my hair out.

Leon

I just tried their IP address as the server and it gave me the following error:

 

Can't connect to MySQL server on '72.167.131.9' (111)

 

hmmm..

[lwilliams114]

I just tried their IP address as the server and it gave me the following error:

 

Can't connect to MySQL server on '72.167.131.9' (111)

 

hmmm..

 

Ok.. I had a bad ip address on them. I got it and it's all there. Now I just have to figure out how to import the saved database to the website again.

Thanks

Leon

[lwilliams114]

Ok.. I had a bad ip address on them. I got it and it's all there. Now I just have to figure out how to import the saved database to the website again.

Thanks

Leon

 

 

All you helped with works well except I can't get the database to import that I saved on my desktop. I uploaded it to backups and went to admin and told it to restore that one and it goes about half way and says there is an error.

Any information on that one would be appeciated too. It is a small database.

Thanks

Leon

[♥FWR Media]

All you helped with works well except I can't get the database to import that I saved on my desktop. I uploaded it to backups and went to admin and told it to restore that one and it goes about half way and says there is an error.

Any information on that one would be appeciated too. It is a small database.

Thanks

Leon

 

Some phpmyadmin default to UTF8 when you import .. try selecting latin 1

[lwilliams114]

Some phpmyadmin default to UTF8 when you import .. try selecting latin 1

 

Latin 1 timed out too. I sent you a pm.

Thanks