WordPress.org

Make WordPress Core

Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#5044 closed defect (bug) (worksforme)

WordPress database error

Reported by: mann3r Owned by:
Milestone: Priority: normal
Severity: normal Version: 2.3
Component: General Keywords:
Focuses: Cc:

Description

when moderating comment, it always go to this
WordPress database error: [Table 'mydatabase.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID

WordPress database error: [Table 'mydatabase.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID

WordPress database error: [Table 'mydatabase.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID

WordPress database error: [Table 'mydatabase.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID

WordPress database error: [Table 'mydatabase.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID

but trying to refresh the browser yield to a success with no error.

Change History (4)

#1 @matt
12 years ago

  • Resolution set to worksforme
  • Status changed from new to closed

That query does not exist in WordPress 2.3, so it must be coming from a plugin.

I would suggest you find what plugin it is and either deactivate it or check for an update from the author.

#2 @Viper007Bond
12 years ago

Sounds like the Google Sitemap plugin.

#3 @foolswisdom
12 years ago

  • Milestone 2.3 deleted

#4 @ArneBrachhold
12 years ago

Yepp, it is the Google Sitemaps plugin.
Use the new version:

http://downloads.wordpress.org/plugin/google-sitemap-generator.3.0.zip

Note: See TracTickets for help on using tickets.