Jump to content

mturner333

Members
  • Content count

    21
  • Joined

  • Last visited

  1. mturner333

    1054 - Unknown column 'transaction_details'

    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
  2. 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]
  3. mturner333

    USPS module won't save my username

    I figured out what I was doing wrong, in that particular contribution I had to update my includes/modules/shipping/usps.php. It had NONE 'hardcoded' in there. Around line 235, I changed it to my userid, deactivated the usps module in admin>modules>shipping>usps, and then reactivated it and voilla it worked.
  4. I have read through hundreds and even google searched this site to no avail... I apologize if this is a repeat but I can't seem to find any info. I have installed the USPS Methods 4_2_1, I do have an account with usps online, I have received the email, I have called and changed over to the production server, email confirmed production server. Activated the usps module in admin>modules>shipping>usps. Here is where my problem arises. I input the username and password (though some articles on here say usps doesn't use passwords anymore), verified that production is checked and not test, but when I click update it goes back to the user id and password of NONE. Why is it not saving any of my data? In turn I am getting the "An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner." error but I believe that is due to the fact of going from test to production but I can't input my username and password. USPS gave me a url in my latest email from them to use for my production server... do I have to put that in anywhere or is it automatic? What am I forgetting??? Thanks in advance, I'm really under the gun with this site.
×