mysql - #1005 - Can't create table, I looked at every single little thing in it...nothing -

mysql - #1005 - Can't create table, I looked at every single little thing in it...nothing -

this code:

create table phone ( id int not null auto_increment primary key, name varchar(15) not null, stock varchar(15) not null, fk_manufacturerid int not null, index (fk_manufacturerid), foreign key(fk_manufacturerid) references manufacturer (manufacturerid) on delete no action on update no action, fk_osid int not null, index (fk_osid), foreign key(fk_osid) references os (osid) on delete no action on update no action, photographic camera varchar(15) not null, handset varchar(15) not null, screen varchar(15) not null, connectivity varchar(15) not null, batterylife varchar(15) not null, memory varchar(15) not null, messaging varchar(15) not null, soundformat varchar(15) not null, cost int(5) not null, flag varchar(3) not null )engine=innodb

i'm newbie php (i hate it...a lot) , don't problem here...help me please :)

this question implies it's foreign key problem - have checked referenced tables , fields exist, , there's indexes need them? have @ question, might shed lite on similar-sounding problem.

mysql mysql-error-1005