developer musician photographer

Friday, November 20, 2015

Solution to “search query is too long or complex” when creating a Twitter IFTTT Recipe

I was just setting up a new recipe and got this error: “search query is too long or complex”. 


I did a bunch of poking around and discovered that my IFTTT->Twitter integration was disconnected.


1. Go to

2. Click “Reconnect Channel”

3. You will see the Twitter auth form. Enter your twitter credentials and click Authorize app.


Then when you go back to creating your recipe you will see this:


Monday, November 2, 2015

ASP.NET WebHooks Preview Nuget Package Install Script

Truth be told – I haven’t done a lot of ASP.NET dev over the last couple of years, but since I do a good amount of maker projects that involve webhooks, I had to checkout the new ASP.NET WebHooks feature.

I went to install the Nuget packages recommended by this article and got this error:

Install-Package : Failed to add reference to 'System.IO'. Please make sure that it is in the Global Assembly Cache.

At C:\users\jong\documents\visual studio 2015\Projects\webhookstest1\nuget-install.ps1:2 char:1

+ Install-Package Microsoft.AspNet.WebHooks.Custom.AzureStorage -Includ ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     + CategoryInfo          : NotSpecified: (:) [Install-Package], Exception
     + FullyQualifiedErrorId : NuGetCmdletUnhandledException,NuGet.PackageManagement.PowerShellCmdlets.InstallPackageCommand

Install failed. Rolling back...

Package 'Microsoft.AspNet.DataProtection 1.0.0-beta6' does not exist in project 'webhookstest1'

It could have surfaced via the following exception as well:

Error    CS1061    'HttpConfiguration' does not contain a definition for 'InitializeCustomWebHooksAzureStorage' and no extension method 'InitializeCustomWebHooksAzureStorage' accepting a first argument of type 'HttpConfiguration' could be found (are you missing a using directive or an assembly reference?)    WebApplication4    c:\users\jong\documents\visual studio 2015\Projects\WebApplication4\WebApplication4\App_Start\WebApiConfig.cs    24

It looks like Microsoft.AspNet.DataProtection is also required.  I created a gist that includes all the dependencies you need.

Just copy that ps1 file to your solution folder and run it in the Package Manager Console

Hope this help


Wednesday, October 28, 2015

How to Update a Linked Table Schema in Access

Scenario: You have a SQL Server database and you edit that data using Access.  You make a schema change to the SQL Server table and you want that change to be reflected in Access.  It’s easy, yet unintuitive, so I wrote this post to help you out.

1. Make the change to your SQL Server Database Table.

2. Open Access, got to External Data –> Linked Table Manager


3. Select the table that you want to update and click OK


That’s all.  Simple, yet I expected an “Update” button of some sort.


Sunday, October 25, 2015

How to Setup a Particle Photon and a 16x2 LCD Screen

Hooking up a 16x2 LCD screen to a Particle Photon is pretty easy one you get it all wired up correctly and find the right library to use. I spent a bunch of time digging through forums to get this working, so I thought I’d do a quick post to save you some time.

You’ll need:

- Particle Photon

- 16 male to male jumper wires

- 1 Potentiometer

- 1 LCM1602C LCD Screen

1. Get the Photon pulsing cyan so you can push code to it from the Cloud IDE. See my other posts for instructions on how to get that setup.

2. Wire everything up like so:


3. Go to Particle Build and search for LiquidCrystal and then click the LIQUADCRYSTAL search result


4. Select the “Spark-HelloSparky.cpp” file


5. Click “Use this example”


That will create a new file called “spark-hellosparky.cpp”


and will reference the LiquidCrystal library


6. In spark-hellosparky.cpp change the following line

#include “LiquidCrystal.h”


#include “LiquidCrystal/LiquidCrystal.h”

7. Click the Flash button


That will deploy the code to your Photon and you should see “Hello, Sparky!” on your LCD.  If you don’t, then you will likely need to adjust the potentiometer until you do.


Hope this helps you out.


Saturday, October 24, 2015

HueyPro by Pantone doesn’t have a Windows 10 driver

I got some new monitors and went to go run my monitor color calibrator – HueyPro by Pantone – and saw that they didn’t have a Windows 10 driver.  I pinged them to see if they had one and got this response:

The HueyPRO was discontinued around 2011 so we are no longer providing any additional updates to the software.

I apologize for the inconvenience.

I then pinged my buddy Ron Martinsen ( to see if he got it working and this was his response:

Haven't tried as that software died long ago and the device doesn't support displays > sRGB so it's a dinosaur.

He also pointed me to this post:

It appears that I need to get a new monitor color calibrator.

Posting this now just in case someone else out there is looking for a Windows 10 driver for it.  Now you know it doesn’t exist and HueyPro doesn’t support robust color profiles.

Hope this help.