> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.weltpixel.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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](https://help.weltpixel.com/en/article/how-to-reindex-your-magento-2-store-from-admin-or-ssh-cli-1lr0qy8/)