Code:[11022011 003107] mysql_real_query() SELECT FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR Table 'otland.z_ots_comunication' doesn't exist (1146)
what is that o.o!
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;
[12/02/2011 08:56:20] mysql_real_query(): 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; - MYSQL ERROR: Unknown column 'exphist7' in 'field list' (1054)
[13/02/2011 13:52:34] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimeall' in 'field list' (1054)
plz help with this problem:
Code:ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0', ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';
[13/02/2011 20:34:24] 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)
[13/02/2011 20:34:26] mysql_real_query(): SELECT * FROM z_shut WHERE `id` = 1; - MYSQL ERROR: Table 'otland.z_shut' doesn't exist (1146)
[13/02/2011 20:34:26] [Error - GlobalEvent Interface]
[13/02/2011 20:34:27] data/globalevents/scripts/control.lua:onThink
[13/02/2011 20:34:27] Description:
[13/02/2011 20:34:27] data/lib/database.lua:100: [Result:free] Result not set!
[13/02/2011 20:34:27] stack traceback:
[13/02/2011 20:34:28] [C]: in function 'error'
[13/02/2011 20:34:28] data/lib/database.lua:100: in function 'free'
[13/02/2011 20:34:28] data/globalevents/scripts/control.lua:35: in function <data/globalevents/scripts/control.lua:17>
[13/02/2011 20:34:28] [Error - GlobalEvents::think] Couldn't execute event: safe_shutdown
how much exp should this server be?
1000x?
[Error - CreatureScript Inferface]
In a timer event called from:
buffernKill
Description:
(luaGetThingFromPos) Tile not Found