PS3 uplaod problems

I've uploaded my site from my local testing server to my hosted server. I did a fresh install, took note of the root_URL, Local_root and Remote_root from the WA_Settings table from the database. I imported the database from my local server and updated the WA_Settings table to reflect the hosted server settings. I then uploaded my altered files and images from my local server to the hosted server.

The hosted site is still reflecting my local settings for page URL's and images that I've added using the admin area.

for example my local server structure would look like this:
page_name.php

and the hosted server looks like this:
page_name.php

instead of this:
page_name.php

Is there something else I should be changing?

The URL settings are stored in the wa_settings table. If the table is not properly configured you will have problems like this. One way you could do this would be to start by making a backup of the site and db minus the wa_settings table so you don't loose any info. Next you could go through a fresh installer on your live server, this should create the wa_settings table for you with the correct values in it. Once you have done that you can restore the other tables in the db and upload any of your files that you have updated. This should get you a live working version of the with all of the same products and data from your local setup.

Thanks for this. I found that the local site name was hard coded in the CSSMenuWriter menu.php file:

$WA_localRoot = "/site_name/";
$WA_remoteRoot = "/site_name/";

So I changed it to this which fixed the menu issue:

$WA_localRoot = "" .$WAGLOBAL_localRoot ."";
$WA_remoteRoot = "" .$WAGLOBAL_remoteRoot. "";

The site name was also hard coded for the URL location of all the images used in the CMS, this was rectified by changing the URL path for each image.

Thanks again.

Glad to hear that, did you edit the menu with Menu Writer at any point? The default files have these values set as:

$WA_localRoot = "" .$WAGLOBAL_localRoot ."";

$WA_remoteRoot = "" .$WAGLOBAL_remoteRoot. "";

They should not be updated unless you make an edit with Menu Writer. Thanks for mentioning the CMS images, I'm sure this will be helpful to any others looking to do the same thing.

Yes I did use Menu Writer to change the menu. I just copied the code illustrated from the default menu.php file and it rectified the problem.

Thanks again for all your help!