This wouldn’t be caused by a change in the database. What the error refers to is this:
SELECT SQL_CALC_FOUND_ROWS wp_posts.id
FROM wp_posts
WHERE 1 = 1
AND 0
GROUP BY wp_posts.id
ORDER BY wp_postmeta.meta_value + 0 DESC,
wp_posts.post_date DESC
LIMIT 0, 10
Your code only includes data from the wp_posts
table (second line above) but is trying to ORDER BY
data from the wp_postmeta
table (sixth line). You can’t do that. I doubt this is coming from WordPress Core, so a plugin or your theme is hooking a callback into one of the WP_Query
hooks– my guess is the posts_orderby
filter. Something about that filter is broken and it is adding that wp_postmeta.meta_value
bit indiscriminantly.
Related Posts:
- Get error messages when $wpdb->insert() returns false?
- Detecting errors generated by $wpdb->get_results()
- $wpdb->prepare() warning in WordPress 3.5
- Changing the Database Connection Error Message
- When importing database, it shows error
- Strange Deadlock database error for the query “Delete From wp_options”
- WordPress showing install screen after max_questions error
- What causes the “max_user_connections” warning on WordPress frontend?
- $wpdb variable throw this error Call to a member function get_results() on a non-object in
- Error establishing a database connection – with Debug Data
- error establishing a database connection
- Error establishing a database connection on Installation
- SQL Error wp_commentmeta – incorrect table definition
- Moving WP from local server to live, error establishing a db connection
- Where are WP_Errors Saved
- $wpdb doesn’t like to store arrays
- Error establishing database connection – high traffic?
- Catalina an MAMP Database Conenction Error
- Trouble Migrating all data blog from WordPress.com to WordPress.org
- How to fix database error duplicate entry
- Moving to another server database connection error [closed]
- “Error establishing a database connection” – Intermittent error on GoDaddy
- Problem in using wpdb
- How can I restrict php mail() to only send me one email after a db error
- Global__r connection timed out
- SELECT SQL_CALC_FOUND_ROWS with wordpress search
- Error establishing a database connection in wordpress site , website not opening
- How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- SQL database import #1046 error
- error establishing a database connection 3
- “wordpress error in establishing database connection” and missing tables
- error establishing database connection (WAMP + filezilla)
- Hang Up Followed By Can’t select database
- Database error after importing WordPress
- Catchable fatal error in formatting.php
- What am I doing wrong here? WordPress database error
- Restoring .sql backup results in “Error establishing a database connection”
- I broke database after reuploading local version – what exactly happened? Database error
- Print output of Table Creation
- Error at time of WordPress Installation
- WordPress database error Unknown column
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- Difference between partition key, composite key and clustering key in Cassandra?
- How SID is different from Service name in Oracle tnsnames.ora
- What is a relation in database terminology?
- Why WordPress choose data serialization over json_encode?
- Are There Any Plans for WordPress to Support Databases Other Than MySQL?
- Reset Post IDs to less than 64bit integer
- how can get database name in wordpress?
- Does WordPress use the InnoDB engine for MySQL by default?
- Best way to import users, post and categories from an external database
- Performance tips for a large user base [closed]
- How to delete outdated, wrongly sized images in _wp_attachment_metadata?
- wp_options is GB in size
- Can’t update database after wordpress update from 3.8.1 to 4.4.1
- Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
- Database error Deadlock found when trying to get lock; try restarting
- Merge two WordPress installations into one, and keep posts separated?
- Export / import WordPress database
- WordPress choose wrong database
- Is it safe to delete unnecessary user metadata?
- Improve performance by removing unnecessary database queries
- WordPress Relational Database
- Does WordPress $wpdb functions wait when table is locked?
- Unable to set a default serialized array using dbdelta()
- Importing 10 Years of Media into the WP Database
- connecting to DB from custom php file
- Make changes of wp-db.php file persistent against updates
- Change the default data installed when setting up WordPress
- Clear Terms from Taxonomy for Specific Post IDs?
- What might be the reason of Couldn’t fetch mysqli_result on another domain?
- How to split the WordPress database?
- $wpdb->get_var – What value is returned when zero records are found?
- SymmetricDS in dev + prod workflow?
- Fixing YARPP plugin FULLTEXT MySQL indexing
- Counting post and changing roles in mysql database. Query not code
- wpdb Insert unknown post data dynamic foreach loop
- How do I use a database in a custom theme?
- Migrating meta_key and meta_value from old theme to new one
- How do you enable scripts on a WordPress installation in Softaculous?
- How to rerieve comments and their replies from DB
- Inserting data with Geometry field
- Error establishing a database connection after moving local wordpressmultisite from one directory to another
- Export only a part of the database for migration
- Why am I being prompted to reinstall wordpress?
- database error WordPress move from one hosting to other
- Select data from foreach loop and send it to wordpress database
- Same DB for live and dev versions
- update multiple user meta field based on another meta field
- After renaming MySQL database, I can no longer access my Blog page
- execute custom function on database connection error
- Call to a member function insert()
- Create a new table on the database and save parameters from a contact form
- not saving post in wp_post wordpress database table
- How to add data from wordpress tables to new database tables you have created
- Creating Tables in WordPress Database
- How to back-up a database on IIS
- Where are database files of a WordPress website?
- Query a meta key using an array of values where the database value is a string