Uploaded WP 3.0 site not loading WordPress

Rashad Aliyev answers:

Which site is it?

did you check your permalinks?

NickStrong comments:

Thanks for the response.
Obviously I can't give you a WP URL, because that is not working.
The existing site is at www.tagweb.co.uk/french-waterways. The WP installation is at www.tagweb.co.uk/french-waterways/waterpress I need page refs to be of the format www.tagweb.co.uk/french-waterways/pageurl.html etc.
Obviously, it might well be the permalinks, but what should I check them for / as being?

NickStrong comments:

I should add that, offline / locally, the Permalinks do operate correctly as type localhost/pageurl.html etc.

Rashad Aliyev comments:

If you're make all of settings for your new host. And still not working. then you can create .htaccess file manually..

I'll give you htaccess file. Put it to your root and check it again.



# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

# END WordPress



Rashad Aliyev comments:

Change your wp site permalinks to default then test it again.. if it's working then make an special permalinks for your site.

Denzel Chia answers:

Hi,

<blockquote>
The existing site is at www.tagweb.co.uk/french-waterways. The WP installation is at www.tagweb.co.uk/french-waterways/waterpress I need page refs to be of the format www.tagweb.co.uk/french-waterways/pageurl.html etc.
</blockquote>

Currently all your post/page url is http://www.tagweb.co.uk/french-waterways/pageurl.html which is causing the 404 error.
Because the url should be http://www.tagweb.co.uk/french-waterways/waterpress/pageurl.html

Changing the htaccess rewrite rules will not help, because I am sure that in your wordpress database post table the guid field is http://www.tagweb.co.uk/french-waterways/pageurl.html without the waterways folder.

You should export your posts from wordpress admin and import using
http://wordpress.org/extend/plugins/wordpress-importer/ instead of doing mysql export.

But for now you should write a mysql query to fix all the post guid to http://www.tagweb.co.uk/french-waterways/waterpress/pageurl.html

Then follow the example from http://codex.wordpress.org/Function_Reference/WP_Rewrite
to let wordpress rewrite url to http://www.tagweb.co.uk/french-waterways/pageurl.html

Thanks.

Denzel

Chris Murphy answers:

Attempt the following steps:

1. Check your DB to ensure that your siteurl is correct for your production server, e.g. "wp_options" -- you can search for it using this query:
SELECT option_name, option_value FROM wp_options WHERE option_name = 'siteurl';
And reset it using this one:
UPDATE wp_options SET option_value = 'http://your.newdomain.com' WHERE option_name = 'siteurl';

2. Reset your permalink structure using this query:
UPDATE wp_options SET option_value = '' WHERE option_name = 'rewrite_rules';

3. Delete your .htaccess file

4. Physically remove your plugins from the wp-content/plugins directory (this will prevent them from loading)

5. Check to see if your site it loading with the defaults

6. Log into the admin area and go to Settings->Permalinks and choose the structure you want (or keep with the default), and then <strong>save your changes</strong>. This will force WP re-write the .htaccess file and update wp_options with the new settings.

7. Re-enable your plugins one by one--this step will test to see if there is a plugin conflict.

If your plug-ins load successfully, it is likely that there were problems with a combination of the permalink structure and your site url (they can be mutually exclusive issues).

If you want to future-proof the URIs in your Posts/Pages/etc. you can follow these instructions to implement a simple solution: [[LINK href="http://www.farfromfearless.com/2010/09/07/url-token-replacement-techniques-for-wordpress-3-0/"]]URL Token Replacement Techniques for WordPress 3.0[[/LINK]]


Here's a set of queries to update the URIs your posts/pages:
UPDATE wp_options SET option_value = REPLACE(option_value, "http://www.old-domain.com", "http://www.new-domain.com");
UPDATE wp_posts SET post_content = REPLACE(post_content, "http://www.old-domain.com", "http://www.new-domain.com");
UPDATE wp_posts SET post_content_filtered = REPLACE(post_content_filtered, "http://www.old-domain.com", "http://www.new-domain.com");
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, "http://www.old-domain.com", "http://www.new-domain.com");