Wordpress database problems

[Harrison]

As I said above, if a site isn't working as it is, running an upgrade is not going to fix it. You need to work out what is wrong with the existing site and fix it first or you will never get it working and just create more problems upgrading an already broken site.

Have you looked at the backup of the database. Are the posts actually still present in the database tables? If not then they are gone and you won't be able to ever get them back unless you have an older database backup with them still intact.

[Stephen Coates]

As I said above, if a site isn't working as it is, running an upgrade is not going to fix it. You need to work out what is wrong with the existing site and fix it first or you will never get it working and just create more problems upgrading an already broken site.

That is true, but I thought at first that something had gone wron gwith one of the Wordpress 1.x files on the server, or maybe there could have been something wrong with the theme or something. If this were the problem, then the database would have no effect on the site. But the problem is in the database, and since I didn't have a new copy of 1.x to verify this with, i used the 2.x instead.

I have had a good look through the database. All the posts and comments etc are there. None of the important data is missing, but there is obviously something there which causes all wordpress pages to not do anything (regardless of the version).

I was just wondering if you or anyone else may have any idea of why a database would cause pages to go blank. I cannot find anything which is obvious, but I will have another good look.

It isn't a major problem as we will probably be getting rid of Wordpress in the near future anyway as part of remaking most of the site but it is just annoyiong when it doesn't work.

[Harrison]

Only thing I can think of is that the database character encoding has changed.