I'm trying to instal
Profile 1.78 - Tom Foley's Social Networks Edition
I uploaded all files but when I try to install this is what I get


Unable to install profile. Error(s):


Installing User Profile

Can't create table 'my_database.x99f_profile_oauth_consumer_token' (errno: 150)




my sql for consumer token is


CREATE TABLE `profile_oauth_consumer_token` (
oct_id int(11) not null auto_increment,
oct_ocr_id_ref int(11) not null,
oct_usa_id_ref int(11) not null,
oct_name varchar(64) binary not null default '',
oct_token varchar(64) binary not null,
oct_token_secret varchar(64) binary not null,
oct_token_type enum('request','authorized','access'),
oct_token_ttl datetime not null default '9999-12-31',
oct_timestamp timestamp not null default current_timestamp,

primary key (oct_id),
unique key (oct_ocr_id_ref, oct_token),
unique key (oct_usa_id_ref, oct_ocr_id_ref, oct_token_type, oct_name),
key (oct_token_ttl),

foreign key (oct_ocr_id_ref) references oauth_consumer_registry (ocr_id)
on update cascade
on delete cascade

) engine=InnoDB default charset=utf8;





any sugestion?

Ok I found a fix for this
I installed original profile first them copied files from social profile did update and so far works fine
nice module thanks