Whenever I try editing my products and changing or editing the SKU, I keep getting this.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'webadmin_exc2_legacy.autosuggest_batch' doesn't exist, query was: SELECT COUNT(*) FROM `autosuggest_batch` AS `main_table` WHERE (`product_id` = '33') AND (`store_id` = '0')

Can anyone help?


Looks like you have a autosuggest module that has not been installed properly.

Disable Compilation and flush cache then:

Either re-install extension or Disable Extension in app/etc/modules or Remove Extension Completely.

  • I disabled autosuggest module in config and still not working. How can I disable compilation?
    – DevAnd
    Aug 8 '17 at 14:56
  • System > Tools > Compilation > Disable
    – hejhog
    Aug 8 '17 at 15:17
  • If this corrects the problem then System > Tools > Compilation > Run Compilation Process
    – hejhog
    Aug 8 '17 at 15:19

remove the autosuggest xml file located in app/etc/modules. Restart Apache due to xml change

  • Do you mean "Refresh cache" instead of "Restart Apache"? ;)
    – sv3n
    Aug 8 '17 at 15:14

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.