This issue is as a result of your server not supporting the utf8mb4_unicode_520_ci collation type. To resolve this you should convert the collation for all tables with utf8mb4_unicode_520_ci to utf8_general_ci If you’re exporting through phpmyadmin, you can: Click the “Export” tab for the database Click the “Custom” radio button Go the section titled “Format-specific options” … Read more
Try this for posts from last 1 year: AND ( post_date_gmt < DATE(NOW()-INTERVAL 1 YEAR) )
There is nothing wrong with writing logs to a file, you just need to make sure you create a special directory for it and add .htaccess that will prevent listing, and probably deny all access to it from the web. There is nothing overly wrong with storing data in the DB provided you do it … Read more
Thanks to @Milo I could fix it. The problem was, that the tags were not assigned to any post. display.php $tags = get_tags(array(‘hide_empty’ => false)); The hide_empty param do the trick.
Add this code in functions.php. visit your site you, it will automatic add/update all user meta value. After executing this code just comment out or remove this code. $args = array( ‘fields’ => ‘all’, ); $blogusers = get_users( $args); foreach($blogusers as $key => $user){ update_user_meta( $user->ID, ‘is_activated’, 1 ); } OR you can also do … Read more
As it says in wpdb::prepare Prepares a SQL query for safe execution. Uses sprintf()-like syntax. Thus, if you change it to: $sql = $db->prepare(“SELECT ap.photo_id, ap.creation_date, ap.owner_id, ap.file_id, ap.title AS photo_title, ap.description, aa.album_id, aa.title AS album_title, aa.category_id, sf.storage_path, u.displayname, u.username FROM engine4_album_photos ap LEFT JOIN engine4_album_albums aa ON aa.album_id = ap.album_id AND category_id <> 0 … Read more
In the class WP_Query, there is a hook posts_pre_query wich allow to set the result of a query before the DB call https://core.trac.wordpress.org/browser/tags/4.7.3/src/wp-includes/class-wp-query.php#L2755
If you use get_post_meta() with just the first parameter ( post ID ) you’ll get an array of all the post meta for the passed ID. You’ll get more than you expect but you can then use any number of ways to get the data that you want out. $post_meta = get_post_meta( 207717 )
Since you mentioned that this is only happening on certain environments then a possible cause could be that those servers do not have the proper PHP extensions installed to handle parsing XML. Here’s a great Stack Exchange answer that outlines most (if not all) of the required extensions. Specifically, I would confirm whether or not … Read more
According to WordPress Codex about the template_redirect hook: This action hook executes just before WordPress determines which template page to load. So, you are redirecting the user to another page before the template is even loaded, which your form won’t load at all. You can use another hook which runs after template_redirect, such as wp_footer. … Read more