Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB

[iker landajuela]

Hello, i have the same problem, I'm trying to create a dinamic menu system based on tables

Menu=menu level
Elementos_menu= menu elements in a menu level, a menu element can have another menu level
below.

#
# MENU 1:n-------> 1:1 ELEMENTOS_MENU
# ^ 1:1 |
# |_______________________|0:N
# tiene sub-elemento
#
#

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS menus;

CREATE TABLE menus (
id_menu INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
id_elemento_menu_padre INTEGER UNSIGNED NULL,INDEX (id_elemento_menu_padre),
descripcion VARCHAR(45) NULL,
tip VARCHAR(255) NULL,
texto VARCHAR(255) NULL,
PRIMARY KEY(id_menu),
FOREIGN KEY (id_elemento_menu_padre) REFERENCES elementos_menu(id_elemento_menu) ON DELETE CASCADE ON UPDATE CASCADE
)TYPE=InnoDB;


DROP TABLE IF EXISTS elementos_menu;

CREATE TABLE elementos_menu (
id_elemento_menu INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, INDEX (id_elemento_menu),
id_menu INTEGER UNSIGNED NOT NULL,INDEX (id_menu),
descripcion VARCHAR(45) NULL,
nom VARCHAR(250) NOT NULL,
img VARCHAR(250) NULL,
php VARCHAR(250) NULL,
pos INTEGER UNSIGNED NOT NULL,
PRIMARY KEY(id_elemento_menu),
CONSTRAINT FOREIGN KEY (id_menu) REFERENCES menus(id_menu) ON DELETE CASCADE ON UPDATE CASCADE
)TYPE=InnoDB;

Results:

Error Code : 1005
Can't create table '.\agritooldb\menus.frm' (errno: 150)
(93 ms taken)

(0 row(s) affected)
(0 ms taken)

Error Code : 1005
Can't create table '.\agritooldb\elementos_menu.frm' (errno: 150)
(79 ms taken)