Mysql_real_query Problem

[elxcheko]

This is the error I have:

mysql_real_query(): SELECT `house_id`, `player_id`, `bid` FROM `house_auctions` WHERE `endtime` < 1276562295 - MYSQL ERROR: Table 'paradise.house_auctions' doesn't exist (1146)


PLEASE HELP ME, I'll give repp+

 

[Kavvson]

Create a table house_auctions.

CREATE TABLE `house_auctions`
(
    `house_id` INT UNSIGNED NOT NULL,
    `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
    `player_id` INT NOT NULL,
    `bid` INT UNSIGNED NOT NULL DEFAULT 0,
    `limit` INT UNSIGNED NOT NULL DEFAULT 0,
    `endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
    UNIQUE (`house_id`, `world_id`),
    FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE,
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[elxcheko]

Create a table house_auctions.

CREATE TABLE `house_auctions`
(
    `house_id` INT UNSIGNED NOT NULL,
    `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
    `player_id` INT NOT NULL,
    `bid` INT UNSIGNED NOT NULL DEFAULT 0,
    `limit` INT UNSIGNED NOT NULL DEFAULT 0,
    `endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
    UNIQUE (`house_id`, `world_id`),
    FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE,
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

It doesnt works :S:

#1005 - Can't create table 'paradise.house_auctions' (errno: 150)

 

[elxcheko]

nobody else can help me? D:

 

[LucasFerraz]

Same to me, can some1 help?


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)