Page 2 of 2

Re: [SOLVED] SyntaxError: Unexpected Token ILLEGAL

Posted: Wed Mar 07, 2012 12:51 am
by Qphoria
Yes, that is the error you want to see. The fix is here:
http://forum.opencart.com/viewtopic.php ... 97#p216197

Re: [SOLVED] SyntaxError: Unexpected Token ILLEGAL

Posted: Thu May 24, 2012 8:06 am
by jacardi
Hi. i have this issue currently in my cart. When i see the error log this is what i get


2012-05-24 0:00:50 - PHP Notice: Error: Table 'pnc_e1i54dgfl4.opn_tax_rule' doesn't exist<br />Error No: 1146<br />SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM opn_tax_rule tr1 LEFT JOIN opn_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN opn_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN opn_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN opn_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '8' AND z2gz.country_id = '229' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3732') ORDER BY tr1.priority ASC in /hermes/waloraweb098/b55/moo.timsamc/magic/system/database/mysql.php on line 49

then when i go to the tax module i got this


2012-05-24 0:03:55 - PHP Notice: Error: Unknown column 'sort_order' in 'order clause'<br />Error No: 1054<br />SELECT * FROM opn_product_image WHERE product_id = '932' ORDER BY sort_order ASC in /hermes/waloraweb098/b55/moo.timsamc/magic/system/database/mysql.php on line 49
2012-05-24 0:04:26 - PHP Notice: Error: Unknown column 'tr.name' in 'field list'<br />Error No: 1054<br />SELECT tr.tax_rate_id, tr.name AS name, tr.rate, tr.type, gz.name AS geo_zone, tr.date_added, tr.date_modified FROM opn_tax_rate tr LEFT JOIN opn_geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) ORDER BY tr.name ASC in /hermes/waloraweb098/b55/moo.timsamc/magic/system/database/mysql.php on line 49


So i need any clue about how i can solve this. Thanks in advance