#5044 closed defect (bug) (worksforme)
WordPress database error
Reported by: |
|
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)
#4
@
16 years ago
Yepp, it is the Google Sitemaps plugin.
Use the new version:
http://downloads.wordpress.org/plugin/google-sitemap-generator.3.0.zip
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.