AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: helperbee on February 05, 2016, 12:47:54 AM

Title: upgrade to 1.2.4 SQL update issue
Post by: helperbee on February 05, 2016, 12:47:54 AM
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.
Title: Re: upgrade to 1.2.4 SQL update issue
Post by: abolabo on February 05, 2016, 01:18:31 PM
Since v1.2.5 Abantecart have base order_statuses and additional.
for ex.
Code: [Select]
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.
Title: Re: upgrade to 1.2.4 SQL update issue
Post by: helperbee on February 05, 2016, 03:59:43 PM
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.
Title: Re: upgrade to 1.2.4 SQL update issue
Post by: abolabo on February 05, 2016, 05:44:22 PM
Should I add 'canceled_by_customer' as #14 to the ab_order_statuses table?

yes, of course.
Title: Re: upgrade to 1.2.4 SQL update issue
Post by: helperbee on February 07, 2016, 03:23:00 PM
Thank you! Yes, that worked.