Use WP’s update_post_meta() function instead of straight SQL. If the postmeta exists, it gets updated. If it doesn’t exist, it gets added. update_post_meta(‘1117’, ‘_yoast_wpseo_metadesc’, ‘Test 5’);
You could try adding this above your wordpress rules in your .htaccess: RewriteCond %{REQUEST_FILENAME} !-f RewriteRule ^about-us/([^/]+)/([0-9]+)/$ about-us/$1/ [R=301,L] It isn’t very useful, but that could be a good thing. It would redirect any grandchild of the about-us directory that is only numbers to its parent page (child of about-us). This one is universal. In … Read more
How to fix database error duplicate entry
Ended up with using this code: <?php query_posts(‘category_name=Menucard’); ?> <?php if ( have_posts() ) : while ( have_posts() ) : the_post(); ?> <div class=”span4 post move pull-left”> <?php //echo post here the_content(); ?> </div> <!– close .post div –> <?php $counter++; if ($counter % 3 == 0) { echo ‘<div style=”clear:both;”></div>’; } ?>
That should only happen if, as you say, there is a post with the same unique permalink. Any in the trash will still have the same effect.
I think the problem is that you’re passing the wrong arguments to the $attachments query, causing you not to get the intended posts in the $attachments query. Here’s what you’re doing: $args = array( ‘post_status’ => ‘inherit’, ‘numberposts’ => 0, ‘post__not_in’ => array_merge($do_not_duplicate,get_option( ‘sticky_posts’ )), ‘post_type’ => ‘attachment’, ); $args[‘tax_query’] = array( array( ‘taxonomy’ => … Read more
It’s my fault. Got the solution after @Otto’s comment: Do you actually have a duplicate key here? What is the structure of user_req and what are the keys and indexes? Here’s how my SQL query should be: INSERT INTO {$wpdb->prefix}user_req ( user_id, post_id ) VALUES ( %d, %d ) WHERE NOT EXISTS ( SELECT * … Read more
The environment I work in has a development, staging and production server. We set up a Git repository and don’t track the wp-config file. We always copy the DB down, production -> staging -> development, and not the other way around. Only thing you have to do when you pull commits after your create plugins, … Read more
Duplicate posts in paginated results
Ok, well I believe that I have things working correctly. I’d be curious if anyone has any more insights, but I believe what was happening: I was calling my class incorrectly I was referencing a class function in wp_next_scheduled and wp_schedule_event when I should have been referencing a callback/hook. My revised code (which has been … Read more