| Видящий Мрак |
11.11.2014 04:28 |
Удалил валентинку :))
Код:
Context info for the following error/warning:
Error: 1024, Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP SELECT t.thingid FROM thing t /*INNER JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/ WHERE t.thingid='20985133' AND t.userid='30883' AND (t.clan = '' OR t.clan='30883') /*AND NOT FIND_IN_SET('clan', tt.tflags)*/ AND t.place='inv' AND t.placeid=0 LIMIT 1; UPDATE thingstothrowaway INNER JOIN thing USING(thingid) SET userid=0, place='room', placetime=NOW(), placeid=16843521; REPLACE INTO thingvisibility (thingid, userid, roomid) SELECT thingid, 30883, 16843521 FROM thingstothrowaway; SELECT COUNT(*), GROUP_CONCAT(thingid) INTO @cnt, @thingids FROM thingstothrowaway;
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 t.thingid FROM thing t /*INNER JOIN thingtype tt ON t.thing' at line 1
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 thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER J...")
file: /var/www/haddan/core/library/db_fns.php, 305
call: db_trigger_error("Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER J...", "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/htdocs/inv/inv.php, 632
call: db_multiquery_write("CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thingtypeid=...")
file: /var/www/htdocs/inv/inv.php, 391
call: throwAwayThing(Array(4))
file: /var/www/htdocs/inv/inv.php, 111
call: processInventoryPost(Array(4))
}
Locals:
Array
(
[querytext] => Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/
WHERE t.thingid='20985133' AND t.userid='30883' AND (t.clan = '' OR t.clan='30883') /*AND NOT FIND_IN_SET('clan', tt.tflags)*/ AND t.place='inv' AND t.placeid=0
LIMIT 1;
UPDATE thingstothrowaway
INNER JOIN thing USING(thingid)
SET userid=0, place='room', placetime=NOW(), placeid=16843521;
REPLACE INTO thingvisibility (thingid, userid, roomid)
SELECT thingid, 30883, 16843521
FROM thingstothrowaway;
SELECT COUNT(*), GROUP_CONCAT(thingid) INTO @cnt, @thingids FROM thingstothrowaway;
[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 t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thing' at line 1
[type] => 256
)
Context info for the following error/warning:
Error: 256, Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP SELECT t.thingid FROM thing t /*INNER JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/ WHERE t.thingid='20985133' AND t.userid='30883' AND (t.clan = '' OR t.clan='30883') /*AND NOT FIND_IN_SET('clan', tt.tflags)*/ AND t.place='inv' AND t.placeid=0 LIMIT 1; UPDATE thingstothrowaway INNER JOIN thing USING(thingid) SET userid=0, place='room', placetime=NOW(), placeid=16843521; REPLACE INTO thingvisibility (thingid, userid, roomid) SELECT thingid, 30883, 16843521 FROM thingstothrowaway; SELECT COUNT(*), GROUP_CONCAT(thingid) INTO @cnt, @thingids FROM thingstothrowaway;
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 t.thingid FROM thing t /*INNER JOIN thingtype tt ON t.thing' at line 1
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 thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER J...", 256)
file: /var/www/haddan/core/library/db_fns.php, 305
call: db_trigger_error("Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER J...", "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/htdocs/inv/inv.php, 632
call: db_multiquery_write("CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thingtypeid=...")
file: /var/www/htdocs/inv/inv.php, 391
call: throwAwayThing(Array(4))
file: /var/www/htdocs/inv/inv.php, 111
call: processInventoryPost(Array(4))
}
Locals:
Array
(
[querytext] => Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/
WHERE t.thingid='20985133' AND t.userid='30883' AND (t.clan = '' OR t.clan='30883') /*AND NOT FIND_IN_SET('clan', tt.tflags)*/ AND t.place='inv' AND t.placeid=0
LIMIT 1;
UPDATE thingstothrowaway
INNER JOIN thing USING(thingid)
SET userid=0, place='room', placetime=NOW(), placeid=16843521;
REPLACE INTO thingvisibility (thingid, userid, roomid)
SELECT thingid, 30883, 16843521
FROM thingstothrowaway;
SELECT COUNT(*), GROUP_CONCAT(thingid) INTO @cnt, @thingids FROM thingstothrowaway;
[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 t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thing' at line 1
[type] => 256
)
|
