Category Archives: Work

Data truncated for column ‘status’ at row 1 [SOLVED]

Showing the existing enum values for the status field

Recently I encountered the following error: Data truncated for column ‘status’ at row 1 This was specifically in a PHP based web hotel/reservations app that uses MySQL for the database backend. When trying to add a new dropdown option value of ‘departed’, the form submission would always fail with the aforementioned error. Thankfully, the solution was easy once I checked the table/field definitions. The column ‘status’ was of type enum and thus needed to have the ‘departed’ value specifically enumerated in

Enable remote MySQL access (root non-local access)

Often one of the first tasks after setting up a MySQL server is to enable connections from other IP addresses. Here are a some articles that discuss how to setup a user that can access a MySQL database remotely (non-locally). Between the two of them you will have all the info you need to create user accounts for remote MySQL db access If you are in a testing environment you can also enable non-local root access for all databases from

Regenerate thumbnails error on WordPress [SOLVED]

regenerate-thumbnails

Recently I switched to a new WordPress theme and subsequently encountered some image thumbnail issues. Here is the specific error I received when regenerating thumbnails: function (){if(l){var t=l.length;(function i(t){x.each(t,function(t,n){var r=x.type(n);”function”===r?e.unique&&p.has(n)||l.push(n):n&&n.length&&”string”!==r&&i(n)})})(arguments),n?o=l.length:r&&(s=t,c(r))}return this} This was particularly frustrating, because if a custom size is not available then WordPress will use the FULL size image even for thumbnails. This of course results in slow page times and wasted bandwidth The solution Thankfully, after a little checking it appeared to be a simple permissions issue.

Windows Update error 80072f8f [SOLVED]

The dreaded error message!

If you get a Windows Update “error 80072f8f” when you try to Check for Updates, you may need to adjust your computer’s date and time settings! The 80072f8f error generally happens when there is a large discrepancy between your system clock and the Windows Update service…. so when that happens you will get the error and be prevented from receiving updates. Thankfully, as mentioned earlier, the fix is generally very easy as you just need to update your computer’s date/time to

Internet speed test results for Best Western Oasis, Joplin MO

speedtest-joplinmo

I am on a business trip to upgrade servers at Weblogs.us. The servers are located in Tulsa OK, but for tonight I stopped in Joplin MO along the way. Priceline negotiator got me a room for $42 plus tax at the Best Western Oasis. That price is nice but internet is a big part of my work so I always try to evaluate the network speeds where I stay. So far I’d give them a C+ but speedtest.net rates it

The best custom taxonomy plugin for WordPress? [SOLVED]

custom-fields-custom-post-types

I checked out a bunch of custom taxonomy plugins for WordPress. When it was all said and done my favorite plugin was: Custom Fields and Custom Post Types Management http://wordpress.org/plugins/types/The complete and reliable plugin for managing custom post types, custom taxonomy and custom fields. While it is a little hefty at ~6.8MB after uploading, it does the trick and is fully compatible with the latest WordPress version. Woot!

Changes to the Amazon.com Associates Program

Annotated screenshot showing the Amazon affiliate program changes as of Feb 1st

Amazon associates/affiliates received the following notice recently: We are writing to notify you of some changes to the Amazon.com Associates Program Operating Agreement, which governs your participation in the Amazon Associates Program for Amazon.com. All changes are effective on February 1, 2014. https://affiliate-program.amazon.com/gp/associates/help/operating/compare And here is my summary of the changes: Magazines go from a 25% affiliate commission (fee rate) to none Video game console products go from a 4% commission (fee rate) to 1% Overall this continues a trend by

Page 2 of 1612345...10...Last »