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

SQLITE ERROR: no such table: tiles

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.
 
CREATE TABLE `tiles`
(
`id` INT NOT NULL AUTO_INCREMENT,
`x` INT NOT NULL,
`y` INT NOT NULL,
`z` INT NOT NULL,
PRIMARY KEY(`id`)
) ENGINE = InnoDB;
 
Back
Top