Technology Errors

WordPress database error Duplicate entry X for key yarpp_content for query UPDATE wp_posts SET, MySQL Error

Today I was adding a note to a WordPress article I had written a couple of days ago and it appeared to POST without issue after I clicked the Update button in the WordPress admin. I went to the front-end of the site to verify the new content formatted correctly and to my surprise it wasn’t displaying so I figured I must have left a HTML tag or something open since I didn’t get any errors within the WordPress admin when I clicked the Update button for the Post. After further review the content didn’t exist and it appeared that the article had not posted the update at all since there were zero revisions from today. Fixing the problem is easy by using the below information that describes where I located the error, the error itself, and how to resolve it by issuing a single MySQL command.

Technology Errors

WordPress Pretty Link Not Working, Pretty Link URL’s Open Blank Page

I received a comment on one of the QD posts earlier today that noted the Facebook link-share button posted an incorrect link on Facebook. These social media buttons exist on the bottom of each article on the Question Defense site. Initially when looking into the issue I was confused because he actual URL that was posted was correct meaning it posted the proper Pretty Link via the WordPress Pretty Link plugin however when I tested the actual link I was redirected to the proper domain but the page display was blank. Below is information on the troubleshooting process I used, what the problem ended up being, and how the problem was resolved.