mysql_real_query eror

[hioad]

Hello i'm haveing this problem and i need some help. i use tfs 0.4 Rev 3827

 [6:23:40.847] mysql_real_query(): INSERT INTO `guild_invites` (`player_id`, `gui
ld_id`) VALUES (36, 32) - MYSQL ERROR: Cannot add or update a child row: a forei
gn key constraint fails (`dc`.`guild_invites`, CONSTRAINT `guild_invites_ibfk_2`
 FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE) (1452)

Thanks

 

[Radium]

Same problem But on TFS 0.3.6pl1 BUMP!!!!

 

[president vankk]

DROP TABLE IF EXISTS `guild_invites`;

CREATE TABLE `guild_invites`
(
        `player_id` INT NOT NULL DEFAULT 0,
        `guild_id` INT NOT NULL DEFAULT 0,
        UNIQUE (`player_id`, `guild_id`),
        FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
        FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[Radium]

Did that, Still giving the errors. :/

 

[LucasFerraz]

Same to me


mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 1 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)
mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 6159667 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)