Admin Category Pagination Problem After Import

  • I went ahead and import wp_terms, wp_term_telationships, wp_term_taxonomy from the old database to the new site database. Due to circumstances I had to do this table by table. I’m noticing that the category admin is showing only 3 pages of categories while the live one shows 23. Did I miss something during the database migration other than the three tables listed above?

    Thanks!

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    Sorry for the slow reply. The admin pagination relies upon a COUNT query on the wp_terms table, joined to wp_term_taxonomy so as to only count terms in the category taxonomy. I’ve no idea what the live listing is based on. Keep in mind the total pages depends upon the terms per page value.

    If the wp_posts table is now different from the one in the DB from which you took wp_term_relationships, the posts to term relations will be corrupted, which could explain erroneous results. It depends on the query being run. Additionally, with a different posts table, the count column of wp_term_taxonomy will also be incorrect.

    Not affecting pagination, but there is also a wp_termmeta table that relates to taxonomies that should also be imported.

    I’m not sure any of this helps, but it’s about all I can tell you about term pagination.

Viewing 1 replies (of 1 total)
  • The topic ‘Admin Category Pagination Problem After Import’ is closed to new replies.