Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

error moving site to real server


Guest

Recommended Posts

I've been developing my site locally, and I've jsu moved it to a real server. Thing is, I get the following error:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

whossat then? :shock: anyone know what I can do?

Link to comment
Share on other sites

with out going into a little more detail about exactly what you've done it's impossible to help you.

 

However if you would consult the documentation you would probably find the solution

Link to comment
Share on other sites

I looked in the docs, the wiki etc and searched the forum before posting...

 

I must admit that info on how to transfer a working osc site to a different server seemed rather thin on the ground...If you know of step by step instructions for this I'd very gladly follow them.

 

Here's what I did.

 

I uploaded the site files to the new server. I created a database on the new server with the same name, and using phpmyadmin on both servers, dumped the original db in a .sql file and put it into the db on the new server.

 

I then edited /includes/configure.php to reflect the changes.

 

now I'm lost. dunno what to try next :(

Link to comment
Share on other sites

as long as you are just tring to install the db that comes with the osc distribution, lets try this.

 

point your browser to

http://www.whatever.com/catalog/install

 

This should start the standard install routine.

You will need to know the

db name

db user name

db password

 

File System (or absolute) path some thing like

/home/whatever/public_html/catalog

Web Server path

http://www.whatever.com/catalog

 

Go through the steps and see what happens

Make a note of any errors or warnings

Link to comment
Share on other sites

what I'm trying to do is move my site, with populated database, tweaked php files and all from my local server to a public server.

 

I have wondered whether doing a standard install, and then uploading the changed pages, and editing the db might work... it'd be easy to upload something I shouldn't tho...

 

apart from /includes/configure.php , are there other files I should be editing?

Link to comment
Share on other sites

I did your last idea. Installed remotely and locally. Ftp'd all local edited pages. Sent images. Backed-up local data base and transfered it to remote.

Restored remote datbase with the transfered backup. Not a hitch so far. :arrow:

 

 

Roger

facts invariably distort the truth

Link to comment
Share on other sites

this is what I do

 

when you are developing locally don't delete the install folder, just rename it.

 

Make a db bu. This stays in the bu dir.

 

Upload all the files.

 

You can config manually or do the regular install. Use the original configure.php files you got with the down load. if you have any doubts about paths osc will USUALLY figure them correct for you. If you use an altered configure.php file it may not.

If you HAVE NOT installed any mods that require db changes you can procede with a complety normal install. When complete go to admin>backup>restore you good db.

If you have made db changes, TICK THE DO NOT INSTALL DB. Use phpmyadmin to populate the db. Use the original configure.php files you got with the down load. if you have any doubts about paths osc will USUALLY figure them correct for you. If you use an altered configure.php file it may not.

 

Use phpmyadmin to populate the db.

 

I've done this a number of times

Link to comment
Share on other sites

cool. thanks! I already deleted the install folder. Presumably I can just copy it in again from the archive I used?

 

I have made adjustments to the db , so I'll do that too. Although...I guess if I do install the db, and then overwrite it all, then it'll set up all the database connections for me properly. Can anyone see problems with that idea?

 

It'll be a couple of days now before I can try again, due to all the changes I've had to make (I forgot to incorporate the stock numbers, so no-one'll understand the orders!)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...