Jump to content
Sign in to follow this  
mturner333

1054 - Unknown column 'transaction_details'

Recommended Posts

I have searched for several hours with no luck. I've seen plenty with customer_group_id but not transaction_details. Can anyone point me in the right direction. I'd greatly appreciate it.

 

Here is the error after Confirmation of the order. It takes me right to this page. Though the notifications are working like they should and emails are being sent as well.

 

1054 - Unknown column 'transaction_details' in 'field list'

 

UPDATE orders SET cc_type = 'Visa', cc_owner = 'XXXX XXXXXXX', cc_number = 'XXXXXXXXX0027', cc_expires = '0109', transaction_details = 'Transaction ID|0;AVS Response|AVS not applicable for this transaction;Card Code Response|' WHERE orders_id = 11 LIMIT 1

 

[TEP STOP]

Share this post


Link to post
Share on other sites

are you sure you ran the sql to transaction_details in your order list?

 

ALTER TABLE `orders` ADD `transaction_details` TEXT NULL AFTER `cc_expires`;

 

run that in your store's database

Share this post


Link to post
Share on other sites
are you sure you ran the sql to transaction_details in your order list?

 

ALTER TABLE `orders` ADD `transaction_details` TEXT NULL AFTER `cc_expires`;

 

run that in your store's database

 

 

Thank you so much! It worked like a charm. Now that it has been added, I shouldn't see this message again right? You are a life-saver I was about ready to pull my hair out. Thanks for the fast response. :D

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×