AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: bab on March 11, 2014, 10:55:27 PM

Title: Unknown column 'payment_method_data
Post by: 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.

Title: Re: Unknown column 'payment_method_data
Post by: Basara on March 12, 2014, 04:33:51 AM

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

Title: Re: Unknown column 'payment_method_data
Post by: bab on March 12, 2014, 11:49:20 AM

Abantecart 1.1.8

PayPal & PayPal express

Bill me later button

Title: Re: Unknown column 'payment_method_data
Post by: abolabo on March 17, 2014, 08:35:00 AM

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

Code: [Select]

ALTER TABLE `ab_orders_enc` ADD COLUMN `payment_method_data` text NOT NULL default ''

Title: Re: Unknown column 'payment_method_data
Post by: bab on March 18, 2014, 06:29:01 AM

Thank you for the reply.

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