"TEST DB ACCESS"의 두 판 사이의 차이

1번째 줄: 1번째 줄:
 
{{#cargo_query:
 
{{#cargo_query:
tableㄴ=ITEM_SHOP
+
table=ITEM_SHOP
|fields=ITEM_SHOP.CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름,ITEM_SHOP.ITEM_SHOP_AREA18_NAME=상점
+
|fields=CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름,ITEM_SHOP_AREA18_NAME=상점
 
|where=상점='Centermass'
 
|where=상점='Centermass'
 
|column widths=90px,90px
 
|column widths=90px,90px
 
|format=dynamic table
 
|format=dynamic table
 
}}
 
}}

2022년 9월 19일 (월) 23:53 판

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xEC\x83\x81\xEC\xA0\x90='Centermass' ORDER BY `cargo__ITEM_SHOP`.`_pageID`,...' at line 1 (192.168.2.4:3307)

Function: CargoSQLQuery::run Query: SELECT `cargo__ITEM_SHOP`.`_pageID` AS `cargo_backlink_page_id_ITEM_SHOP`,CONCAT('',ITEM_SHOP_KOR_NAME,'') AS `이름`,`ITEM_SHOP_AREA18_NAME` AS `상점` FROM `cargo__ITEM_SHOP` WHERE 상점='Centermass' ORDER BY `cargo__ITEM_SHOP`.`_pageID`,CONCAT('',ITEM_SHOP_KOR_NAME,''),`ITEM_SHOP_AREA18_NAME`