News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

Unknown column 'payment_method_data

Started by bab, March 11, 2014, 10:55:27 PM

Previous topic - Next topic

bab

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.

Basara

#1
Quote from: bab 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.

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

bab

Abantecart 1.1.8

PayPal & PayPal express

Bill me later button

abolabo

Quote from: bab 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.
i confirm this bug.
To fix it run this sql in you phpmyadmin
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

bab

Thank you for the reply.

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

Forum Rules Code of conduct
AbanteCart.com 2010 -