Phpmyadmin problems
Create table subcategory_events (
id_subcategory_events Tinyint NOT NULL AUTO_INCREMENT,
subcategory_name Varchar(50) NOT NULL,
id_subcategory Tinyint NOT NULL,
id_category Tinyint NOT NULL,
id_enterprise Bigint NOT NULL,
id_countries Tinyint NOT NULL,
Primary Key (id_subcategory_events,id_subcategory,id_category,id_enterprise,id_countries),
Index IX_is_divided_into_events (id_subcategory,id_countries,id_category,id_enterprise),
Constraint is_divided_into_events Foreign Key (id_subcategory,id_countries,id_category,id_enterprise) references subcategory (id_subcategory,id_countries,id_category,id_enterprise) on delete restrict on update restrict
) ENGINE = InnoDB
ROW_FORMAT = Default
COMMENT = 'Table of subcategories events associated with a category';
When i want to execute with my phpmyadmin, mysql gives me one error:
#1005 - Can't create table '.\3w\subcategory_events.frm' (errno: 150)
i have been search help and i have read that i have to create one temporary file for my mysql writing one command in my.ini file. i did it but my error continues.
how i can resolve my problem? is it my sql code or my phpmyadmin (2.0.6-pl2).My mysql is 4.1.7.
Thanks in advance
xavik

