Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

Upgrade problem: Store Front can not open, Control Panel Errors

Started by Gleaf, October 01, 2014, 11:03:11 PM

Previous topic - Next topic

Gleaf

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!


abantecart

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

Gleaf

Thanks for your reply. I'm not familiar with this, can you please tell me how to do? Really appreciate that.

Quote from: abantecart on October 02, 2014, 11:16:30 AM
You need to check sql update files for tax_rate table
If you run that script the error will go away.

Forum Rules Code of conduct
AbanteCart.com 2010 -