나는 magento 2.2.5를 사용하고 있으며 제품 편집 페이지를 열었을 때 제품 이름, 가격 등이 전혀로드되지 않고 var/log/exception.log
를 확인했을 때 다음 오류가 발생했습니다.
Zend_Db_Statement_Exception (코드 : 42000) : SQLSTATE [42000] : 구문 오류 또는 액세스 위반 : 1248 모든 파생 테이블에는 자체 별칭이 있어야합니다. 쿼리는 다음과 같습니다. SELECT
u
. * FROM (선택t
.value
,t
.attribute_id
,t
.store_id
FROMcatalog_product_entity_decimal
ASt
WHERE (entity_id = “6144”) AND (attribute_id IN ( “75”, “76”, “79”, “91”, “80”, “120”, “99”)) AND (store_id
IN (0))) UNION ALL (선택t
.value
, .attribute_id
,t
.store_id
catalog_product_entity_varchar
ASt
WHERE (entity_id = “6144”) AND (attribute_id IN ( “82”, “85”, “122”, “103”) , “71”, “86”, “192”, “84”, “87”, “88”, “107”, “95”, “109”, “119”, “222”, “236”, ” 237 “,”238 “,”239 “,”240 “,”241 “,”242 “,”244 “,”245 “,”98 “,”112 “,”113 “,”97 “,”114 ” , “117”, “215”, “129”, “216”, “130”, “217”, “218”, “219”, “220”)) AND (store_id
IN (0))) UNION ALL (선택t
.value
,t
.attribute_id
,t
.store_id
catalog_product_entity_int
div> ASt
WHERE (entity_id = “6144”) AND (attribute_id IN ( “100”, “127”, “163”, “89”, “191”, “167”) “,”92 “,”121 “,”171 “,”126 “,”173 “,”81 “,”96 “,”185 “,”234 “,”176 “,”177 “,”102 “, “161”, “123”, “124”, “125”, “213”, “128”, “131”, “153”)) AND (IN (0))) UNION ALL (
t
선택.value
,t
.attribute_id
,t
.store_id
catalog_product_entity_datetime
ASt
WHERE (entity_id = “6144”) AND (attribute_id IN ( “104”, “77”, “105”, “78 “,”93 “,”94 “)) AND (store_id
IN (0))) UNION ALL (SELECTt
.value
,t
.attribute_id
,t
.store_id
Fromcatalog_product_entity_text
ASt
WHERE (entity_id = “6144”) AND (attribute_id IN ( “83”, “101”, “72”, “106”, “73”, “162”, “164”, “169”)) AND (store_id
IN ( 0))) ASu
주문 기준store_id
ASC