SQLSTATE: Column not found error on the frontend after installing a Magento theme or extension

If you see a SQLSTATE: Column not found error on the storefront after installing a new theme or extension, it often occurs when the instance previously used a different theme or already had categories/products configured.

Why this happens

Installing a theme/extension can introduce new EAV attributes or change indexes. If Magento’s indexes are out of date, storefront queries may reference columns that aren’t materialized yet, resulting in a Column not found exception.

Quick fix — Reindex

Run a full reindex from your Magento root:

• php bin/magento indexer:reindex

This regenerates the required index tables so the new attributes/columns are available to the storefront.

Optional checks

• Verify indexer status: php bin/magento indexer:status
• If changes still don’t appear, clear caches from Admin → System → Cache Management or via CLI:
• php bin/magento cache:flush

Learn more

For a full walkthrough of reindexing from Admin or CLI, see:

How to reindex your Magento 2 store from the Admin or via SSH

Updated on: 16/09/2025