Jeg bruger magento 2.2.5, og når jeg åbnede rediger produktsiden, produktnavn, pris osv. indlæses slet ikke, og da jeg tjekkede var/log/exception.log
, fik jeg følgende fejl:
Zend_Db_Statement_Exception (kode: 42000): SQLSTATE [42000]: Syntaksfejl eller adgangsovertrædelse: 1248 Hver afledt tabel skal have sit eget alias, forespørgsel var: SELECT
u
. * FROM (VÆLGt
.value
,t
.attribute_id
,t
.store_id
FRAcatalog_product_entity_decimal
ASt
HVOR (entity_id = “6144”) OG (attribut_id IN (“75”, “76”, “79”, “91”, “80”, “120”, “99”)) OG (store_id
IN (0))) UNION ALL (VÆLGt
.value
, .attribute_id
,t
.store_id
FRAcatalog_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”)) OG (store_id
IN (0))) UNION ALL (VÆLGt
.value
,t
.attribute_id
,t
.store_id
FRAcatalog_product_entity_int
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”)) OG (IN (0))) UNION ALL (VÆLG
t
.value
,t
.attribute_id
,t
.store_id
FRAcatalog_product_entity_datetime
ASt
WHERE (entity_id = “6144”) AND (attribute_id IN (“104”, “77”, “105”, “78) “,” 93 “,” 94 “)) OG (store_id
IN (0))) UNION ALL (VÆLGt
.value
,t
.attribute_id
,t
.store_id
FRAcatalog_product_entity_text
ASt
WHERE (entity_id = “6144”) AND (attribute_id IN (“83”, “101”, “72”, “106”, “73”, “162”, “164”, “169”)) OG (store_id
IN ( 0))) ASu
BESTIL MEDstore_id
ASC