Author Topic: upgrade to 1.2.4 SQL update issue  (Read 6923 times)

Offline helperbee

  • Jr. Member
  • **
  • Posts: 78
  • Karma: +2/-0
    • View Profile
upgrade to 1.2.4 SQL update issue
« 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.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2054
  • Karma: +320/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: upgrade to 1.2.4 SQL update issue
« Reply #1 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.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline helperbee

  • Jr. Member
  • **
  • Posts: 78
  • Karma: +2/-0
    • View Profile
Re: upgrade to 1.2.4 SQL update issue
« Reply #2 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.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2054
  • Karma: +320/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: upgrade to 1.2.4 SQL update issue
« Reply #3 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.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline helperbee

  • Jr. Member
  • **
  • Posts: 78
  • Karma: +2/-0
    • View Profile
Re: upgrade to 1.2.4 SQL update issue
« Reply #4 on: February 07, 2016, 03:23:00 PM »
Thank you! Yes, that worked.

 

Powered by SMFPacks Social Login Mod