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