Technology Insights

Update WordPress Amazon Product in a Post Plugin 2.X to Amazon Product in a Post Plugin 3.X

If you use the Amazon Product In A Post Plugin on WordPress you might have either not upgraded yet or decided to not upgrade because the shortcode syntax has changed. You can get around not upgrading by updating the WordPress post content immediately after you upgrade the Amazon Product In A Post Plugin. Below I describe the version that I upgraded and the MySQL syntax used to update the shortcode syntax to display Amazon products in WP posts.

Technology Insights

Modify Every Row In A MySQL Table By Adding Data To The Front Of Each Column

Last night I was working on a project for a customer where the application was going to reference external images after the changes I made. One of the custom parts of the project included modifying the thousands of rows that currently existed in the MySQL database. I needed away to modify one of the columns in a MySQL database table by adding data to the front of that column in each row.

Technology Insights

PostgreSQL: PSQL Select Distinct Output * To Generate New Table

Earlier this evening I ran into a unique issue where a PostgreSQL table had been created with no primary key this allowing duplicate rows to exist in the database table. You are unable to delete such rows in a SQL table because there is no primary key. After not being able to delete the rows via the PSQL CLI I opened pgAdmin III to see if I could delete the rows using the GUI interface provided by pgAdmin III however the delete was grey in the menu as shown in the below image.

Technology Insights

WordPress: Unable To Upload To The Media Library After Moving Servers

I recently moved a WordPress site from one location on a server to another location on the same server for a client. Everything seemed to work fine after following the directions in this article I had previously published. That article was specifically published for changing the domain that points to the WordPress site which could include simply changing the domain only or actually moving the site to a new server or new location on the same server and a new domain. If you are performing the second of those two options you may also need to update the “upload_path” depending on the configuration of the new server and if the paths are the same as they were on the initial server the WordPress site was installed on.