42
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?
