WordPress Upgrade database error

  • Resolved amitkalia

    (@amitkalia)


    17 years, 4 months ago

    Hi!

    I just upgarded my eralier version of wordpress and now I am getting this error:

    See it on top of my home page:

    WordPress database error: [Table ‘amitkalia.wordpress_post2cat’ doesn’t exist]
    SELECT p2c.category_id AS cat_id, COUNT(p2c.rel_id) AS numposts, UNIX_TIMESTAMP(max(posts.post_date_gmt)) + ‘3’ AS last_post_date, UNIX_TIMESTAMP(max(posts.post_date_gmt)) AS last_post_date_gmt FROM wordpress_post2cat p2c INNER JOIN wordpress_posts posts ON p2c.post_id=posts.id WHERE 1 = 1 AND posts.post_type = ‘post’ AND posts.post_status = ‘publish’ AND posts.post_date_gmt <= ‘2007-10-31 01:01:10’ GROUP BY p2c.category_id ORDER BY numposts DESC

    Please help me resolve this.

    Amit

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

  • Me too–same error! Help It appears above my header:

    WordPress database error: [Table ‘discontentweblog.wp_post2cat’ doesn’t exist]
    SELECT p2c.category_id AS cat_id, COUNT(p2c.rel_id) AS numposts, UNIX_TIMESTAMP(max(posts.post_date_gmt)) + ‘-7’ AS last_post_date, UNIX_TIMESTAMP(max(posts.post_date_gmt)) AS last_post_date_gmt FROM wp_post2cat p2c INNER JOIN wp_posts posts ON p2c.post_id=posts.id WHERE 1 = 1 AND posts.post_type = ‘post’ AND posts.post_status = ‘publish’ AND posts.post_date_gmt <= ‘2007-10-31 02:01:35’ GROUP BY p2c.category_id ORDER BY numposts DESC

    wwww.renodiscontent.com

    I can see it has something to do with the UTC time but I’m not sure how to fix it.

    I deactivated all plugins and then updated version of Google Sitemap plugin as advised here: https://trac.www.ads-software.com/ticket/5044) but problem still exists.

    I only have askimet running as far as plugins go–After I deactivated all of them and that didn’t help, I decided that I could at least activate askimet so I wouldn’t be inundated with spam. Any help would be fantastic as I have tried everything I can think of after searching through the forums.

    Okay, this is resolved for me….

    WordPress database error: [Table ‘amitkalia.wordpress_post2cat’ doesn’t exist]

    Might review this thread:
    https://www.ads-software.com/support/topic/135564?replies=75

    It is likely an incompatible theme or plugin.

    Thread Starter amitkalia

    (@amitkalia)

    Removed some plug-ins. all is back to normal.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WordPress Upgrade database error’ is closed to new replies.