• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

MySQL Table missing - What Query to add?

Damon

Damon

Check my status to contact me :)
Joined
Mar 26, 2011
Messages
6,219
Solutions
1
Reaction score
2,038
Location
Germany
So I just installed ZnoteAAC and now when I start the server I am running into the following problem:
CqwqFfs.png

Anyone knows what to add in queries?

@Limos @HalfAway
 
Sort by date Sort by votes
Mera Mero said:
this forum looks dead without @Limos I hope you find your answer as soon as :(
Click to expand...
Thanks mate :) Well I am running my server with sqlite at the moment as it is in test phase anyway, however when I open it for the public i need to have this fixed (for mysql and znoteaac) so i hope someone will answer asap :)
 
Upvote 0 Downvote
Damon said:
Thanks mate :) Well I am running my server with sqlite at the moment as it is in test phase anyway, however when I open it for the public i need to have this fixed (for mysql and znoteaac) so i hope someone will answer asap :)
Click to expand...
Hmm did you try to search it on google? try to search and i'm sure that you will find the answer
EDIT i searched for your error and found some answers check it may help you
http://otland.net/threads/a-error-in-mine-database.118638/
http://otland.net/threads/forgotten-server-error.128961/
http://otland.net/threads/mysql-error.200267/
http://otland.net/threads/problem-with-znoteshop-lua.185124/
 
Upvote 0 Downvote
http://otland.net/threads/tiles-error.21659/
http://otland.net/threads/sqlite-error-no-such-table-tiles.221950/#post-2131559
second one should fix it
http://otland.net/threads/table-tiles-doesnt-exist.197113/#post-1898777

Limos said:
Code: 
CREATE TABLE "tiles" (
   "id" INTEGER NOT NULL,
   "world_id" INTEGER NOT NULL DEFAULT 0,
   "house_id" INTEGER NOT NULL,
   "x" INTEGER NOT NULL,
   "y" INTEGER NOT NULL,
   "z" INTEGER NOT NULL,
   UNIQUE ("id", "world_id"),
   FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id")
);
You can find other missing tables in schemas/sqlite.sql.

Next time descripe your problem in your title to avoid thread deletion, I edited it for you this time.
You also need to wait 24 hours to post after yourself in a thread.
Click to expand...
 
Upvote 0 Downvote
Upvote 0 Downvote
try this
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
o_O o_O said:
try this
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...
Now I am getting this error:
XOk9mJT.png


New errors just seem to pop up while none do in sqlite :/
 
Upvote 0 Downvote
this for bans
Code: 
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;
this for player items
Code: 
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;
 
Upvote 0 Downvote
o_O o_O said:
this for bans
Code: 
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;
this for player items
Code: 
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;
Click to expand...
Thanks alot this worked, however now im getting this error again:
http://otland.net/threads/z_ots_comunication.216200/
But the query there doesnt work and Limos solved it in pm :(

Additionally some globalevents error that never occured before did occur now :(
c56vEEQ.jpg
 
Upvote 0 Downvote
try this
Code: 
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;

http://otland.net/threads/from-z_ots_comunication.103311/
 
Upvote 0 Downvote
o_O o_O said:
try this
Code: 
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;

http://otland.net/threads/from-z_ots_comunication.103311/
Click to expand...
No new errors have been popping up since 15 minutes. Seems to work properly now :) Thanks a ton again!
 
Upvote 0 Downvote
try this
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;
 
Upvote 0 Downvote
Back
Top