Mysql and gesior guild problem

[Ashbringer]

Hey when i try to enter guilds on my website i got this error
Error message: Unknown column 'guilds.create_ip' in 'field list'

how do i fix it?
@Limos

please @Limos can u help me with this?

 

[Limos]

Which server do you use? is the gesior version for that server version?

 

[Ashbringer]

Which server do you use? is the gesior version for that server version?

yes it is , i use tfs 0.4 and right gesior version

+ when i drop it and try to re-create it right its something with forgein keys and
#1005 - Can't create table 'otserver.guilds' (errno: 150)

 

[Limos]

ALTER TABLE `guilds` ADD `create_ip` int(11) NOT NULL DEFAULT 0;

There is no need to delete/readd the table guilds.

 

[Ashbringer]

ALTER TABLE `guilds` ADD `create_ip` int(11) NOT NULL DEFAULT 0;

There is no need to delete/readd the table guilds.

thanks fixed now , but now i have this problem

Table 'otserver.guild_invites' doesn't exist

and i cant create it , it only says #1146 - Table 'otserver.guilds_invites' doesn't exist when i try to create it

 

[Limos]

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;

 

[Ashbringer]

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;

when i try that it says Table 'otserver.guild_invites' doesn't exist

 

[Limos]

Is the table added in the database? Did you restart your website?

 

[Ashbringer]

Is the table added in the database? Did you restart your website?

when i try to create the table guild_invites it says it allready exist but i dont exist ....

 

[Limos]

Try to drop it and create it again.

DROP TABLE IF EXISTS `guild_invites`;

 

[Ashbringer]

Try to drop it and create it again.

DROP TABLE IF EXISTS `guild_invites`;

then it says #2013 - Lost connection to MySQL server during query

 

[Ashbringer]

Try to drop it and create it again.

DROP TABLE IF EXISTS `guild_invites`;

i can make table with other name but not with guild_invites