guild error

[Amiroslo]

mysql_real_query(): SELECT `id` FROM `guild_invites` WHERE `player_id` = 34 AND `guild_id`= 1 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)

how to fix this?

 

[chojrak]

Add field `id` ;p

 

[Amiroslo]

??

Add field `id`

in sql?

just that

 

[chojrak]

Nop, I just told you to add field called 'id' in guild_invites table.

 

[Amiroslo]

how?
can u help me with that

 

[bolero]

Maybe you can remove all guild with

DROP TABLE guilds;

and after execute this:

CREATE TABLE `guilds`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`name` VARCHAR(255) NOT NULL,
	`ownerid` INT NOT NULL,
	`creationdata` INT NOT NULL,
	`motd` VARCHAR(255) NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE (`name`, `world_id`)
) ENGINE = InnoDB;

 

[Amiroslo]

ok ty

 

[hon]

Did that work?

 

[Cykotitan]

obviously not