- Error during executing SQL query:
CREATE TABLE [pms] (
`id` SERIAL,
`name` VARCHAR(255),
`content` TEXT,
`from` INT UNSIGNED NOT NULL,
`to` INT UNSIGNED NOT NULL,
`read` BOOLEAN DEFAULT FALSE,
`date_time` INT UNSIGNED,
PRIMARY KEY (`id`),
FOREIGN KEY (`from`) REFERENCES {players} (`id`) ON DELETE CASCADE,
FOREIGN KEY (`to`) REFERENCES {players} (`id`) ON DELETE CASCADE
) ENGINE = InnoDB CHARSET = utf8
returned:
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1005 Can't create table 'server.otscms_pms' (errno: 150)' in C:\xampplite\htdocs\otscms\classes\SQL_Base.php:95
Stack trace:
#0 C:\xampplite\htdocs\otscms\classes\SQL_Base.php(95): PDO->exec('CREATE TABLE `o...')
#1 C:\xampplite\htdocs\otscms\install.php(725): SQL_Base->exec('CREATE TABLE [p...')
#2 {main}
