I have an error
Not unique table/alias: ‘wp_postmeta’ with query
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 ON (wp_posts.ID = wp_postmeta.post_id) WHERE 1=1 AND (
wp_postmeta.meta_key = ‘post_views_count’
) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 3 yêu cầu bởi require(‘E:\Sites\cth.edu.vn\wp-blog-header.php’), require_once(‘\Sites\cth.edu.vn\wp-includes\template-loader.php’), include(‘\Sites\cth.edu.vn\wp-content\themes\Newspaper\search.php’), get_footer, locate_template, load_template, require_once(‘\Sites\cth.edu.vn\wp-content\themes\Newspaper\footer.php’), td_api_footer_template::_helper_show_footer, load_template, require_once(‘\Sites\cth.edu.vn\wp-content\themes\Newspaper\parts\footer\td_footer_template_1.php’), td_block_7->render, td_block->render, td_data_source::get_wp_query, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
Help me resolve this error!!
Thank!
Hi,
I have not seem this error before, from what I find online it seems to be an issue with the database
– https://wordpress.stackexchange.com/questions/283334/wordpress-database-error-not-unique-table-alias-wp-postmeta
– https://wordpress.stackexchange.com/questions/283334/wordpress-database-error-not-unique-table-alias-wp-postmeta/283348
It could be caused by modifications made by you, or by a plugin. Check any custom code or theme modifications you made. Deactivate all plugins except theme plugins, clear all caching and check the results.
Thanks
Thank you!
i’ll try!
