|
|
#111
11.11.2014, 20:43
|
||||
|
||||
Context info for the following error/warning:
Error: 1024, Write multi-query failed (1): CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','artefact','quest','goldcoins' ,'clan','npc','nolib','nodamage','retired','diamon dcoins','active','sell4gold','binded','nodurable') NOT NULL default '' ) TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `fld`+0 FROM `cnv` WHERE `id`=1); DROP TEMPORARY TABLE `cnv` With result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `f' at line 4 in /var/www/haddan/core/library/db_fns.php, 329 Backtrace: { file: /var/www/haddan/core/library/db_fns.php, 329 call: trigger_error("Write multi-query failed (1): CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','ar...") file: /var/www/haddan/core/library/db_fns.php, 305 call: db_trigger_error("Write multi-query failed (1): CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','ar...", "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use...", 256) file: /var/www/haddan/core/library/BonReq.php, 619 call: db_multiquery_write("CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','artefact','quest','goldcoins' ,'clan'...") file: /var/www/haddan/core/library/BonReq.php(48) : eval()'d code, 1 call: BRBase::make_sql_set("goldcoins", "thingtype", "tflags") file: /var/www/haddan/core/library/BonReq.php, 48 call: eval() file: /var/www/haddan/core/library/BonReq.php, 940 call: BRBase::_getVal(" file: /var/www/haddan/core/library/BonReq.php, 1467 call: Bon->_initFromString("filter.flags: file: /var/www/haddan/core/library/BonReq.php, 1448 call: Bon::_initBonuses("x.fixedprices: 1; filter.flags: filter.type: 'wear_necklace...", Array(1)) file: /var/www/haddan/core/library/BonReq.php, 1601 call: Bon::_initBonusesEx("x.fixedprices: 1; filter.flags: filter.type: 'wear_necklace...", Array(1)) file: /var/www/haddan/core/library/BonReq.php, 1575 call: BonReqs->initFromArray(Array(13), Null) file: /var/www/haddan/core/roomfunc/shop_helper.php, 92 call: BonReqs::createFromArray(Array(13), "UPDATE `shop_dpt` SET `brcache`='%CACHE%' WHERE `dptid`='28'") file: /var/www/haddan/core/roomfunc/shop_helper.php, 202 call: shopDptSelect(-1, 28, Array(7), False) file: /var/www/htdocs/room/func/shop.php, 39 call: shopMain(Array(7)) } Locals: Array ( [querytext] => Write multi-query failed (1): CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','artefact','quest','goldcoins' ,'clan','npc','nolib','nodamage','retired','diamon dcoins','active','sell4gold','binded','nodurable') NOT NULL default '' ) TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `fld`+0 FROM `cnv` WHERE `id`=1); DROP TEMPORARY TABLE `cnv` [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `f' at line 4 [type] => 256 ) Context info for the following error/warning: Error: 256, Write multi-query failed (1): CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','artefact','quest','goldcoins' ,'clan','npc','nolib','nodamage','retired','diamon dcoins','active','sell4gold','binded','nodurable') NOT NULL default '' ) TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `fld`+0 FROM `cnv` WHERE `id`=1); DROP TEMPORARY TABLE `cnv` With result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `f' at line 4 in /var/www/haddan/core/library/db_fns.php, 332 Backtrace: { file: /var/www/haddan/core/library/db_fns.php, 332 call: trigger_error("Write multi-query failed (1): CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','ar...", 256) file: /var/www/haddan/core/library/db_fns.php, 305 call: db_trigger_error("Write multi-query failed (1): CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','ar...", "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use...", 256) file: /var/www/haddan/core/library/BonReq.php, 619 call: db_multiquery_write("CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','artefact','quest','goldcoins' ,'clan'...") file: /var/www/haddan/core/library/BonReq.php(48) : eval()'d code, 1 call: BRBase::make_sql_set("goldcoins", "thingtype", "tflags") file: /var/www/haddan/core/library/BonReq.php, 48 call: eval() file: /var/www/haddan/core/library/BonReq.php, 940 call: BRBase::_getVal(" file: /var/www/haddan/core/library/BonReq.php, 1467 call: Bon->_initFromString("filter.flags: file: /var/www/haddan/core/library/BonReq.php, 1448 call: Bon::_initBonuses("x.fixedprices: 1; filter.flags: filter.type: 'wear_necklace...", Array(1)) file: /var/www/haddan/core/library/BonReq.php, 1601 call: Bon::_initBonusesEx("x.fixedprices: 1; filter.flags: filter.type: 'wear_necklace...", Array(1)) file: /var/www/haddan/core/library/BonReq.php, 1575 call: BonReqs->initFromArray(Array(13), Null) file: /var/www/haddan/core/roomfunc/shop_helper.php, 92 call: BonReqs::createFromArray(Array(13), "UPDATE `shop_dpt` SET `brcache`='%CACHE%' WHERE `dptid`='28'") file: /var/www/haddan/core/roomfunc/shop_helper.php, 202 call: shopDptSelect(-1, 28, Array(7), False) file: /var/www/htdocs/room/func/shop.php, 39 call: shopMain(Array(7)) } Locals: Array ( [querytext] => Write multi-query failed (1): CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','artefact','quest','goldcoins' ,'clan','npc','nolib','nodamage','retired','diamon dcoins','active','sell4gold','binded','nodurable') NOT NULL default '' ) TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `fld`+0 FROM `cnv` WHERE `id`=1); DROP TEMPORARY TABLE `cnv` [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `f' at line 4 [type] => 256 ) Когда у али жмёшь раритеты 
|
|
#112
11.11.2014, 21:34
|
|||
|
|||
|
Context info for the following error/warning:
Error: 8, String offset cast occurred in /var/www/haddan/core/library/magicfunc.php, 1303 Backtrace: { file: /var/www/haddan/core/library/magicfunc.php, 1374 call: MagicFunc::lab_changemap(Object(Room), Object(Room), Object(Person)) file: , call: MagicFunc::lab_onEnter(Object(Room), Object(Room), Object(Person), Array(1), Array(1)) file: /var/www/htdocs/room/room.php, 247 call: call_user_func_array(Array(2), Array(5)) file: /var/www/htdocs/room/room.php, 375 call: changeRoomEx(Object(Room), Object(Person), Array(1)) } Locals: Array ( [roomOld] => Room Object ( [id] => 18546688 [name] => Древние Руины [name_from] => от Древних Руин [name_to] => к Древним Руинам [br] => BonReqs Object ( [b] => Array ( [go] => Array ( [square] => 8398867 [global] => Array ( [roomid] => 8398867 [name] => Окрестности Старограда: Восток [name_to] => К окрестностям Старограда [name_from] => из Окрестностей Старограда ) пошёл тестить изменение в лаб
__________________
Мне лень я пацан один три три семь
|
|
#113
11.11.2014, 21:36
|
|||
|
|||
|
Дайте денег норм Изменщика потестить)
|
|
#114
11.11.2014, 21:38
|
|||
|
|||
|
Цитата:
денег критично не хватает +
__________________
Мне лень я пацан один три три семь
|
|
#115
11.11.2014, 22:02
|
||||
|
||||
|
пока остановил сервер, разберемся щас с кодировкой
__________________
Мне, как ГД, все равно какой класс в ПвП рулит. Мне нужно чтобы все классы были одинаковыми сливами. (c) Самый вредный из людей Геймдизайнер - он злодей. Вот балансер гнусный - Жаль что он не вкусный!
|
|
#116
11.11.2014, 22:03
|
||||
|
||||
|
Не могу вообще зайти на тестовый сервак
Context info for the following error/warning: Error: 256, Read query failed: SELECT /*wear*/ t.`thingid`, t.`flags`+0 AS `flags`, t.`madein`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, t.thingtypeid, UNIX_TIMESTAMP(t.`till`) as `till`, t.`durr`, t.`durc`, t.`durc1`, t.`durc2`, t.`durc3`, t.`note`, t.`creatorid`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, t.`madein`, t.`clan`, t.`runes`, t.`enchantid`, t.`enchanttill`, t.`addBon` FROM thing t /*LEFT JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/ WHERE t.thingid IN(156107039,636360474,326564316,310986135,6403105 46,550588504,635632988,635647665,635635998,6356450 93,635642249,635639405,635629893,611874796,6343600 38,634360103,634360152,634360137) AND place='inv' AND placeid=0 AND t.userid=21965 UNION ALL SELECT t.`thingid`, t.`flags`+0 AS `flags`, t.`madein`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, t.thingtypeid, UNIX_TIMESTAMP(t.`till`) as `till`, t.`durr`, t.`durc`, t.`durc1`, t.`durc2`, t.`durc3`, t.`note`, t.`creatorid`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, t.`madein`, t.`clan`, t.`runes`, t.`enchantid`, t.`enchanttill`, t.`addBon` FROM thing t /*LEFT JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/ WHERE t.thingtypeid IN(7372,7373,7374,7916,7917,7918,8021,6,8222,8223, 8224,8342,8344,9125,10102,10941,10942,10943,8410,8 411,8412,8413,8414,8420,8421,8422,8423,8424,8430,8 431,8432,8433,8434,8440,8441,8442,8443,8444,8474,8 510,11302,11303,11304,11305,11306,11307,11308,1130 9,11310,11312,11313,11314,11315,11316,11317,11318, 8610,11383,11384,11385,9281,8620,8621,8622,8623,86 24,8625,8626,8627,8628,8629,8630,8631,8632,8633,86 34,8640,8641,8642,8643,8644,8650,8651,8652,8653,86 54,8669,12045,12052,12390,9286,12906) AND place='inv' AND placeid=0 AND t.userid=21965 AND FIND_IN_SET('gift', t.flags) With result: Table './haddan/thing' is marked as crashed and last (automatic?) repair failed in /var/www/haddan/core/library/db_fns.php, 332 Backtrace: { file: /var/www/haddan/core/library/db_fns.php, 332 call: trigger_error("Read query failed: SELECT /*wear*/ t.`thingid`, t.`flags`+0 AS `flags`, t.`madein`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, ...", 256) file: /var/www/haddan/core/library/db_fns.php, 201 call: db_trigger_error("Read query failed: SELECT /*wear*/ t.`thingid`, t.`flags`+0 AS `flags`, t.`madein`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, ...", "Table './haddan/thing' is marked as crashed and last (automatic?) repair failed", 256) file: /var/www/haddan/core/library/Wear.php, 138 call: db_query_read("SELECT /*wear*/ t.`thingid`, t.`flags`+0 AS `flags`, t.`madein`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, t.thingtypeid, UNIX_TI...") file: /var/www/haddan/core/library/Wear.php, 65 call: Wear->_initFromDBAndArray(Array(101), Array(2)) file: /var/www/haddan/core/library/Person.php, 298 call: Wear::initFromArrayEx(Array(101), Array(2)) file: /var/www/haddan/core/library/Person.php, 482 call: Person->createCaches(Array(101), Array(2)) file: /var/www/haddan/core/library/Person.php, 950 call: Person->initFromArrayEx(Array(101), Array(2)) file: /var/www/htdocs/main.php, 54 call: Person->initFromSessionEx(Array(2)) } Locals: Array ( [querytext] => Read query failed: SELECT /*wear*/ t.`thingid`, t.`flags`+0 AS `flags`, t.`madein`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, t.thingtypeid, UNIX_TIMESTAMP(t.`till`) as `till`, t.`durr`, t.`durc`, t.`durc1`, t.`durc2`, t.`durc3`, t.`note`, t.`creatorid`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, t.`madein`, t.`clan`, t.`runes`, t.`enchantid`, t.`enchanttill`, t.`addBon` FROM thing t /*LEFT JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/ WHERE t.thingid IN(156107039,636360474,326564316,310986135,6403105 46,550588504,635632988,635647665,635635998,6356450 93,635642249,635639405,635629893,611874796,6343600 38,634360103,634360152,634360137) AND place='inv' AND placeid=0 AND t.userid=21965 UNION ALL SELECT t.`thingid`, t.`flags`+0 AS `flags`, t.`madein`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, t.thingtypeid, UNIX_TIMESTAMP(t.`till`) as `till`, t.`durr`, t.`durc`, t.`durc1`, t.`durc2`, t.`durc3`, t.`note`, t.`creatorid`, UNIX_TIMESTAMP(t.`madeat`) AS `madeat`, t.`madein`, t.`clan`, t.`runes`, t.`enchantid`, t.`enchanttill`, t.`addBon` FROM thing t /*LEFT JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/ WHERE t.thingtypeid IN(7372,7373,7374,7916,7917,7918,8021,6,8222,8223, 8224,8342,8344,9125,10102,10941,10942,10943,8410,8 411,8412,8413,8414,8420,8421,8422,8423,8424,8430,8 431,8432,8433,8434,8440,8441,8442,8443,8444,8474,8 510,11302,11303,11304,11305,11306,11307,11308,1130 9,11310,11312,11313,11314,11315,11316,11317,11318, 8610,11383,11384,11385,9281,8620,8621,8622,8623,86 24,8625,8626,8627,8628,8629,8630,8631,8632,8633,86 34,8640,8641,8642,8643,8644,8650,8651,8652,8653,86 54,8669,12045,12052,12390,9286,12906) AND place='inv' AND placeid=0 AND t.userid=21965 AND FIND_IN_SET('gift', t.flags) [error] => Table './haddan/thing' is marked as crashed and last (automatic?) repair failed [type] => 256 )
|
|
#117
11.11.2014, 22:05
|
||||
|
||||
|
Цитата:
Сорри,увидил))
|
|
#118
12.11.2014, 01:43
|
||||
|
||||
|
допилили настройки сервера.
велком бэк. откат обратно на 7 утра 5 ноября
__________________
Мне, как ГД, все равно какой класс в ПвП рулит. Мне нужно чтобы все классы были одинаковыми сливами. (c) Самый вредный из людей Геймдизайнер - он злодей. Вот балансер гнусный - Жаль что он не вкусный!
|
|
#119
12.11.2014, 01:59
|
||||
|
||||
|
Когда жму на раритеты у Али:
Козни Тьмы привели к ошибке в Хаддане. Информация о ней записана, и Свет скоро восстановит образовавшуюся брешь.
__________________
Глаза открываешь — восемь, сходил в магазин — среда, сварил себе кофе — осень, прилег отдохнуть — зима…
|
|
#120
12.11.2014, 02:08
|
|||
|
|||
|
тоже самое в баре "Эксклюзив"
|
