Quick tip: Mysql ERROR 1005

ERROR 1005 (HY000) at line 296: Can't create table './debradb/comment.frm' (errno: 150)

check what is going on by passing this sql command to mysql command line:

SHOW ENGINE INNODB STATUS;

and next look for error ;). In most case errors are made by

• incorrect data types and flags for primary key and foreign keys


• lack of primary key, in innodb your relation have to contain primary key


• all relation have to be the same type. In default installation of mysql set as default engine myisam

Quick tip: Display raw html

How to display raw html

Simple, if you generate scaffold, edit show.html.erb and remove h

<%=h @static.content %>

after that, @static.content would be display without html escape. It's very useful if you add
to you application some static pages managed from control panel and contains raw html.