• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

modern acc error.

Joined
Sep 24, 2012
Messages
605
Reaction score
33
Location
Netherlands
when i try to add a table to the db i get this error.

Code:
#1005 - Can't create table 'zilvera.posts' (errno: 150) (<a href="server_engines.php?engine=InnoDB&amp;page=Status&amp;token=99d9da43a54eddcdc9bd0cfca662a9d8">Details...</a>)

and im using this code to make it...

Code:
CREATE TABLE IF NOT EXISTS `posts` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(120) ,
  `text` text,
  `time` INT(11),
  `author` VARCHAR(64),
  `board_id` INT(11),
  `thread_id` INT(11),
  PRIMARY KEY (`id`),
  FOREIGN KEY (`board_id`) REFERENCES `forums` (`id`) ON DELETE CASCADE,
  FOREIGN KEY (`thread_id`) REFERENCES `threads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


does anyone see the problem?
 
Back
Top