Bugs :s

[zayat]

mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 6 AND `world_id` = 0 - MYSQL ERROR: Table 'swev.house_lists' doesn't exist (1146)

mysql_real_query(): DELETE FROM `guild_invites` WHERE player_id = 24 - MYSQL ERROR: Table 'swev.guild_invites' doesn't exist (1146)

 

[TGYoshi]

If you read what the error says, you can simply see that two tables are not found in your database: house_lists and guild_invites.

 

[zayat]

How to add them??

 

[sn3ejk]

Add via phpmyadmin:

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;

CREATE TABLE `house_lists`
(
	`house_id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`listid` INT NOT NULL,
	`list` TEXT NOT NULL,
	UNIQUE (`house_id`, `world_id`, `listid`),
	FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;