[Solved] Moving server - reverts to original install (1.12)

[frank4360]

I have set up 1.12 with CG extension and some pages of my own on my own home server, but now want to move to a sub-directory of my real server.


On the new server I have re-installed 1.12 as per the new installation instructions, including setting up the database. Then, using FTP, I copied all files except config.php from my localhost server to the new server, and exported/imported the database from the localhost to the new server. Using phpMyAdmin everything looks fine - the database contains the new pages added by me on the localhost site.

But when I log in to the new server I get the standard "Home.
Congratulations! The installation worked." - and none of the changes from the localhost site are shown.


I am pretty new to CMSMS, and so I have cleared out the remote server CMSMS site and done everything again over the last few days, but the same thing is happening and I can see no reason how I can be getting the new installation pages rather than the ones I transferred.

In the Admin Log there are a series of entries of the form:-

Code: Select all

IP Address      User   ID  Item Name     Action
11.22.33.44 	frank 	57 	Core 	failed to get content for valid content id 57 	

I feel I am missing a basic point.

Any ideas gratefully accepted.

[velden]

Why all the efforts of new installation to overwrite everything afterwards? (hint: clear cache)

Further:
http://docs.cmsmadesimple.org/moving

[frank4360]

Why all the efforts of new installation to overwrite everything afterwards? (hint: clear cache)

Because when I followed the instructions for moving I had lots of problems - too many to go into and probably because of mistakes in importing and exporting the database.

I wanted to prove that I could set up a new site on the server to ensure there were no server issues.

Further:
http://docs.cmsmadesimple.org/moving

Then I followed the instructions to move over the site.

At all times I cleared cache - no change.


I was not certain that I could simply move all files without going through a "re-install" process, but I will try that now.


Thanks for the reply and I will let you know how I get on.

[velden]

If your server has a webadmin allowing you to extract archives (e.g. zip or tar.gz) then I would try to create an archive of the original files, upload to server and extract.

FTP just isn't a reliable protocol.

If using FTP make a checksum file of the original site and use it to validate the copied site; Site Admin -> System Verification

[frank4360]

OK - I have found the problem, and I can now see the new pages.

The problem was the db_prefix in the config.php file. In exporting and importing the database I ended up with two different prefixes in the tables of the database. One prefix refers to the data uploaded, while the other refers to a newly installed module.



I deleted the hosted database and recreated an empty one, then re-exported the tables from the localhost and imported them into the hosted database. I then carefully checked that all the tables had the correct prefix, and that this corresponded with the config.php file.

Now everything works (after clearing cache).

Thanks for all your help.