please some body help with that bugs!

[Xei]

When i start SErver that shits apear i wanna know if they have effect on serv or not

[03/12/2009 20:41:30] Lua Script Error: [TalkAction Interface] 
[03/12/2009 20:41:30] data/talkactions/scripts/frags.lua

[03/12/2009 20:41:30] data/lib/function.lua:432: attempt to index local 'str' (a nil value)
[03/12/2009 20:41:30] [Warning - Event::loadScript] Cannot load script (data/talkactions/scripts/frags.lua)


[03/12/2009 20:41:30] Lua Script Error: [TalkAction Interface] 
[03/12/2009 20:41:30] data/talkactions/scripts/deathlist.lua

[03/12/2009 20:41:30] data/talkactions/scripts/deathlist.lua:2: attempt to perform arithmetic on a nil value
[03/12/2009 20:41:30] [Warning - Event::loadScript] Cannot load script (data/talkactions/scripts/deathlist.lua)


[03/12/2009 20:41:30] Lua Script Error: [TalkAction Interface] 
[03/12/2009 20:41:30] data/talkactions/scripts/serverinfo.lua

[03/12/2009 20:41:30] data/lib/function.lua:432: attempt to index local 'str' (a nil value)
[03/12/2009 20:41:30] [Warning - Event::loadScript] Cannot load script (data/talkactions/scripts/serverinfo.lua)


[03/12/2009 20:41:30] Lua Script Error: [TalkAction Interface] 
[03/12/2009 20:41:30] data/talkactions/scripts/commands.lua

[03/12/2009 20:41:30] data/lib/function.lua:432: attempt to index local 'str' (a nil value)
[03/12/2009 20:41:30] [Warning - Event::loadScript] Cannot load script (data/talkactions/scripts/commands.lua)


[03/12/2009 20:41:30] Lua Script Error: [TalkAction Interface] 
[03/12/2009 20:41:30] data/talkactions/scripts/deathlist.lua

[03/12/2009 20:41:30] data/talkactions/scripts/deathlist.lua:2: attempt to perform arithmetic on a nil value
[03/12/2009 20:41:30] [Warning - Event::loadScript] Cannot load script (data/talkactions/scripts/deathlist.lua)


[03/12/2009 20:41:30] Lua Script Error: [TalkAction Interface] 
[03/12/2009 20:41:30] data/talkactions/scripts/serverinfo.lua

[03/12/2009 20:41:30] data/lib/function.lua:432: attempt to index local 'str' (a nil value)
[03/12/2009 20:41:30] [Warning - Event::loadScript] Cannot load script (data/talkactions/scripts/serverinfo.lua)

AND AFTER SERVER WORKS..

[03/12/2009 20:42:31] mysql_real_query(): 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; - MYSQL ERROR: Unknown column 'onlinetime7' in 'field list' (1054)
[03/12/2009 20:42:31] 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)
[03/12/2009 20:42:31] 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)
[03/12/2009 20:43:32] 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)
[03/12/2009 20:44:33] 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)
[03/12/2009 20:45:34] 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)
[03/12/2009 20:46:35] 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)
[03/12/2009 20:47:36] 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)
[03/12/2009 20:48:37] 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)
[03/12/2009 20:49:38] 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)
[03/12/2009 20:50:39] 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)
[03/12/2009 20:51:40] 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)
[03/12/2009 20:52:41] 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)
[03/12/2009 20:53:43] 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)
[03/12/2009 20:54:43] 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)

PLEASE TELL ME what to do

 

[Aeron]

Try to delete onlinetimetoday column

 

[Xei]

from where i do that ?

 

[chauffaille]

import a new database.

 

[Xei]

Dont think so !

 

[Xei]

[04/12/2009 01:07:57] 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)

please Help Fixing That Bug I duno where to cancel that when server be on it always apear each 30 sec or something

 

[Chris]

ALTER TABLE `players` ADD COLUMN `onlinetimetoday` INT(11) NOT NULL DEFAULT '0';

 

[Xei]

where to add that ?!

 

[Chris]

In phpMyAdmin, through the query window.

 

[Xei]

I dOnt understand that phpmyadmin in the database site or from Data File ?

 

[Chris]

The database site (http://localhost/phpmyadmin), login to your user and locate the SQL image at your top-left corner.

Press it, copy the line I gave you in my earlier post, press the go button!

 

[Xei]

thanks alot

 

[Chris]

The pleasure is mine!

 

[Xei]

the problem happened Again lol And its Getting more crazy

[04/12/2009 05:49:09] 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)
[04/12/2009 05:50:10] 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)
[04/12/2009 05:51:11] 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)
[04/12/2009 05:52:12] 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)
[04/12/2009 05:53:13] 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)
[04/12/2009 05:54:14] 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)
[04/12/2009 05:55:15] 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)
[04/12/2009 05:56:16] 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)
[04/12/2009 05:57:17] 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)
[04/12/2009 05:58:18] 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)
[04/12/2009 05:59:19] 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)
[04/12/2009 06:00:20] 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)
[04/12/2009 06:01:21] 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)
[04/12/2009 06:02:22] 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)
[04/12/2009 06:03:23] 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)
[04/12/2009 06:04:24] 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)
[04/12/2009 06:05:25] 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)
[04/12/2009 06:06:26] 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)
[04/12/2009 06:07:27] 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)
[04/12/2009 06:08:28] 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)
[04/12/2009 06:09:29] 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)
[04/12/2009 06:10:30] 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)
[04/12/2009 06:11:31] 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)
[04/12/2009 06:12:32] 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)

 

[AchTung]

That's because you got missing queries in your database. Add them correctly since bugs makes always laggs xD

 

[Xei]

I duno How Too Add them :S

 

[Xei]

Please help !