Post by jewellerstore » Wed Mar 07, 2012 6:29 am

I'm trying to set up google checkout and the following error came up:
Notice: Error: Unknown column 'tr.tax_class_id' in 'on clause'
Error No: 1054
SELECT DISTINCT p.tax_class_id, zg.country_id, zg.zone_id, c.iso_code_2, z.code FROM `oc_product` p INNER JOIN `oc_tax_rate` tr ON p.tax_class_id = tr.tax_class_id INNER JOIN `oc_geo_zone` gz ON tr.geo_zone_id = gz.geo_zone_id INNER JOIN `oc_zone_to_geo_zone` zg ON gz.geo_zone_id = zg.geo_zone_id INNER JOIN `oc_country` c ON zg.country_id = c.country_id LEFT JOIN `oc_zone` z ON zg.zone_id = z.zone_id WHERE p.tax_class_id > 0 AND p.product_id IN (773); in /home/sites/taskeight.com/public_html/thejewellerstore.co.uk/system/database/mysql.php on line 49


Any ideas?

New member

Posts

Joined
Fri Dec 30, 2011 6:28 pm

Post by MKR » Fri Mar 30, 2012 11:55 pm

Hi

Did you get this resolved? I'm getting the same thing.

Cheers

MKR
Newbie

Posts

Joined
Fri Mar 30, 2012 11:53 pm

Post by art4web » Thu May 03, 2012 10:52 pm

I've installed Google Checkout module and I'm getting the same message. Anyone please?

New member

Posts

Joined
Thu Oct 27, 2011 8:51 pm

Post by franharrington » Thu May 17, 2012 5:11 am

same here


Posts

Joined
Thu May 17, 2012 5:09 am

Post by sw!tch » Thu May 17, 2012 3:26 pm

What version of OC are you running? I believe there was a change to the tax query.

Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!


Active Member

Posts

Joined
Sat Apr 28, 2012 2:32 pm
Location - USA

Post by franharrington » Thu May 17, 2012 11:22 pm

1.5.2 here


Posts

Joined
Thu May 17, 2012 5:09 am

Post by sw!tch » Fri May 18, 2012 2:44 am

I am running 1.5.2.1 and used the version that says "opencart-1-5-1-3-gcheckout-25.zip" and everything works.

I did have your error though by installing the wrong version, the way they are listed on the extension page appear not to be in order. The newest one is second from the top.

Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!


Active Member

Posts

Joined
Sat Apr 28, 2012 2:32 pm
Location - USA
Who is online

Users browsing this forum: No registered users and 6 guests