Author Topic: Unknown column 'payment_method_data  (Read 5805 times)

Offline bab

  • Newbie
  • *
  • Posts: 33
  • Karma: +1/-1
    • View Profile
Unknown column 'payment_method_data
« on: March 11, 2014, 10:55:27 PM »
database error:  AbanteCart core v.1.1.8 Error: Unknown column 'payment_method_data' in 'field list'<br />Error No: 1054<br />UPDATE ab_orders_enc
            SET payment_method_data = "VERIFIED"
            WHERE order_id = "0" in <b>/home/user1/public_html/core/database/mysql.php</b> on line <b>114</b>

I keep getting this error. What does it mean? Please help.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Unknown column 'payment_method_data
« Reply #1 on: March 12, 2014, 04:33:51 AM »
database error:  AbanteCart core v.1.1.8 Error: Unknown column 'payment_method_data' in 'field list'<br />Error No: 1054<br />UPDATE ab_orders_enc
            SET payment_method_data = "VERIFIED"
            WHERE order_id = "0" in <b>/home/user1/public_html/core/database/mysql.php</b> on line <b>114</b>

I keep getting this error. What does it mean? Please help.

Hello.
Please post your AbanteCart version and what payment methods used, and when you get this error - during checkout?

P.S
please do not duplicate posts
« Last Edit: March 12, 2014, 04:39:07 AM by Basara »

Offline bab

  • Newbie
  • *
  • Posts: 33
  • Karma: +1/-1
    • View Profile
Re: Unknown column 'payment_method_data
« Reply #2 on: March 12, 2014, 11:49:20 AM »
Abantecart 1.1.8

PayPal & PayPal express

Bill me later button

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Unknown column 'payment_method_data
« Reply #3 on: March 17, 2014, 08:35:00 AM »
database error:  AbanteCart core v.1.1.8 Error: Unknown column 'payment_method_data' in 'field list'<br />Error No: 1054<br />UPDATE ab_orders_enc
            SET payment_method_data = "VERIFIED"
            WHERE order_id = "0" in <b>/home/user1/public_html/core/database/mysql.php</b> on line <b>114</b>

I keep getting this error. What does it mean? Please help.
i confirm this bug.
To fix it run this sql in you phpmyadmin
Code: [Select]
ALTER TABLE `ab_orders_enc` ADD COLUMN `payment_method_data` text NOT NULL default ''
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline bab

  • Newbie
  • *
  • Posts: 33
  • Karma: +1/-1
    • View Profile
Re: Unknown column 'payment_method_data
« Reply #4 on: March 18, 2014, 06:29:01 AM »
Thank you for the reply.

I executed it and it was successful.
Thank you once again.

 

Powered by SMFPacks Social Login Mod