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

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.

Technology Insights

No operator matches the given name and argument type(s). You might need to add explicit type casts.

When working on writing some directions for someone at work I ran into a PostgreSQL command line query error. I have much more experience using MySQL so my initial Postgres commands always mimic what I would do in MySQL. Anyhow when attempting to run a SELECT statement matching contents of a specific column I received the error below. After a little research I came up with the answer fairly easily but wanted to note here to help others out and serve as a reference point if I forgot the proper PSQL query in the future. Below I describe the query that caused the error, the error returned by Postgres, and the proper query to use when attempting to match a variable in a Postgres SELECT statement.

Technology Insights

Zencart: How to Add an Order Status Type

Zencart has four default order status types which are Pending(1), Processing(2), Delivered(3), and Update(4). The number in parenthesis represents the order in which the order type will be located in the drop down so by default the first type in the drop down is Pending.

To add a new order status type login to the Zencart admin, click on Localization in the top navigation, and then click Order Status. This will display the order status type admin page where you can add, modify, or delete order status types. If all you need to do is add a order status type that will be located in 5th or higher place then click the Insert button at the bottom and add the new order status type. The very next one you add will be 5th, then 6th, and so on. So if you added Out of Stock via the Insert button you would now have the following order status types: Pending(1), Processing(2), Delivered(3), Update(4), and Out of Stock(5).