News:

AbanteCart v1.4.2 is released.

Main Menu

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 -