AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: hafreen on February 01, 2014, 06:59:28 PM

Title: Error when opening page
Post by: hafreen on February 01, 2014, 06:59:28 PM
Hi, can anyone help me regarding this? Already check error log but don't know what to do  :'(

TIA
Title: Re: Error when opening page
Post by: gordontaylor on February 01, 2014, 07:13:56 PM
If you don't post the error, neither do we know what to do!

Please describe your issue in more detail and post the error from the error log, if there is one.
Title: Re: Error when opening page
Post by: hafreen on February 01, 2014, 07:41:49 PM
dear gordontaylor,

Kindly refer to the attached screenshot. Thank you =)
Title: Re: Error when opening page
Post by: hafreen on February 01, 2014, 07:46:19 PM
COPIED FROM THE ERROR LOG

2014-02-01 18:11:30 - database error:  AbanteCart core v.1.1.8 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_ida
               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/halimas1/public_html/core/database/mysql.php</b> on line <b>86</b>
Title: Re: Error when opening page
Post by: gordontaylor on February 02, 2014, 01:32:55 AM
As you can see it is a problem with the tax class. Are you charging tax on your purchases and if so, have you modified the Tax Block?
Title: Re: Error when opening page
Post by: hafreen on February 02, 2014, 10:58:56 AM
thanks gordontaylor, but i never charge tax or modified the tax block  :-\
Title: Re: Error when opening page
Post by: gordontaylor on February 02, 2014, 12:48:20 PM
Make sure on the product edit page, the tax class button is set to None

Screenshot below.

Title: Re: Error when opening page
Post by: hafreen on February 05, 2014, 05:47:03 AM
Thanks gordontaylor, already checked, all Tax Class button already select to None before this. But this problem still not resolved