Direct Download & Coupon Error

[shankscomp]

I keep getting this error when using an item that has the option for direct download...

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or z2g.zone_id = 0 or z2g.zone_id IS NULL ) ' at line 5

 

SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id= or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id= or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="ebay"

 

Where should I be looking???

 

 

ALSO, is it possible to have an item, where the customer can choose either CD format or Download format for an item???

 

Thanks

Tim

[♥geoffreywalton]

Might be worth passing over the values you are searching for to mysql

 

z2g.zone_id= or z2g.zone_id = 0

[shankscomp]

not exactly sure how to do that.

[shankscomp]

what file would be causing this error??? I'm not really sure where to look to even correct the error.

Thanks

[arlo]

I have a similar problem with this bit of SQL

 

SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id=0 or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id=222 or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="abc-123"

 

does discount_coupons_to_zones (dc2z) have a column called geo_zone_id OR zone_id (or both).

 

As far as I can see there should be only zone_id for that table, this causes the sataement above to crash.

 

Could someone submit a result from

 

desc discount_coupons_to_zones;

 

from a working installation.

 

My installation almost works but doesn't show the order total - discount. Seems to be a propblem in

 

checkout_confirmation.php

[arlo]

FIXED

 

mysql> alter table discount_coupons_to_zones change zones_id geo_zone_id int(11);

 

looks like the sql supplied with the contribution was wrong zone_id should be geo_zone_id