LogBlock

[Vencavajco]

Zdravím,
již 2 týdny mi laguje server a zjistil jsem, že to dělá LogBlock. Poté co jsem změnil Rcon heslo tak mi hází strašné chyby. Zkoušel jsem ho smazat, dát znova ale i tak se po 2 dnech opět vyhodí ta chyba. Kdyby někdo věděl co stim prosím poraďte karma jistá

Spoiler: zobrazit

> 18:38:43 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354030768), (SELECT playerid FROM `lb-players` WHERE playername = 'Nikita'), 0, 50, 5, '154', 12, '282');': Column 'playerid' cannot be null
> 18:38:43 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354030773), (SELECT playerid FROM `lb-players` WHERE playername = 'Nikita'), 1, 0, 0, '155', 16, '282');': Column 'playerid' cannot be null
> 18:38:43 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354030776), (SELECT playerid FROM `lb-players` WHERE playername = 'Nikita'), 50, 0, 5, '154', 12, '282');': Column 'playerid' cannot be null
> 18:38:44 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354030781), (SELECT playerid FROM `lb-players` WHERE playername = 'Nikita'), 0, 4, 0, '155', 12, '282');': Column 'playerid' cannot be null
> 18:38:44 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354030781), (SELECT playerid FROM `lb-players` WHERE playername = 'Nikita'), 0, 4, 0, '155', 13, '282');': Column 'playerid' cannot be null
> 18:38:44 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354030782), (SELECT playerid FROM `lb-players` WHERE playername = 'Nikita'), 0, 4, 0, '155', 14, '282');': Column 'playerid' cannot be null
> 18:38:44 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354030782), (SELECT playerid FROM `lb-players` WHERE playername = 'Nikita'), 0, 4, 0, '155', 15, '282');': Column 'playerid' cannot be null
> 18:38:44 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354030783), (SELECT playerid FROM `lb-players` WHERE playername = 'Nikita'), 0, 4, 0, '155', 16, '282');': Column 'playerid' cannot be null
> 18:38:44 [INFO] corida123 lost connection: disconnect.quitting
18:38:44 [INFO] Connection reset
> > 18:38:44 [INFO] Successfully imported queue-1354037813056-27.sql.
> 18:38:44 [INFO] Trying to import queue-1354037813056-29.sql ...
> 18:38:45 [INFO] [Hrac]PwnagePotato: a porad a porad lagy
> 18:38:46 [INFO] Successfully imported queue-1354037813056-29.sql.
> 18:38:46 [INFO] Trying to import queue-1354037813056-88.sql ...
> 18:38:46 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354034532), (SELECT playerid FROM `lb-players` WHERE playername = '20klarka02'), 11, 0, 10, '581', 55, '-1615');': Column 'playerid' cannot be null
> 18:38:46 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354034532), (SELECT playerid FROM `lb-players` WHERE playername = '20klarka02'), 0, 3, 0, '581', 55, '-1615');': Column 'playerid' cannot be null
> 18:38:46 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354034532), (SELECT playerid FROM `lb-players` WHERE playername = '20klarka02'), 10, 0, 2, '581', 56, '-1615');': Column 'playerid' cannot be null
> 18:38:46 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354034532), (SELECT playerid FROM `lb-players` WHERE playername = '20klarka02'), 0, 3, 0, '581', 56, '-1615');': Column 'playerid' cannot be null
> 18:38:46 [INFO] nick77 issued server command: /login ******
> 18:38:46 [INFO] [AuthMe] nick77 logged in!
> 18:38:46 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354034533), (SELECT playerid FROM `lb-players` WHERE playername = '20klarka02'), 3, 0, 0, '581', 56, '-1615');': Column 'playerid' cannot be null
> 18:38:46 [WARNING] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1354034533), (SELECT playerid FROM `lb-players` WHERE playername = '20klarka02'), 3, 0, 0, '581', 56, '-1615');': Column 'playerid' cannot be null

[PanadoL]

Dej si aktualizovanější verzi LogBlocku zkus to.. ==>http://dev.bukkit.org/server-mods/logblock/
A nebo si tam nahraj jíný plugin na zjištění zníčených/postavených blocků Tedy HawkEye...
----------------------------------------------------------------------------------------------------------------------
A nenahrával si tam nějaký plugin nebo dělal nějaké zmněny po kterých to začalo dělat?

[Vencavajco]

Nové verze jsem taky zkoušel a jak vidíš tak pořád nic.... A jediné co jsem dělal bylo prostě to, že jsem změnil Rcon heslo ale koukal jsem se a nikde na databzi nebo v LogBloku neni.

[Sejsel]

Problém je s tím, že někteří hráči nemají vygenerované ID v tabulce. Pokud se to děje jen u jednoho, zkus to tam ručně dopsat, pokud ne tak se podívej, jestli to třeba nepřesáhlo maximální velikost tabulky.

[Vencavajco]

Tak to přesně nevím co myslíš, jako v databázi???
A nedalo by se to vyřešit jinak?? Třeba smazat z databáze a napojit ho znova?

[Sejsel]

Ano, v databázi. Smazání to určitě napraví.