Monthly Archives: 八月 2013

WordPress database error: [Table 'wp_postmeta' is marked as crashed and should be repaired]
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'rb_announcements_end_date' AND ( ( mt1.meta_key = 'rb_announcements_start_date' AND CAST(mt1.meta_value AS CHAR) <= '2017-07-15' ) AND ( mt2.meta_key = 'rb_announcements_end_date' AND CAST(mt2.meta_value AS CHAR) >= '2017-07-15' ) ) ) AND wp_posts.post_type = 'rb-announcements' AND (wp_posts.post_status = 'publish') OR (mt1.meta_key = 'rb_announcements_start_date' AND CAST(mt1.meta_value AS CHAR) = '') OR (mt2.meta_key = 'rb_announcements_end_date' AND CAST(mt2.meta_value AS CHAR) = '') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC LIMIT 0, 10