Work | J.D. Hodges

Category Archives: Work

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

Tuesday, 2014.02.18 J.D. H. Leave a comment

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

Read more programming, Software Tips, Work

Enable remote MySQL access (root non-local access)

Sunday, 2014.02.16 J.D. H. Leave a comment

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

Regenerate thumbnails error on WordPress [SOLVED]

Saturday, 2014.02.15 J.D. H. Leave a comment

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

Windows Update error 80072f8f [SOLVED]

Friday, 2014.02.14 J.D. H. Leave a comment

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

Internet speed test results for Best Western Oasis, Joplin MO

Thursday, 2014.02.13 J.D. H. Leave a comment

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

Read more Internet tips, Travel tips, Work

Twitter post upon new WordPress comment [Zapier]

Sunday, 2014.02.09 J.D. H. Leave a comment

Almost have this working. Currently getting the following error message: Did a lot of searching and could not find a solution for Zapier. 🙁 Contacting their support now and will keep you posted! Hopefully I am not missing something absurdly easy 😉

The best custom taxonomy plugin for WordPress? [SOLVED]

Saturday, 2014.02.08 J.D. H. Leave a comment

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! 🙂 Top Search Terms:the best taxnonomy for wordpress (1)

Changes to the Amazon.com Associates Program

Wednesday, 2014.01.29 J.D. H. Leave a comment

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