Author Topic: Error when opening page  (Read 10114 times)

Offline hafreen

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Error when opening page
« 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

gordontaylor

  • Guest
Re: Error when opening page
« Reply #1 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.

Offline hafreen

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Re: Error when opening page
« Reply #2 on: February 01, 2014, 07:41:49 PM »
dear gordontaylor,

Kindly refer to the attached screenshot. Thank you =)

Offline hafreen

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Re: Error when opening page
« Reply #3 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>

gordontaylor

  • Guest
Re: Error when opening page
« Reply #4 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?

Offline hafreen

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Re: Error when opening page
« Reply #5 on: February 02, 2014, 10:58:56 AM »
thanks gordontaylor, but i never charge tax or modified the tax block  :-\

gordontaylor

  • Guest
Re: Error when opening page
« Reply #6 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.


Offline hafreen

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Re: Error when opening page
« Reply #7 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

 

Powered by SMFPacks Social Login Mod