Error 1461

Discussion in 'Support' started by roarnesbo, Apr 6, 2013.

  1. roarnesbo

    roarnesbo Member

    Joined:
    Dec 8, 2012
    Messages:
    56
    Likes Received:
    0
    (Copy paste from DayZCC.tk forums)


    Hello. To start with I'd like to point out that yes, I did search the forums first, and yes I found some threads about this.

    I know Crosire stopped development of this great piece of software, but I hope someone can help me with my issue. We are very satisfied with DayZCC, and would hate to move on to another server pack.

    Anyways, this is the error:

    Code:
    11:33:01 Database(1): [Error] Error 1461 (Can't create more than max_prepared_stmt_count statements (current value: 16382)) in MySQLStmtPrepare SQL: 'update `survivor` s set s.`backpack` = '[\"DZ_Backpack_EP1\",[[],[]],[[],[]]]' , s.`inventory` = '[[\"ItemFlashlight\",\"ItemWatch\",\"ItemToolbox\",\"ItemMap\",\"ItemKnife\",\"ItemHatchet\",\"glock17_EP1\",\"ItemFlashlightRed\",\"ItemEtool\",\"ItemCompass\",\"ItemMatchbox\",\"Binocular\",\"M4A1_HWS_GL\"],[[\"30Rnd_556x45_Stanag\",24],\"30Rnd_556x45_Stanag\",\"30Rnd_556x45_Stanag\",\"30Rnd_556x45_Stanag\",\"30Rnd_556x45_Stanag\",\"30Rnd_556x45_Stanag\",\"30Rnd_556x45_Stanag\",\"ItemBandage\",\"ItemBandage\",\"15Rnd_9x19_M9\",\"15Rnd_9x19_M9\",\"15Rnd_9x19_M9\",\"15Rnd_9x19_M9\",\"15Rnd_9x19_M9\",\"15Rnd_9x19_M9\"]]' , s.`state` = '[\"M4A1_HWS_GL\",\"amovpercmstpsraswrfldnon_ainvpknlmstpslaywrfldnon\",42]' where s.`id` = ?'
    11:33:01 HiveExt(0): [Information] Metho

    What it does is that it rolls back all players (not vehicles or tent or anything else). No player info gets saved to the database, and sometimes people gets rolled back like 2 hours.

    If someone thats still around can help, I would really appreciate it!
     

Share This Page