Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'transaction_details'


mturner333

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]

Link to comment
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

Link to comment
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...