[Fixed] Shipping Plugin :: Wrong SQL field returns no results

Started by grtrustme, September 29, 2011, 18:23:05 PM

Previous topic - Next topic

grtrustme

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"

Milbo

btw this was a bug which was only in the svn for 1 day.

should be fixed now.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/