I think you want to use get_var(), not get_row() – looking at the documentation, MySQL’s GREATEST just returns a single value. $results will then just be the value of the greatest (be it up or down). If you want the greatest up and the greatest down, use; $wpdb->get_row(“SELECT GREATEST(up) AS ‘up’, GREATEST(down) AS ‘down’ …”)
You can use this function: // get users with specified roles function getUsersWithRole( $roles ) { global $wpdb; if ( ! is_array( $roles ) ) $roles = array_walk( explode( “,”, $roles ), ‘trim’ ); $sql=” SELECT ID, display_name FROM ” . $wpdb->users . ‘ INNER JOIN ‘ . $wpdb->usermeta . ‘ ON ‘ . $wpdb->users … Read more
There are a couple of ways you can achieve what you asked for but the latter is what I’d recommend: Set up a copy of the site in a different directory and using your web host’s control panel map the different domains to the appropriate directories. Use the same DB_NAME/DB_USER/DB_PASSWORD/DB_HOST in the /wp-config.php file for … Read more
(I realize you’re leaning away from this, but maybe if you can get it working, it’s worthwhile. With the recent perfomance improvements in 3.4 for WP_Query, this could be worthwhile.) WP_Query is the right decision if this is a secondary loop. Otherwise, you might look into pre_get_posts. When you use WP_Query make sure that: You … Read more
Check all credentials in wp-config.php. And don’t forget about table prefix.
WordPress will use MySQLi when it can or unless you tell it not to. Unfortunately if WP doesn’t see a mysqli_* function, it will assume that you want to use mysql_*. There is some logic that will fall back to plain, old mysql_*, but, from your stack trace, that’s not what’s happening. You don’t mention … Read more
After facing problems with exhausted memory and time consuming queries i’ve tried a different way bulk importing. The idea isn’t new but but to show a possible way i want to share my solution. Keep in mind, i’m not a professional in PHP/MySQL, so maybe there is a more effective or better way to accomplish … Read more
Not sure if it is related, but just in case, as for the last time I looked at it WP core 5.8 have bugs in dbdelta relating to MySQL 8 when integers are involved. Latest MariaDb seems to do better. I would assume that as of 5.8 core is not ready to be deployed on … Read more
could a WordPress installation get so large or gain so many users that it needs another database? If you mean sharding of a database to spread data across multiple servers for sheer quantity of data, then yes, but only for 3 or 4 websites in existence, aka WordPress.com. If you think you need this for … Read more
You can delete directly from the database, using an SQL statement like: delete from wp_postmeta where meta_id in ( select * from ( select meta_id from wp_postmeta a where a.meta_key = ‘blogger_blog’ and meta_id not in ( select min(meta_id) from wp_postmeta b where b.post_id = a.post_id and b.meta_key = ‘blogger_blog’ ) ) as x ); … Read more