I am not enterely sure this post belongs here, but I’ll give it a try.

I am developing some code to integrate an ajax-chat into EE. For this purpose, I need to create 3 additional tables. One of them, ‘chatUsers’ is basically an extension of exp_members. This is how I set it up:

CREATE TABLE exp_chatUsers
(
userId INT(10) UNSIGNED NOT NULL,
role ENUM(‘AJAX_CHAT_GUEST’,‘AJAX_CHAT_SPEAKER’,‘AJAX_CHAT_USER’,‘AJAX_CHAT_MODERATOR’,‘AJAX_CHAT_ADMIN’) NOT NULL,
PRIMARY KEY (userId),
FOREIGN KEY (userId) REFERENCES exp_members (unique_id)
)
ENGINE = InnoDB;

I keep getting an error message “Can’t create table (errno 150)”. I have looked around, I just can’t find what might be wrong with this statement.  Does anyone have a suggestions?

-Franco

Moved to Howto by Moderator

furghella, this is beyond the scope of EE technical support, I’m going to move it to HowTo.

Hi Franco,

Where exactly are you running the SQL you have shown above to create the table? Are you using PHPMyAdmin or something else?

Best wishes,

Mark