Title: WordPress Upgrade database error
Last modified: August 18, 2016

---

# WordPress Upgrade database error

 *  Resolved [amitkalia](https://wordpress.org/support/users/amitkalia/)
 * (@amitkalia)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/wordpress-upgrade-database-error/)
 * 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)

 *  [myrnatheminx](https://wordpress.org/support/users/myrnatheminx/)
 * (@myrnatheminx)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/wordpress-upgrade-database-error/#post-646100)
 * 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
 *  [myrnatheminx](https://wordpress.org/support/users/myrnatheminx/)
 * (@myrnatheminx)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/wordpress-upgrade-database-error/#post-646102)
 * I can see it has something to do with the UTC time but I’m not sure how to fix
   it.
 *  [myrnatheminx](https://wordpress.org/support/users/myrnatheminx/)
 * (@myrnatheminx)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/wordpress-upgrade-database-error/#post-646107)
 * I deactivated all plugins and then updated version of Google Sitemap plugin as
   advised here: [http://trac.wordpress.org/ticket/5044](http://trac.wordpress.org/ticket/5044))
   but problem still exists.
 *  [myrnatheminx](https://wordpress.org/support/users/myrnatheminx/)
 * (@myrnatheminx)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/wordpress-upgrade-database-error/#post-646110)
 * 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.
 *  [myrnatheminx](https://wordpress.org/support/users/myrnatheminx/)
 * (@myrnatheminx)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/wordpress-upgrade-database-error/#post-646115)
 * Okay, this is resolved for me….
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/wordpress-upgrade-database-error/#post-646230)
 * > WordPress database error: [Table ‘amitkalia.wordpress_post2cat’ doesn’t exist]
 * Might review this thread:
    [http://wordpress.org/support/topic/135564?replies=75](http://wordpress.org/support/topic/135564?replies=75)
 * It is likely an incompatible theme or plugin.
 *  Thread Starter [amitkalia](https://wordpress.org/support/users/amitkalia/)
 * (@amitkalia)
 * [18 years, 5 months ago](https://wordpress.org/support/topic/wordpress-upgrade-database-error/#post-646325)
 * 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.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 7 replies
 * 3 participants
 * Last reply from: [amitkalia](https://wordpress.org/support/users/amitkalia/)
 * Last activity: [18 years, 5 months ago](https://wordpress.org/support/topic/wordpress-upgrade-database-error/#post-646325)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics