It is totally essential to use utf8mb4 for your site to be secure and bug free in all wordpress versions since 4.2 and probably before that. You need to upgrade your mysql software to a newer version, or change whatever is need in its configuration to support it.
Extending the wpdb class We can create the db.php file under wp-content/ directory to override the wpdb class to our needs. I checked this site for such examples and found one by @MarkKaplun here. Here’s an example how one can get access to the last result, after each query has run: <?php /** * db.php … Read more
These bits of caching are generally considered inadvisable to be messed with. If I remember right you can somewhat control the behavior by query arguments and wrapping related code in wp_suspend_cache_addition() calls. From look through the source it doesn’t seem to be meant to carry custom logic. If you would like similar behavior for your … Read more
You should never have to read wp-config to get database credentials. WordPress has built-in functions which are generally more secure for this sort of operation. In your plugin, simply call global $wpdb; and you will be connected to the WP database. You can then perform whatever queries you need – select, update, add, etc. For … Read more
Your syntax for where is wrong it should be $user1 = $wpdb->get_results(“select product,checked_by,submit_date,unit_data,temperature_in,temperature_out,time_in, time_out,category from diary_user_form_storage where category_name=”opening” OR category_name=”closing” order by submit_date”);
Error is from the last command wp search-replace “${domain}” “test” –allow-root. Your WordPress site is not yet installed and you want to execute command which require WordPress to be installed. Earlier in script you are dropping test database and creating new one, but you have to fill it with WordPress tables. Without this tables WordPress … Read more
The Warning Missing argument 2 for wpdb::prepare(), called in /home/…./public_html/wp-content/plugins/insert-php-code-snippet/shortcode-handler.php(72) : eval()’d code on line 22 and defined It looks like there’s been a fundamental misunderstanding of what the prepare method is supposed to do. You’ve provided a single parameter to the function, but it expects multiple. Hence the missing argument 2 warning. What Does … Read more
To get the number of posts you can do it easily without a second query with $adsQuery->post_count; But if there’s some reason (I’d love to know the context!) I can’t grasp that the same query has to be run twice and to the database directly- to answer your question as to why it’s not working: … Read more
<?php $post_types = array( ‘bmw’ => ‘BMW’, // post type to use in query => post type to show in <h2> ‘audi’ => ‘Audi’ ); foreach( $post_types as $post_type => $post_type_name ): ?> <h2>Latest <?php echo $post_type_name; ?> Posts:</h2> <ul> <?php $args = array( ‘numberposts’ => 5, ‘post_type’ => $post_type ); $recent_posts = wp_get_recent_posts( $args … Read more
As it writes, a problem with the indexes definitions of those tables. Please try a repair on the reported table and see if that helps. Have you activated a specific add-on lately or did you alter tables?