Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Upgrade problem: Store Front can not open, Control Panel Errors  (Read 4472 times)

Offline Gleaf

  • Newbie
  • *
  • Posts: 33
  • Karma: +6/-0
    • View Profile
Upgrade problem: Store Front can not open, Control Panel Errors
« on: October 01, 2014, 11:03:11 PM »
Store has been working fine for long time with version 1.1.5, starting from Sep.24, both customer and I can not receive e-mail notification, after searching here, I contacted HostPaPa,  and was told php version was upgraded recently, and suggested upgrade my AbanteCart.

I upgraded from 1.1.5 to 1.1.6,.... until the latest 1.1.9, every time it shows successful. So I even didn't check it was working or not. After all upgrade done, I found I can not open my web store, I got " 500 Internal Server Error"

Login to control Panel, when I click the following tabs, got " 500 Internal Server Error"
Design-Content
System
System-Setting
System-Localization-Zones

Click the following tabs, got empty result
System-Localization-countries:
                              Tax Classes:


Error Log repetitive message:

2014-09-30 2:42:02 - database error:  AbanteCart core v.1.1.9 Error: Unknown column 'tr.description' in 'field list'<br />Error No: 1054<br />SELECT tr.tax_class_id,
                     tr.rate AS rate, tr.rate_prefix AS rate_prefix,
                     tr.threshold_condition AS threshold_condition, tr.threshold AS threshold,
                     CASE WHEN tr.description='' THEN tc.title ELSE tr.description END as description,
                     tr.priority
               FROM ab_tax_rates tr
               LEFT JOIN ab_tax_classes tc ON tc.tax_class_id = tr.tax_class_id
               WHERE (tr.zone_id = '0' OR tr.zone_id = '0')
                  AND tr.location_id in (SELECT z2l.location_id
                                    FROM ab_zones_to_locations z2l, ab_locations l
                                    WHERE z2l.location_id = l.location_id and z2l.zone_id = '0')
               ORDER BY tr.priority ASC in <b>/home/leaf5503/public_html/store/core/database/mysql.php</b> on line

Place cursor on Setting tab, show unusual menu as  shown in attached.


Tried to restore 1.1.5 manual backup by dump file, got the same 500 error.


Please help. Thanks!


Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4359
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Upgrade problem: Store Front can not open, Control Panel Errors
« Reply #1 on: October 02, 2014, 11:16:30 AM »
Looks like tax_rate table was not updated. I do not remember what version has added description to this table.
You need to check sql update files for tax_rate table
If you run that script the error will go away.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline Gleaf

  • Newbie
  • *
  • Posts: 33
  • Karma: +6/-0
    • View Profile
Re: Upgrade problem: Store Front can not open, Control Panel Errors
« Reply #2 on: October 02, 2014, 06:29:42 PM »
Thanks for your reply. I'm not familiar with this, can you please tell me how to do? Really appreciate that.

You need to check sql update files for tax_rate table
If you run that script the error will go away.
« Last Edit: October 02, 2014, 06:31:16 PM by Gleaf »

 

Powered by SMFPacks Social Login Mod