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 ‘price’ in ‘field list’
 
gattire
Jr. Member
 
Avatar
Total Posts:  9
Joined:  2010-02-21
 

Hi,

Has anyone experienced this error before and hopefully found a fix?

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

It just popped up and as a result can’t access the admin section.

I have had two extensions installed of late, however I’ve contacted both parties and they’ve both checked and said it wasn’t theirs. They both indicated it was coming from a core file.

Any help appreciated.

Thanks,

Justin

 
Magento Community Magento Community
Magento Community
Magento Community
 
gattire
Jr. Member
 
Avatar
Total Posts:  9
Joined:  2010-02-21
 

managed to fix the problem:

One of the extensions was short in SQL column, namely ‘price’. The code requested it, but the database doesn’t have it. So we just commented the line which contains that query in this file, /html/app/code/core/Mage/AdminNotification/Model/Feed.php, line 92.

hope this helps anyone that experiences this…

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top