Код:
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','diamondcoins','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:
file: /var/www/haddan/core/library/BonReq.php, 1601
call: Bon::_initBonusesEx("x.fixedprices: 1;
filter.flags:
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`='31'")
file: /var/www/haddan/core/roomfunc/shop_helper.php, 202
call: shopDptSelect(-2, 31, 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','diamondcoins','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','diamondcoins','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:
file: /var/www/haddan/core/library/BonReq.php, 1601
call: Bon::_initBonusesEx("x.fixedprices: 1;
filter.flags:
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`='31'")
file: /var/www/haddan/core/roomfunc/shop_helper.php, 202
call: shopDptSelect(-2, 31, 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','diamondcoins','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
)