0

How can I fix this ??

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydatabase.mg_catalogsearch_fulltext_cl' doesn't exist, query was: UPDATE catalog_product_entity SET attribute_set_id = ?, type_id = ?, sku = ?, has_options = ?, required_options = ?, created_at = ?, updated_at = ? WHERE (entity_id = '3')

Both catalog_product_entity table and catalogsearch_fulltext_cl are there- But I am not sure why there is prefix mg_ in the error message above.

  • Check your database I think catalog_product_entity table is missing. if table is missing create table and reindex – Chander Shekhar Dec 13 '17 at 10:37
  • ok. I will try. How many columns should I give for this table? Seven? – rtk0407 Dec 13 '17 at 11:02
  • I actually found that catalog_product_entity exists. So what else should I do? – rtk0407 Dec 13 '17 at 11:21
  • did you fix this? – CompactCode Jan 22 '18 at 5:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.