Neil C. Obremski
  • About
  • Blog
  • Music
    • Moo
    • Necros
    • colbie
    • TravelEra
  • CPP
    • Multi Dimension Arrays and Pointer Pointers
    • Structures
  • Tech
    • ASP
    • Apache2 SSL Windows
    • Celery
    • Chromebook
    • Django
    • FFMPEG
    • IIS
    • JS >
      • Save Binary File to Disk in JavaScript
      • Simple JavaScript/AJAX Optimizations
    • Kindle Self-Publishing
    • Linux Shell
    • Mac OS X
    • QB
    • Pyodbc
    • SQL
    • Subversion for VSS Users
    • VSS
    • WinHttp
    • WSH
  • Games
    • Daggerfall
    • Minecraft
    • Thief >
      • Install Thief on 2000/XP
      • Run Thief without CD
      • Fix Thief Freeze
+1 (206) 795-1327

MySQL " Cannot add foreign key constraint" with VARCHAR

4/14/2015

 
This threw me for a loop today and I'm writing this partially for posterity and my own edification. Essentially what you have to check is the CHARSET of the tables, because there is a database default but each table can have its own. Thus if your database is utf8 (the usual) but your tables are latin1 (cp1252 West) then you will get the dreaded "Cannot add foreign key constraint".
Picture

Minecraft Forest Fire

4/10/2015

 
In building a sky bridge at a certain level, you run into hills and trees that need to be cleared out. This can take a while and so I found one of the more amusement methods is to drop a bucket of lava and let it burn ...
Burning Woods in Minecraft

Django + Pyodbc on Mac OS X

4/3/2015

 
  1. Clone https://github.com/neilobremski/django-pyodbc-azure to ~/django-pyodbc-azure
  2. export PYTHONPATH=~/django-pyodbc-azure:$PYTHONPATH
  3. Modify your settings.py (see below)
Picture

Read More

Clumpy

4/1/2015

 
Yesterday, March 31st:
"Remember Clippy?"
"Yeah, of course, that annoying paperclip."
"Right, so what if we made one like a donut. He'd show up on the website and say funny stuff. We could call him Clumpy."

Read More

Ambient Music Sex Appeal

3/30/2015

 
Apparently there is a swath of ambient music, at least albums containing Mitek tracks, associated with beaches and breasts.
Picture

Archiving PCT.guru

3/27/2015

0 Comments

 
Picture
0 Comments

Gradius

3/25/2015

0 Comments

 
Is this not some of the sexiest Nintendo box art you've ever seen?

Read More
0 Comments

Twitch.TV Email Addresses

3/24/2015

0 Comments

 
I got an email today that my Twitch.TV account may have been compromised. I never created an account there and I dimly recall messaging them about it before. I did so again and received an email that said: "Hi Neil Obremski, You seem to be having an issue with accessing your account." Gaugh! So then I had the brilliant idea of, since they don't verify email addresses properly, to sign up for an account using their email address ...

Read More
0 Comments

Connection Interrupted

3/20/2015

0 Comments

 
Me: "Uh oh, ConnectionInterrupted."
Jeff: "Read closer."
Me: "ConnectionInterrupted?"
Jeff: "Try again ..."
Picture

Read More
0 Comments

Creating Full Album MP3's from YouTube

3/19/2015

0 Comments

 
Recently I've been getting into listening to full albums rather than a lot of random tracks. I created a Python script to take a directory of MP3's and concatenate them into a single MP3 with the track name matching the album. However, sometimes it's hard to find the MP3's and there are actually a lot of full length albums on YouTube. Here is how I distill those into MP3 files ...

Read More
0 Comments
<<Previous

    Categories

    All
    Funny
    Games
    IAmYourUser
    Journal
    PCT
    Projects
    Random Observations
    Tech
    Write

    Archives

    April 2015
    March 2015
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    April 2014
    March 2014
    July 2013
    March 2013
    January 2012
    October 2011
    April 2010
    July 2009
    July 2007
    September 2000
    June 2000

    RSS Feed

Submit
Proudly powered by Weebly