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 ‘date’ in ‘field list’
 
pmallam
Jr. Member
 
Total Posts:  2
Joined:  2010-11-15
 

Hi All

I have recently move my website from an old server to a new one and seem to be getting the above error when trying to add, update or duplicate products. Although at first they were still being published to the site they now are not showing at all.

I have tried the following:

1) Cleared Cache - no joy
2) Reindex Data - no joy but the Category Flat Data and Product Flat Data is constantly reindexing and I can not reindex (this could be the issue)??
3) Deleted the LOCK files in /var/locks folder - no joy

I am really in a pickle here and would really love some help please.

Paul

 
Magento Community Magento Community
Magento Community
Magento Community
 
MagenX
Enthusiast
 
Total Posts:  791
Joined:  2008-05-26
Dublin
 

if you just use search before you post this in every possible forums and tech sites, it would have been fixed by now…
shut down your db and find this catalog_product_index_website

 
Magento Community Magento Community
Magento Community
Magento Community
 
pmallam
Jr. Member
 
Total Posts:  2
Joined:  2010-11-15
 

Power dude.....

Thanks for the reply.

So what must I do once I have shut down DB and found catalog_product_index_website?

Must I clear it or what?  Sorry if I sound stuuupid there.

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