Hey community !
I’m very depressed, after fishing the configuration on my magento 2.3.1 and having every thing setup and running I even received my first order, the next day and all of the sudden I found this error message on my frontend:
" Error filtering template: SQLSTATE[HY000]: General error: 1030 Got error 1 from storage engine, query was: SELECT DISTINCT
e
.*,price_index
.price
,price_index
.tax_class_id
,price_index
.final_price
, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) ASminimal_price
,price_index
.min_price
,price_index
.max_price
,price_index
.tier_price
,at_sm_featured
.value
ASsm_featured
,cat_index
.position
AScat_index_position
,stock_status_index
.stock_status
ASis_salable
, IF(at_name.value_id > 0, at_name.value, at_name_default.value) ASname
FROMcatalog_product_entity
ASe
INNER JOINcatalog_product_index_price
ASprice_index
ON price_index.entity_id = e.entity_id AND price_index.website_id = ‘1’ AND price_index.customer_group_id = 0 LEFT JOINcatalog_product_entity_int
ASat_sm_featured
ON (at_sm_featured
.entity_id
=e
.entity_id
) AND (at_sm_featured
.attribute_id
= ‘155’) AND (at_sm_featured
.store_id
= 0) INNER JOINcatalog_category_product_index_store7
AScat_index
ON cat_index.product_id=e.entity_id AND cat_index.store_id=7 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2 INNER JOINcataloginventory_stock_status
ASstock_status_index
ON e.entity_id = stock_status_index.product_id LEFT JOINcatalog_product_entity_varchar
ASat_name_default
ON (at_name_default
.entity_id
=e
.entity_id
) AND (at_name_default
.attribute_id
= ‘70’) ANDat_name_default
.store_id
= 0 LEFT JOINcatalog_product_entity_varchar
ASat_name
ON (at_name
.entity_id
=e
.entity_id
) AND (at_name
.attribute_id
= ‘70’) AND (at_name
.store_id
= 7) WHERE (at_sm_featured.value = ‘1’) GROUP BYe
.entity_id
ORDER BYname
ASC LIMIT 20 "
I tried to google it, some say it’s a cron job issue some say its a php issue but the most say it is mysql running out of memory issue.
any idea folks?
The backend works fine, I mean the admin side but not the front.