News:

AbanteCart v1.4.2 is released.

Main Menu

upgrade to 1.2.4 SQL update issue

Started by helperbee, February 05, 2016, 12:47:54 AM

Previous topic - Next topic

helperbee

After upgrading to 1.2.4 (on my way to 1.2.5), this warning message is displayed
Incorrect status text id for order status #14. Value must be "canceled_by_customer" (). Please check data of tables ab_order_status_ids and ab_order_statuses

I have checked the tables ab_order_status_ids and ab_order_statuses and noticed that the later didn't have the record for "canceled by customer" which I then added. Cleared cache in both places, but no joy.

Should I fix prior to upgrading to 1.2.5? How do I fix?

Thank you kindly.

abolabo

Since v1.2.5 Abantecart have base order_statuses and additional.
for ex.
private $base_statuses = array (
0  => 'incomplete',
1  => 'pending',
2  => 'processing',
3  => 'shipped',
7  => 'canceled',
5  => 'completed',
8  => 'denied',
9  => 'canceled_reversal',
10 => 'failed',
11 => 'refunded',
12 => 'reversed',
13 => 'chargeback',
14 => 'canceled_by_customer');

where key (number) - order_status_id, text - status_text_id for this status.
You should to open database table order_status_ids via phpMyAdmin and compare this list with your data.

Fix you data and clear cache after save.

helperbee

Thank you, abolabo! I checked again.

Records within ab_order_status_ids match your example. However, error message continues to repeat. The error message also refers to the ab_order_statuses table which doesn't match your example, and is missing the last record. Should I add 'canceled_by_customer' as #14 to the ab_order_statuses table?

Attached is the screen shot of records within order_status_ids table.

abolabo

Quote from: helperbee on February 05, 2016, 03:59:43 PM
Should I add 'canceled_by_customer' as #14 to the ab_order_statuses table?

yes, of course.

helperbee


Forum Rules Code of conduct
AbanteCart.com 2010 -