MySQL Foreign Key and Errno 150

Just teaching myself a bit of MySQL and ran straight into a problem which seems to crop up a lot, but is answered less often:

I was trying to create a foreign key between two tables, referencing an integer id.  I tried writing the alter table statement myself, and also tried a couple of GUI tools.  No matter what I tried, I ran into Errno 150.

The solution turns out to be simple:  Make sure the data type of the FK and the referenced column are exactly the same.  In my case, I was trying to reference an unsigned int with a signed int.

Posted in blog | Tagged | Leave a comment

Finally Upgraded to PSN Plus

After much deliberation, I finally signed up for PSN Plus on the last day of their 20% promotion.

I wonder if I find the freebies worth my AUD$55/year?

I wonder if the added urgency of expiring licenses will motivate me to play?  Hasn’t worked in the first 12 hours.

Stay tuned…

Posted in blog | Tagged , , | Leave a comment

New Host

Just letting you know that SpikyTurtle.com has moved to a new host.

Posted in News | Leave a comment

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

Posted in Uncategorized | 1 Comment