mturner333 Posted December 18, 2008 Share Posted December 18, 2008 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] Quote Link to comment Share on other sites More sharing options...
Guest Posted December 18, 2008 Share Posted December 18, 2008 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 Quote Link to comment Share on other sites More sharing options...
mturner333 Posted December 18, 2008 Author Share Posted December 18, 2008 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.