Форумы мира Хаддан

Форумы мира Хаддан (http://forum.haddan.ru/index.php)
-   Общий форум (http://forum.haddan.ru/forumdisplay.php?f=9)
-   -   Тест Хаддана (http://forum.haddan.ru/showthread.php?t=111999)

JamesMoriarti 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
)





Когда у али жмёшь раритеты

Floozy 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] => из Окрестностей Старограда
)


пошёл тестить изменение в лаб

Baker 11.11.2014 21:36

Дайте денег норм Изменщика потестить)

Floozy 11.11.2014 21:38

Цитата:

Сообщение от Baker
Дайте денег норм Изменщика потестить)



денег критично не хватает +

Maelstorm 11.11.2014 22:02

пока остановил сервер, разберемся щас с кодировкой

КОУБИ 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
)

КОУБИ 11.11.2014 22:05

Цитата:

Сообщение от Maelstorm
пока остановил сервер, разберемся щас с кодировкой



Сорри,увидил))

Maelstorm 12.11.2014 01:43

допилили настройки сервера.
велком бэк.
откат обратно на 7 утра 5 ноября

Melted Ice 12.11.2014 01:59

Когда жму на раритеты у Али:

Козни Тьмы привели к ошибке в Хаддане. Информация о ней записана, и Свет скоро восстановит образовавшуюся брешь.

DespoD 12.11.2014 02:08

тоже самое в баре "Эксклюзив"


Часовой пояс GMT +4, время: 02:02.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd. Адаптация Архивариус & dukei