• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Server Error

Status
Not open for further replies.
Sort by date Sort by votes
Please post a bigger image, can't see the text in console.
This could be some missing tables.
 
Upvote 0 Downvote
SQL: 
CREATE TABLE `player_statements`
(
    `id` INT NOT NULL AUTO_INCREMENT,
    `player_id` INT NOT NULL,
    `channel_id` INT NOT NULL DEFAULT 0,
    `text` VARCHAR (255) NOT NULL,
    `date` BIGINT NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`), KEY (`player_id`), KEY (`channel_id`),
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `market_history` 
(
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, 
    `player_id` INT NOT NULL, 
    `sale` TINYINT(1) NOT NULL DEFAULT 0, 
    `itemtype` INT UNSIGNED NOT NULL, 
    `amount` SMALLINT UNSIGNED NOT NULL, 
    `price` INT UNSIGNED NOT NULL DEFAULT 0, 
    `expires_at` BIGINT UNSIGNED NOT NULL, 
    `inserted` BIGINT UNSIGNED NOT NULL, 
    `state` TINYINT(1) UNSIGNED NOT NULL, 
    PRIMARY KEY(`id`), KEY(`player_id`, `sale`), 
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `market_offers` 
(
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, 
    `player_id` INT NOT NULL, 
    `sale` TINYINT(1) NOT NULL DEFAULT 0, 
    `itemtype` INT UNSIGNED NOT NULL, 
    `amount` SMALLINT UNSIGNED NOT NULL, 
    `created` BIGINT UNSIGNED NOT NULL, 
    `anonymous` TINYINT(1) NOT NULL DEFAULT 0, 
    `price` INT UNSIGNED NOT NULL DEFAULT 0, 
    PRIMARY KEY (`id`), KEY(`sale`, `itemtype`), KEY(`created`), 
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
 
Upvote 0 Downvote
Lol ? is it illegal for asking for help ;SS`? srsly all is helping each other... i just ask for 1 thing lols! and why are u mad? what did i do with you ?
 
Upvote 0 Downvote
The thread he created 3 hours before this one were about 0.3.7 but he could have changed though. :p
 
Upvote 0 Downvote
Status
Not open for further replies.
Back
Top