VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: grtrustme on September 29, 2011, 18:23:05 PM

Title: [Fixed] Shipping Plugin :: Wrong SQL field returns no results
Post by: grtrustme on September 29, 2011, 18:23:05 PM
There is an issue with shipping plugin.

I have configured a simple Shipping Method but when i go to my cart to select it, it does not appear.

The sql that runs is this:
SELECT v.*,j.*,s.virtuemart_shoppergroup_id  FROM   #__virtuemart_shippingcarriers AS v LEFT JOIN #__extensions as j ON j.`extension_id` =  v.`shipping_carrier_jplugin_id` LEFT OUTER JOIN #__virtuemart_shippingcarrier_shoppergroups AS s ON v.`virtuemart_shippingcarrier_id` = s.`virtuemart_shippingcarrier_id`  WHERE v.`published` = "1"  AND j.`folder` = "weight_countries"
AND  (v.`virtuemart_vendor_id` = "1" OR   v.`virtuemart_vendor_id` = "0")
AND  (s.`virtuemart_shoppergroup_id`= "1" OR ISNULL(s.`virtuemart_shoppergroup_id`) )

In my plugin table (#__extensions), my shipping plugin has
#__extensions.`folder` = 'vmshipper' and not #__extensions.`folder` = "weight_countries"

And that is why the sql returns no results to me.

PS. #__extensions.`element` = "weight_countries"
Title: Re: Shipping Plugin :: Wrong SQL field returns no results
Post by: Milbo on September 29, 2011, 20:34:09 PM
btw this was a bug which was only in the svn for 1 day.

should be fixed now.