Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

SQLSTATE[42S22]: Column not found: 1054 Unknown column
 
pixelpusher
Sr. Member
 
Avatar
Total Posts:  135
Joined:  2008-04-23
SoCal
 

I know there’s a couple threads out there with similar titles but I’m pretty sure this is different.

On the frontend:
when viewing categories I am redirected to /report/?id=xxxxxxxxxxx&s;=default
and the error report is
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘is_active’ in ‘where clause’

viewing specific products is ok

On the backend:
I get this error when refreshing catalog rewrites
AND when I try to save categories
I’m sure some other places too

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘catalog_category_entity.is_active’ in ‘field list’

This error when I try to export products
Invalid option id specified for options_container (container2), skipping the record (Line 1, SKU: XTRA235) - for all products

Also this error shows up in the php error log
PHP Fatal error: Call to a member function setAttribute() on a non-object in /home/herodisc/public_html/h2/app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php on line 307

Links
HeroDiscUSA - Magento Install
HeroDiscUSA - /h2/ Info.php
If further information is needed please ask me and I’ll post promptly.

I tried turning off rewrites but that didn’t seem to help anything.
attached is the .htaccess

Any advice is much appreciated.
thanks

File Attachments
htaccess.txt  (File Size: 4KB - Downloads: 91)
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top