cant join ot..?

[Teddy]

Sometimes this error comes in console

[1:15:41.171] mysql_real_query(): INSERT INTO `player_storage` (`player_id`, `ke
y`, `value`) VALUES (672, 6076, '1'),(672, 8288, '12'),(672, 8289, '12'),(672, 8
290, '12'),(672, 8291, '12'),(672, 12900, '1'),(672, 20012, '-1'),(672, 22015, '
1'),(672, 22016, '1'),(672, 22025, '1'),(672, 22026, '1'),(672, 30001, '1'),(672
, 35700, '2'),(672, 36901, '1'),(672, 42300, '0'),(672, 42301, '0'),(672, 42302,
 '0'),(672, 42303, '0'),(672, 42304, '0'),(672, 42305, '0'),(672, 42306, '0'),(6
72, 42307, '0'),(672, 42308, '0'),(672, 42309, '0'),(672, 42310, '0'),(672, 4231
1, '0'),(672, 42312, '0'),(672, 42313, '0'),(672, 42314, '0'),(672, 42315, '0'),
(672, 42316, '0'),(672, 42317, '0'),(672, 42318, '0'),(672, 42319, '0'),(672, 42
320, '0'),(672, 42321, '0'),(672, 42322, '0'),(672, 42323, '0'),(672, 42324, '0'
),(672, 42325, '0'),(672, 42326, '0'),(672, 42327, '0'),(672, 42328, '0'),(672,
42329, '0'),(672, 42350, '0'),(672, 42352, '0'),(672, 42355, '0'),(672, 50016, '
1'),(672, 50017, '1'),(672, 50018, '1'),(672, 64154, '1'),(672, 64155, '1'),(672
, 95906, '12'),(672, 95910, '12'),(672, 95948, '12'),(672, 10001501, '524291'),(
672, 10001502, '851971') - MYSQL ERROR: Lost connection to MySQL server during q
uery (2013)

and player cant login after that (i need to restart to get it work)
can some help me ..
Rep++++

 

[Mestor]

You needing to importe one command in database, I writing from iphone right now, But i give it to you as fast i turning on My computer (maby in 3h~).

 

[Cykotitan]

You needing to importe one command in database, I writing from iphone right now, But i give it to you as fast i turning on My computer (maby in 3h~).

nope

 

[Mestor]

Try This

Put This in Database (Sql)

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'; 
UPDATE `players` SET `exphist_lastexp`=`players`.`experience`;

(If it dont work, Try make new database and load this sql BEFORE START SERVER ! )



Hope it works for you REP! ^_^

 

[Rexxar]

Put This in Database (Sql)

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'; 
UPDATE `players` SET `exphist_lastexp`=`players`.`experience`;

(If it dont work, Try make new database and load this sql BEFORE START SERVER ! )



Hope it works for you REP! ^_^

Umm... This SQL code is completely irrelevant to the problem at hand, all it does is clutter the `players` table with irrelevant information that not only increases the size of the database file but also makes the database slow and sluggish due to the data size.

The suggestion I can give is to check your config.lua, find:
sqlKeepAlive = 0
and change it to 1, see if it helps.