Post by DesktopNev » Wed May 16, 2012 9:46 pm

I have installed the "Opencart Europa" - most European languages - full Opencart installation package v 1.5.1.3

Now I'm getting the following error:

Notice: Error: Unknown column 'tr2.name' in 'field list'
Error No: 1054
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '8' AND z2gz.country_id = '222' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3563') ORDER BY tr1.priority ASC in /var/www/clients/client1/web107/web/store/system/database/mysql.php on line 49

Please could you help me?

Newbie

Posts

Joined
Tue Feb 07, 2012 9:38 pm

Post by joeymagsino » Fri Jun 29, 2012 11:43 am

I have encoutered this error when i upgraded my opencart 1.4.9.5 to 1.5.1.3. I've managed to solved this by overwriting the tax_rate table with this SQL script:

Here is the SQL definition:



DROP TABLE IF EXISTS `tax_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tax_rate` (
`tax_rate_id` int(11) NOT NULL AUTO_INCREMENT,
`geo_zone_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(32) COLLATE utf8_bin NOT NULL,
`rate` decimal(15,4) NOT NULL DEFAULT '0.0000',
`type` char(1) COLLATE utf8_bin NOT NULL,
`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`tax_rate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

Newbie

Posts

Joined
Thu Apr 05, 2012 1:21 pm
Who is online

Users browsing this forum: No registered users and 25 guests