I broke it: maximum time exceeded error after manually loading the db

  • I didn’t want to manually transfer information from my old site to my new so I wrote a script to dump data from the rows in the old table into the posts table of wordpress. It seems to work fine when I look at the page management page, but it now takes forever to execute. It’s only about 177 rows.

    Did I need to update some other tables like post2cat for this to work right?

Viewing 4 replies - 1 through 4 (of 4 total)

  • Did I need to update some other tables like post2cat for this to work right?

    If you didnt, yes. That contains the, well you can probably figure out what it contains: three columns, rel_id, post_id, and category_id

    That may or may not be the slowness you are seeing, but chances are if that table doesnt have that data, WP is spending forever looking for something that doesnt exist.

    I actually have no experience with what happens if that data isnt located,.

    Thread Starter WordyPresser

    (@jeremyduffy)

    I just updated the script and tried again while maintaining the post2cat table as well, but same result. Isn’t wordpress built to handle more than 100 pages or so at a time? Is it just because it tries to show them all on the page at the same time?

    Thread Starter WordyPresser

    (@jeremyduffy)

    I emptied the entire DB and started over. Same problem, but I’m beginning to think it’s something with my actual computer. It seems to be doing these operations very slowly…

    Thread Starter WordyPresser

    (@jeremyduffy)

    https://www.marshinsoftware.com/software/wordpress_page_management_patch/

    This fixed it perfectly.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘I broke it: maximum time exceeded error after manually loading the db’ is closed to new replies.