B??dy w konsoli.

[NarixQ12]

Witam. Mam problem... Po w??czeniu otsa pokazuj? mi si? takie b??dy :

[14/01/2010 11:52:04] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'otserv.z_ots_comunication' doesn't exist (1146)
[14/01/2010 11:52:04] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[14/01/2010 11:52:35] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'otserv.z_ots_comunication' doesn't exist (1146)
[14/01/2010 11:53:05] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[14/01/2010 11:53:06] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'otserv.z_ots_comunication' doesn't exist (1146)
[14/01/2010 11:53:37] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'otserv.z_ots_comunication' doesn't exist (1146)
[14/01/2010 11:53:50] mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, 'Welcome to Ots'); - MYSQL ERROR: Duplicate entry '1-0' for key 1 (1062)

Mo?e kto? pom?c??

 

[CooKies]

Odp: B??dy w konsoli.

MYSQL ERROR: Table 'otserv.z_ots_comunication' doesn't exist (1146)

Przecie? wyra?nie Ci pisze ?e niema takiej tabeli w bazie danych! Musisz stworzy?.

 

[GM Koks]

Odp: B??dy w konsoli.

[14/01/2010 11:52:04] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'otserv.z_ots_comunication' doesn't exist (1146)


to znaczy ze zaimportowales z?? baze danych czyli nie ta kt?ra pasuje do silnika zmien baze a zadziala

 

[Xart Irok]

Odp: B??dy w konsoli.

Wejdzie do PMA w zak?adk? SQL i dodaj to:

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;

 

[Tairens]

Odp: B??dy w konsoli.

Przy instalacji G?siora powinno samo zaimportowa? tabele do bazy danych...

 

[viki1231993]

Odp: B??dy w konsoli.

Z?a baza danych zainportuj od nowa