Tag Archives: Work

Post-processing of the image failed likely because the server is busy or does not have enough resources. [SOLVED]

Leave a comment

If you encounter the following error: Post-processing of the image failed likely because the server is busy or does not have enough resources. Uploading a smaller image may help. Suggested maximum size is 2500 pixels. and you have tried all the normal solutions (adjusting php.ini, other upload settings) then I suggest checking your plugins for potential issues. Here is the error screenshot: Specifically, I encountered this error when the following plugin was enabled: After you deactivate potentially troublesome plugins, you

Read more Software Tips, WordPress tips

[SOLVED] Lenovo BSOD on Windows 7, Windows has recovered from an unexpected shutdown

Leave a comment

One my clients uses a number of Lenovo mini PC systems. The systems perform very well for their intended purposes, however, some of the systems were sporadically shutting down (blue screen of death). Thankfully, disabling Bluetooth devices/adapters in Device Manager seems to have permanently resolve the issue. The client did not need the bluetooth capability in the first place, so now all is well 🙂 For reference, here is the error message and assorted diagnostic info: Problem signature: Problem Event Name:

Read more computer tips, Software Tips, Work

Best (low cost) digital signage solution w/remote centralized management

Leave a comment

Recently I was tasked with recommending a digital signage solution for a client. Specifically, they needed centralized maintenance and control of approximately 20-30 signs covering 10-12 locations. Another paramount goal was cost effectiveness via no recurring/subscriptions costs. Here is my digital signage recommendation: Specific unit recommendation: Mvix Xhibit Myrko   Mvix Xhibit Myrko   http://direct.mvixusa.com/product/xhibit-mykro-digital-signage $259 single time cost to purchase device No additional license cost, no subscription fees Remote management Single HDMI output My recommendation is for one of the

Read more computer tips, Networking, Work

AT&T LTE speeds in Pierce CO [speedtest]

Leave a comment

I have been in CO for work and to visit family. Part of our stay has been in Pierce which is in northern CO. Remote work has been very easy since the LTE speeds are quite rockin’ in Pierce CO 🙂 Here are the results using an AT&T Unite Pro hotspot with unlimited internet: This sure beats the old days of slow wifi and even slower 3G/4G 😉 Have you used LTE in this area of CO? I would love to

Read more computer tips, Internet tips, Travel tips

Order SQL query manually when numeric string representation is out of order

Leave a comment

In some instances, doing a straight ORDER BY ASC (OR DESC) does not work as one might want: 0-50 101-200 201-300 301-400 401-500 501-600 51-100 601+ That is not how humans do it 😉 A way to get around this, is to add a new column and put in an ordering value, for instance: 1. 0-50 2. 51-100 3. 101-200 4. 201-300 5. 301-400 6. 401-500 7. 501-600 8. 601+ Now that is much better 🙂 Here is a real

Read more programming, Software Tips, Work

Select top 2 rows from records, grouped/partitioned by Unique ID

Leave a comment

The Problem: A client needed a query that selected the two most recent tour dates for each user ID. This is an easy task for a single user ID because specifying the user ID and an ORDER BY tour_date DESC with a LIMIT 2 clause would get the dates needed. However, when there are a lot of users it gets harder. For a single date, the MAX function works great but in our instance it will not work because we

Read more computer tips, programming, Software Tips, Work

Count occurrences both greater than, less than, or equal in MySQL

Leave a comment

  SELECT COUNT(recycled) AS “Total”, SUM(CASE WHEN recycled = 1 THEN 1 ELSE 0 END) AS “New”, SUM(CASE WHEN recycled > 1 THEN 1 ELSE 0 END) AS “Recycled” FROM (a SELECT phone_number, count(*) AS recycled, sale_date FROM ( SELECT DISTINCT * FROM ( SELECT customers.phone_number, customers.sale_date FROM customers INNER JOIN ( SELECT customers.phone_number FROM customers WHERE sale_date BETWEEN ‘2014-05-23’ AND ‘2014-05-30’) list on customers.phone_number = list.phone_number ORDER BY phone_number DESC, sale_date DESC ) AS multiple_sales ) AS sale_dates_analysis GROUP

Read more Software Tips, Work