Znote help

[matti450]

when i copy the text from localhost and want to paste it into the SQL this shows up

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`limit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

MySQL said:

#1005 - Can't create table 'tibia.znote_guild_wars' (errno: 150) (Details…)

 

[Hanozy]

Having the same problem, did you manage to fix it?

 

[Mariuskens]

hit with hammer ur pc ! xD

 

[StreamSide]

when i copy the text from localhost and want to paste it into the SQL this shows up

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`limit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

MySQL said:

#1005 - Can't create table 'tibia.znote_guild_wars' (errno: 150) (Details…)

just create another db

 

[Limos]

https://otland.net/threads/help-100...ote_guild_wars-errno-150.228687/#post-2203750