Ticket #5044 (closed defect: worksforme)

Opened 1 year ago

Last modified 1 year ago

WordPress database error

Reported by: mann3r Assigned to: anonymous
Priority: normal Milestone:
Component: General Version: 2.3
Severity: normal Keywords:
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

09/22/07 06:02:53 changed by matt

  • status changed from new to closed.
  • resolution set to worksforme.

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.

09/22/07 06:03:44 changed by Viper007Bond

Sounds like the Google Sitemap plugin.

09/22/07 16:43:28 changed by foolswisdom

  • milestone deleted.

09/24/07 15:12:52 changed by ArneBrachhold

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

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