Are you still facing the issue? I might be able to help you out. Here are some more reasons why it might be happening: A corrupted database – Bad plugins, addons, themes and data-transfer interruptions might leave your database short of tables or completely corrupted at worst. Corrupted WordPress files Found this on: http://www.wpkube.com/how-to-fix-error-establishing-database-connection-in-wordpress/
Speed up a wordpress site is not a MySQL settings issue. One site in order to perform well is to USE MySQL with the best efficient way (limit your queries results, get only what you need) Default wordpress database schema have been already set up (primary keys, indexes e.t.c) to be used by the default … Read more
You can query INFORMATION_SCHEMA and achieve the same: function getEnumValues($table, $field) { global $wpdb; $result = $wpdb->get_row(“SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ‘” . DB_NAME . “‘ AND TABLE_NAME = ‘” . $table . “‘ AND COLUMN_NAME LIKE ‘” . $field . “‘”); if($result === FALSE) { die($wpdb->last_error); } // this is the column … Read more
It seems to have solved by changing the two functions, by taking a different approach: /* CHECK IF CURRENT USER IS NOT IN POST.PHP AND IN POST-NEW.PHP AND DOWNGRADE PUBLISH POSTS IN PENDING AFTER X DAYS */ if(is_admin() ) {global $pagenow; if( ‘post.php’ != $pagenow || ‘post-new.php’ != $pagenow) { add_action( ‘init’, ‘downgrade_publish_posts’ ); function … Read more
Emoji support and MariaDB 10.0.30-
The reason is you are visiting the home page and it contains the WordPress Loop like below to query 10 recent posts. <?php if ( have_posts() ) : while ( have_posts() ) : the_post(); // Your loop code endwhile; else : // not found template endif; ?> The number of posts can be managed from … Read more
Trigger Plugin database update after git pull
Scaling with hardware alone is expensive. We’ve worked with a few high traffic sites and a lot of demanding ecommerce/WooCommerce sites. The way we’ve scaled those is by testing the code, optimising database calls, optimising the database itself and implemented full page caching. Here’s a few tips to get you started Use nginx instead of … Read more
Emojis getting converted to “?”
Reasons this might happen: When WP checks the tables exist and they don’t If the DB connection fails The database is unreachable A DESCRIBE query on the tables fails, be it permissions or access based If there is an error recorded in the wpdb object while setting up initial variables in wp_set_wpdb_vars When ms_load_current_site_and_network returns … Read more