Unable to export (database problem?)

  • I exported my blog and found that a large number of my posts weren’t showing up when importing into the new one. Looking at the end of the generated xml file, I found the following:

    <item>
<title>Grand Canyon</title>
<link><br />
<b>Fatal error</b>:  Maximum execution time of 30 seconds exceeded in <b>/var/www/blog/wp-includes/post.php</b> on line <b>1047</b><br />

    I don’t remember this particular post very clearly, but searching the (old) blog now I find that there are no posts or drafts by the name of “Grand Canyon.” I assume this error is a result of a broken database entry associated with this post.

    Am I correct in that assumption that this is database-related. If so, is it possible to correct the issue?

    Thanks very much.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jacobandreas

    (@jacobandreas)

    I played around with the sql-query-browser and have determined that grand-canyon is a page rather than a post. There is an entry for it in the database, and I can actually view the page if I type in its “ugly permalink” (the “pretty permalink” gives me a 404).

    Searching for any page in the blog from within wp-admin gives me the same error as in the above post.

    I have no problem deleting these pages if it is necessary to get all of my posts. Does anyone know what I can do?

    jacobandreas – did you manage to fix this?

    I’ve just come across the same error. The export times out when trying to export a page (I get the same timeout message in the XML file). I’ve tried deleting the offending page, but in the export, it still seems to think that the page still exists.

    I’m always left with an XML file of 30.1KB with a timeout error (of 60 seconds, which I increased from 30, and I still get the same filesize of 30.1KB!!).

    Any pointers gladly received.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Unable to export (database problem?)’ is closed to new replies.