Sto usando magento 2.2.5 e quando ho aperto la pagina di modifica prodotto il il nome del prodotto, il prezzo e così via non vengono caricati affatto e quando ho controllato var/log/exception.log
ho ricevuto il seguente errore:
Zend_Db_Statement_Exception (codice: 42000): SQLSTATE [42000]: errore di sintassi o violazione di accesso: 1248 Ogni tabella derivata deve avere il proprio alias, la query era: SELECT
u
. * FROM (SELEZIONAt
.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 (SELECTt
.value
, .attribute_id
,t
.store_id
FROMcatalog_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 (SELECTt
.value
,t
.attribute_id
,t
.store_id
FROMcatalog_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”)) AND (IN (0))) UNION ALL (SELECT
t
.value
,t
.attribute_id
,t
.store_id
DAcatalog_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
ORDINA PERstore_id
ASC