upgrade to 1.2.4 SQL update issue

[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.

Code Select Expand

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]

Should I add 'canceled_by_customer' as #14 to the ab_order_statuses table?

yes, of course.

[helperbee]

Thank you! Yes, that worked.