Bom galera, baixei um servidor e quando fui abrir, me deparei com isso:
 

1º:
 

[02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetime6 (UPDATE "players" SET "onlinetime7"=players.onlinetime6, "onlinetime6"=players.onlinetime5, "onlinetime5"=players.onlinetime4, "onlinetime4"=players.onlinetime3, "onlinetime3"=players.onlinetime2, "onlinetime2"=players.onlinetime1, "onlinetime1"=players.onlinetimetoday, "onlinetimetoday"=0;)
[02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist6 (UPDATE "players" SET "exphist7"=players.exphist6, "exphist6"=players.exphist5, "exphist5"=players.exphist4, "exphist4"=players.exphist3, "exphist3"=players.exphist2, "exphist2"=players.exphist1, "exphist1"=players.experience-players.exphist_lastexp, "exphist_lastexp"=players.experience;)
[02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:08:51] sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique

2º

[02/07/2014 20:09:25] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:09:26] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:09:57] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:10:26] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:10:28] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:10:59] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:11:27] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:11:30] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:12:01] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:12:28] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:12:32] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:13:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:13:29] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:13:34] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:14:05] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:14:30] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:14:36] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:15:07] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:15:31] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:15:38] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:16:09] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[02/07/2014 20:16:32] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[02/07/2014 20:16:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)

Alguém tem ideia de como faço para arrumar?

CREATE TABLE "z_ots_comunication" (
"id" INTEGER 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" INTEGER NOT NULL default "1",
PRIMARY KEY ("id")
)

ALTER TABLE "players" ADD "exphist_lastexp" BIGINT NOT NULL DEFAULT '0',
ADD "exphist1" BIGINT NOT NULL DEFAULT '0',
ADD "exphist2" BIGINT NOT NULL DEFAULT '0',
ADD "exphist3" BIGINT NOT NULL DEFAULT '0',
ADD "exphist4" BIGINT NOT NULL DEFAULT '0',
ADD "exphist5" BIGINT NOT NULL DEFAULT '0',
ADD "exphist6" BIGINT NOT NULL DEFAULT '0',
ADD "exphist7" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetimetoday" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime1" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime2" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime3" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime4" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime5" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime6" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime7" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetimeall" BIGINT NOT NULL DEFAULT '0';

Editado Julho 2, 2014 10 anos por Rusherzin (veja o histórico de edições)

O primeiro deu esse erro quando apertei F9:

 Error while executing query: near "auto_increment": syntax error
<simple query executor>

E o segundo esse:

 Error while executing query: near ",": syntax error
<simple query executor>

Foi mal..

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `login` 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`)
);

Ainda ta dando esse erro:

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetime6 (UPDATE "players" SET "onlinetime7"=players.onlinetime6, "onlinetime6"=players.onlinetime5, "onlinetime5"=players.onlinetime4, "onlinetime4"=players.onlinetime3, "onlinetime3"=players.onlinetime2, "onlinetime2"=players.onlinetime1, "onlinetime1"=players.onlinetimetoday, "onlinetimetoday"=0;)
OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist6 (UPDATE "players" SET "exphist7"=players.exphist6, "exphist6"=players.exphist5, "exphist5"=players.exphist4, "exphist4"=players.exphist3, "exphist3"=players.exphist2, "exphist2"=players.exphist1, "exphist1"=players.experience-players.exphist_lastexp, "exphist_lastexp"=players.experience;)
OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique
~~GOD Dii~~ has logged in.
Error during getDataInt(auction_balance).
OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)

 OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)