Help Please Lagging My Server up :(

[Ns Sparkz]

[25/01/2012 08:30:33] 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)

[25/01/2012 08:34: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)

[25/01/2012 08:29:49] Duplicate uniqueId 5911
[25/01/2012 08:29:56] Duplicate uniqueId 1000
[25/01/2012 08:29:56] Duplicate uniqueId 1000
[25/01/2012 08:29:58] Duplicate uniqueId 1001
[25/01/2012 08:29:58] Duplicate uniqueId 1000

 

[ChiSka]

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 AUTO_INCREMENT=3149 ;

 

[Ns Sparkz]

Still
[25/01/2012 08:37: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)

 

[Ninja]

[COLOR=#993333][B]ALTER[/B][/COLOR] [COLOR=#993333][B]TABLE[/B][/COLOR] [COLOR=#ff0000]`players`[/COLOR] [COLOR=#993333][B]ADD[/B][/COLOR] [COLOR=#ff0000]`onlinetime7`[/COLOR] [COLOR=#993333][B]INT[/B][/COLOR][COLOR=#66cc66]([/COLOR][COLOR=#cc66cc]11[/COLOR][COLOR=#66cc66])[/COLOR] [COLOR=#993333][B]DEFAULT[/B][/COLOR] [COLOR=#cc66cc]0[/COLOR]; [COLOR=#993333][B]
ALTER[/B][/COLOR] [COLOR=#993333][B]TABLE[/B][/COLOR] [COLOR=#ff0000]`players`[/COLOR] [COLOR=#993333][B]ADD[/B][/COLOR] [COLOR=#ff0000]`exphist7`[/COLOR] [COLOR=#993333][B]INT[/B][/COLOR][COLOR=#66cc66]([/COLOR][COLOR=#cc66cc]11[/COLOR][COLOR=#66cc66])[/COLOR] [COLOR=#993333][B]DEFAULT[/B][/COLOR] [COLOR=#cc66cc]0[/COLOR]; [COLOR=#993333][B]
ALTER[/B][/COLOR] [COLOR=#993333][B]TABLE[/B][/COLOR] [COLOR=#ff0000]`players`[/COLOR] [COLOR=#993333][B]ADD[/B][/COLOR] [COLOR=#ff0000]`onlinetimetoday`[/COLOR] [COLOR=#993333][B]INT[/B][/COLOR][COLOR=#66cc66]([/COLOR][COLOR=#cc66cc]11[/COLOR][COLOR=#66cc66])[/COLOR] [COLOR=#993333][B]DEFAULT[/B][/COLOR] [COLOR=#cc66cc]0[/COLOR];

 

[ChiSka]

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';

 

[Ns Sparkz]

[COLOR=#993333][B]ALTER[/B][/COLOR] [COLOR=#993333][B]TABLE[/B][/COLOR] [COLOR=#ff0000]`players`[/COLOR] [COLOR=#993333][B]ADD[/B][/COLOR] [COLOR=#ff0000]`onlinetime7`[/COLOR] [COLOR=#993333][B]INT[/B][/COLOR][COLOR=#66cc66]([/COLOR][COLOR=#cc66cc]11[/COLOR][COLOR=#66cc66])[/COLOR] [COLOR=#993333][B]DEFAULT[/B][/COLOR] [COLOR=#cc66cc]0[/COLOR]; [COLOR=#993333][B]
ALTER[/B][/COLOR] [COLOR=#993333][B]TABLE[/B][/COLOR] [COLOR=#ff0000]`players`[/COLOR] [COLOR=#993333][B]ADD[/B][/COLOR] [COLOR=#ff0000]`exphist7`[/COLOR] [COLOR=#993333][B]INT[/B][/COLOR][COLOR=#66cc66]([/COLOR][COLOR=#cc66cc]11[/COLOR][COLOR=#66cc66])[/COLOR] [COLOR=#993333][B]DEFAULT[/B][/COLOR] [COLOR=#cc66cc]0[/COLOR]; [COLOR=#993333][B]
ALTER[/B][/COLOR] [COLOR=#993333][B]TABLE[/B][/COLOR] [COLOR=#ff0000]`players`[/COLOR] [COLOR=#993333][B]ADD[/B][/COLOR] [COLOR=#ff0000]`onlinetimetoday`[/COLOR] [COLOR=#993333][B]INT[/B][/COLOR][COLOR=#66cc66]([/COLOR][COLOR=#cc66cc]11[/COLOR][COLOR=#66cc66])[/COLOR] [COLOR=#993333][B]DEFAULT[/B][/COLOR] [COLOR=#cc66cc]0[/COLOR];

Didnt work

 

[Ninja]

Try this then.

[COLOR=#000000] [COLOR=#0000BB]ALTER TABLE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]players[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]exphist_lastexp[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]exphist1[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]exphist2[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]exphist3[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]exphist4[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]exphist5[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]exphist6[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]exphist7[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]onlinetimetoday[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]onlinetime1[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]onlinetime2[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]onlinetime3[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]onlinetime4[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]onlinetime5[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]onlinetime6[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]onlinetime7[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
[/COLOR][COLOR=#0000BB]ADD [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]onlinetimeall[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]BIGINT[/COLOR][COLOR=#007700]( [/COLOR][COLOR=#0000BB]255 [/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700];  
[/COLOR] [/COLOR]

 [COLOR=#000000] [COLOR=#0000BB]UPDATE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]players[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]SET [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]exphist_lastexp[/COLOR][COLOR=#007700]`=`[/COLOR][COLOR=#DD0000]players[/COLOR][COLOR=#007700]`.`[/COLOR][COLOR=#DD0000]experience[/COLOR][COLOR=#007700]`  [/COLOR][/COLOR]

 

[Ns Sparkz]

Thank you Man !!!! Rep+ u.
Now
How to Fix?
25/01/2012 08:29:44] Duplicate uniqueId 2645
[25/01/2012 08:29:44] Duplicate uniqueId 2487
[25/01/2012 08:29:46] Duplicate uniqueId 32193
[25/01/2012 08:29:46] Duplicate uniqueId 32195

 

[Ns Sparkz]

Bump.!

 

[Ninja]

Are you really that desperate? Look into your action folder and search for those ID's. If there is multiple UID's then change it. Remember to change it on your map aswell.

 

[Ns Sparkz]

okay xD,Thank you