Author Topic: [Fixed] Shipping Plugin :: Wrong SQL field returns no results  (Read 2099 times)

grtrustme

  • Beginner
  • *
  • Posts: 32
  • Perfection in your hands
[Fixed] Shipping Plugin :: Wrong SQL field returns no results
« 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"

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10076
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Shipping Plugin :: Wrong SQL field returns no results
« Reply #1 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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/