Magento Forum

   
magneto extremely messed up
 
collinssolutions
Sr. Member
 
Total Posts:  79
Joined:  2008-07-09
USA Arkansas
 

so at the bottom of the admin site i get Magento ver. 1.5.1.0 but when i go to the downloader it shows mage_all_latest at 1.6

No upgrades show and now when i try and add new products i get SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘cwd.date’ in ‘field list’

Any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
terry222
Jr. Member
 
Total Posts:  4
Joined:  2010-12-01
 

login phpmyadmin
Modify table catalog_product_index_website column website_date to date
then well!

magento插件

 
Magento Community Magento Community
Magento Community
Magento Community
 
dehadi
Jr. Member
 
Total Posts:  28
Joined:  2009-06-19
 

Great!!!

Thanks a lot terry222
i got the same problem and your post solved it!

 
Magento Community Magento Community
Magento Community
Magento Community
 
spareparts
Jr. Member
 
Total Posts:  13
Joined:  2011-04-06
 

Hi,

i have the same problem. I have all data in my website, but now i can’t change my product’s data, i have this error: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘cwd.date’ in ‘field list’.

I tried to change website_date in date in phpmyadmin, but i didn’t successed.

Anybody can help me ? big surprise

Image Attachments
Immagine 1.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
spareparts
Jr. Member
 
Total Posts:  13
Joined:  2011-04-06
 

I forgot to say that i installed 1.6 magento version, but now i have installed a previous backup of my site (not database, only files via FTP) and now in my backend i see that i have 1.5.0.1 version!!

Maybe it’s here the problem, but softaculous can’t permit me to reinstall 1.6 version.

Please, help me!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Col. Hajj
Member
 
Total Posts:  33
Joined:  2010-10-16
 

Same issue here.  I tried upgrading to 1.6.2.0 from 1.5.0.1.  The install appears to go smoothly, but after it is finished, the site fails to load (just times out).  I restored to the 1.5.0.1 version and the site functions again, but customers get this error when trying to check out:

There was an error processing your orderPlease contact us or try again later.

I get this error email:

Payment transaction failed.

Reason
SQLSTATE[42S22]
Column not found1054 Unknown column 'cwd.date' in 'field list'

Checkout Type
onepage

This is with Paypal Standard.  I’ve also noticed that the total price of the items effects rather or not they can actually proceed to Paypal to check out.  It looks like anything at around $10 and under gets processed fine.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Col. Hajj
Member
 
Total Posts:  33
Joined:  2010-10-16
 

I’ll also add that when I try to create or modify a product, I get this similar error;

SQLSTATE[42S22]Column not found1054 Unknown column 'date' in 'field list'

When I go back to my catalog, the new item or modification to an existing item is in fact there.

 
Magento Community Magento Community
Magento Community
Magento Community
 
boziboy
Member
 
Total Posts:  44
Joined:  2009-11-05
 

Performed Updated, nothing but major issues. Now I get this error on orders around 25$ : SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘cwd.website_date’ in ‘field list’

And, when I got to update a product it says it successfully updated but the changes are not saved. In addition, when I create a new product and save it says “product no longer exist” and below that it says “product saved”.

 
Magento Community Magento Community
Magento Community
Magento Community
 
fconnolly
Jr. Member
 
Avatar
Total Posts:  1
Joined:  2013-06-27
 

Hi everyone,

First time posting so apologies for any mistakes.  I have a similar problem with Magento ver 1.8.0.0.  A customer tried to make a purchase and I got an ‘Payment failed reminder’ email with the following message,

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

Can anyone help with this.  Any and all advice with this would be appreciated.

Thanks,

F.

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