• 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!

The forgotten server has stopped working, NEED HELP

B

bubblanfranck

New Member
Joined
Jun 17, 2011
Messages
51
Reaction score
1
Location
Sweden
Hello! I got this problem when im trying to start up my Theforgottenserver.exe, It says that theforgottenserver has stopped working. Im using "Cryingdamnson 0.3.6 (8.60) V8.2, and

Here's my database config
-- Database
-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
-- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "root"
sqlPass = "mypassword"
sqlDatabase = "forgottenserver"
sqlFile = "forgottenserver"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"


I also got another problem, yesterday it came up a sign that said "Not enough memory"
I got 16gb Ram and im using Windows 8 64bit.
Im also using Cinara Evolution mappen 23 377 kb (23 mb)

Rep++
 

Attachments

  • theforgottenerror.png
    theforgottenerror.png
    40.9 KB · Views: 64 · VirusTotal
Last edited:
Sort by date Sort by votes
Code: 
CREATE TABLE `tiles`
(
   `id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `house_id` INT UNSIGNED NOT NULL,
   `x` INT(5) UNSIGNED NOT NULL,
   `y` INT(5) UNSIGNED NOT NULL,
   `z` TINYINT(2) UNSIGNED NOT NULL,
   UNIQUE (`id`, `world_id`),
   KEY (`x`, `y`, `z`),
   FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;
 
Upvote 0 Downvote
Limos said:
Code: 
CREATE TABLE `tiles`
(
   `id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `house_id` INT UNSIGNED NOT NULL,
   `x` INT(5) UNSIGNED NOT NULL,
   `y` INT(5) UNSIGNED NOT NULL,
   `z` TINYINT(2) UNSIGNED NOT NULL,
   UNIQUE (`id`, `world_id`),
   KEY (`x`, `y`, `z`),
   FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;
Click to expand...
I replaced it at Centera > Schemas > mysql.sql but i still got the same problem, cant figure out what's wrong =/
 
Upvote 0 Downvote
Thx guys, that really helped me alot !

Btw, i got a question, what is this and how can i make it go away? ;d
(sorry for being noob, mysql is not my thing)

Everytime i login and out it's spamming this shit
 

Attachments

Last edited:
Upvote 0 Downvote
Code: 
CREATE TABLE `tile_items`
(
   `tile_id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `sid` INT NOT NULL,
   `pid` INT NOT NULL DEFAULT 0,
   `itemtype` INT NOT NULL,
   `count` INT NOT NULL DEFAULT 0,
   `attributes` BLOB NOT NULL,
   UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
   FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `bans`
(
   `id` INT UNSIGNED NOT NULL auto_increment,
   `type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
   `value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
   `param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
   `active` TINYINT(1) NOT NULL DEFAULT TRUE,
   `expires` INT NOT NULL,
   `added` INT UNSIGNED NOT NULL,
   `admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
   `comment` TEXT NOT NULL,
   `reason` INT UNSIGNED NOT NULL DEFAULT 0,
   `action` INT UNSIGNED NOT NULL DEFAULT 0,
   `statement` VARCHAR(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `type` (`type`, `value`),
   KEY `active` (`active`)
) ENGINE = InnoDB;


CREATE TABLE `player_depotitems`
(
   `player_id` INT NOT NULL,
   `sid` INT NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
   `pid` INT NOT NULL DEFAULT 0,
   `itemtype` INT NOT NULL,
   `count` INT NOT NULL DEFAULT 0,
   `attributes` BLOB NOT NULL,
   KEY (`player_id`), UNIQUE (`player_id`, `sid`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;


CREATE TABLE `z_ots_comunication` (
   `id` INT(11) NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(255) NOT NULL,
   `type` VARCHAR(255) NOT NULL,
   `action` VARCHAR(255) NOT NULL,
   `param1` VARCHAR(255) NOT NULL,
   `param2` VARCHAR(255) NOT NULL,
   `param3` VARCHAR(255) NOT NULL,
   `param4` VARCHAR(255) NOT NULL,
   `param5` VARCHAR(255) NOT NULL,
   `param6` VARCHAR(255) NOT NULL,
   `param7` VARCHAR(255) NOT NULL,
   `delete_it` INT(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
Upvote 0 Downvote
Limos said:
Code: 
CREATE TABLE `tile_items`
(
   `tile_id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `sid` INT NOT NULL,
   `pid` INT NOT NULL DEFAULT 0,
   `itemtype` INT NOT NULL,
   `count` INT NOT NULL DEFAULT 0,
   `attributes` BLOB NOT NULL,
   UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
   FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `bans`
(
   `id` INT UNSIGNED NOT NULL auto_increment,
   `type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
   `value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
   `param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
   `active` TINYINT(1) NOT NULL DEFAULT TRUE,
   `expires` INT NOT NULL,
   `added` INT UNSIGNED NOT NULL,
   `admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
   `comment` TEXT NOT NULL,
   `reason` INT UNSIGNED NOT NULL DEFAULT 0,
   `action` INT UNSIGNED NOT NULL DEFAULT 0,
   `statement` VARCHAR(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `type` (`type`, `value`),
   KEY `active` (`active`)
) ENGINE = InnoDB;


CREATE TABLE `player_depotitems`
(
   `player_id` INT NOT NULL,
   `sid` INT NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
   `pid` INT NOT NULL DEFAULT 0,
   `itemtype` INT NOT NULL,
   `count` INT NOT NULL DEFAULT 0,
   `attributes` BLOB NOT NULL,
   KEY (`player_id`), UNIQUE (`player_id`, `sid`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;


CREATE TABLE `z_ots_comunication` (
   `id` INT(11) NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(255) NOT NULL,
   `type` VARCHAR(255) NOT NULL,
   `action` VARCHAR(255) NOT NULL,
   `param1` VARCHAR(255) NOT NULL,
   `param2` VARCHAR(255) NOT NULL,
   `param3` VARCHAR(255) NOT NULL,
   `param4` VARCHAR(255) NOT NULL,
   `param5` VARCHAR(255) NOT NULL,
   `param6` VARCHAR(255) NOT NULL,
   `param7` VARCHAR(255) NOT NULL,
   `delete_it` INT(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Click to expand...
Omg, thx for all the help dude, really appreciate it!
 
Upvote 0 Downvote
Back
Top