MySQL (errno: 150)

Just quick note for anyone getting this error. It took me a little while to figure out.
In my case I was trying to add a foreign key with delete on cascade:

ALTER TABLE table_one
ADD CONSTRAINT name_fk FOREIGN KEY (iTable1ID)
EFERENCES table_two(iTable2ID) ON DELETE CASCADE;

And HeidiSQL was spitting out this error msg:

SQL Error: Can’t create table ‘.\database_name\#sql-72c_fb.frm’ (errno: 150)

How to resolve this error:
Make sure your fields datatype match.
They both should have exactly the same datatype and length.
Eg. INT(4) Unsigned isn’t the same as INT(11)

Also make sure if you have data in the table, the foreign keys will not fail.
Eg. If you have an value in one table and not in the other table, it will fail.

This may be common knowledge to most of you but it might come in handy to someone else.

3 comments January 17th, 2008

Sydney Flex and AIR Pre-Release Tour With Danny Dura

Chris just sent this event information to the flash developers mailing lists:

Thursday, 24th January. 6pm

Flex 3 and AIR are getting close to launch and in preparation, Danny Dura from the Platform Evangelism Team will be specifically in Sydney to show off the great new features for this exciting launch.

Check the listings below to hook up with the local user group in the city closest to you and join us for an evening of Flex and AIR.

Don’t miss out on the opportunity to see and hear about this highly anticipated release of Flex 3 and AIR during this special pre-release tour. Plus, in addition to giving away some one of a kind Flex/AIR branded schwag, each event will also be raffling off a copy of Flex Builder 3 Professional (pending availability) and a full commercial copy of CS3 Web Premium!

Details and RSVP on http://sydneyflashdev2008prelaunchtour.eventbrite.com

You can also joing the Google Group: FlashAussie

2 comments January 16th, 2008

Colin Moock is coming to Sydney

If you haven’t already heard, the date is set for 5th May, the same week as WebDU.

Update: WebDU dates are: 12-13 June 2008. (Thanks Geoff)

Register here: http://www.adobeas3tour.com/

Advanced programmers please note:
This course does not cover expert-level topics. You are unlikely to encounter new concepts in this course, but are welcome to attend for a refresher on ActionScript programming fundamentals.

For a complete list of topics covered, see the Course Outline below and the course lecture notes, available at: http://moock.org/lectures/groundUpAS3/

1 comment January 11th, 2008

Sydney Flash User Group - Last meeting of 2007

I just got back from the Sydney Flash User Group that was held at the Rocketboots office at Kent street.

According to the program we were going to view: Cairngorm 2.2 framework with Flex 3 and AIR (Adobe Integrated Runtime - formerly known as Apollo). We’ll be building a small/simple application to demonstrate the use of the Cairngorm 2.2 framework with Flex 3 beta and AIR Beta.

Due to time constraints, we didn’t finish the AIR integration and we all managed to debug Chris’ cairngorm timer.
We also talked a little about Singletons. Here is the link I mentioned about Grant Skinners AS3 implementation.

After that we had a “conference/presentation” by Grant Straker, that showed how to build quick applications using Zoom Flex
It was interesting to see the admin interface actually be targeted to developers, and how you generate your objects and classes by using regular forms. It also spits out all the source code of the flex app. I will definitely give it a try.

Then the lucky winner of the Adobe Software package was Robert. Congratulations mate!

Looking forward to having more meetings. Looks like then next one will be in February and the guys from infomedia might be showing us some of their flex stuff.

Here is a 16 second video that I took while Grant was presenting ShadoCMS:


3 comments December 3rd, 2007

New DDX Website

We have recently launched our company’s spanking new Flash website.
You can also create your own Mobile Video Blogging widget!

DDX Website (homepage)

I’ve created my mobile video blog here (you can see the link at the top of my blog), using the free widget from the DDX Website.

What is a Mobile Video Blog Widget?
It’s a Flash Component that you can put on any web page.When you create the widget a unique email is generated for you and you can send videos with your mobile phone to that email. The server will automatically convert the videos to FLV and publish them on your server. It’s pretty cool! Give it a try here: http://www.ddx.com.au/#/widgets/mobile-video-blog/

Add comment December 3rd, 2007

Next Posts Previous Posts


Calendar

December 2008
M T W T F S S
« May    
1234567
891011121314
15161718192021
22232425262728
293031  

From Google Reader

My Twitter


follow DanielTome at http://twitter.com

Categories

Currently Reading

Planned books:

None

Current books:

  • PHP Web 2.0 Mashup Projects

    PHP Web 2.0 Mashup Projects by Shu-Wai Chow

Recent books:

View full Library

Recommended

Links

Feeds

Mobile feed