Показать сообщение отдельно
  #78  
Старый 11.11.2014, 04:28
Видящий Мрак  
Сообщения: n/a
По умолчанию

Удалил валентинку )

Код:
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 )
Ответить с цитированием