Print Page - Select shipment:

Title: Select shipment:
Post by: olejenya on April 12, 2012, 18:33:54 PM

hi. Installs the new version 2.0.4 and ran into this error Select shipment:
vmError: Error reading getPluginMethods 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 'ORs.`virtuemart_shoppergroup_id`= "4" OR (s.`virtuemart_shoppergroup_id`) IS NUL' at line 4 SQL=SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id FROM `jos_virtuemart_shipmentmethods_en_gb` as l JOIN `jos_virtuemart_shipmentmethods` AS v USING (`virtuemart_shipmentmethod_id`) LEFT JOIN `jos_extensions` as j ON j.`extension_id` = v.`shipment_jplugin_id` LEFT OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s ON v.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id` WHERE v.`published` = "1" AND j.`element` = "weight_countries" AND (v.`virtuemart_vendor_id` = "1" OR v.`virtuemart_vendor_id` = "0") AND (s.`virtuemart_shoppergroup_id`= "1" ORs.`virtuemart_shoppergroup_id`= "4" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) ORDER BY v.`ordering`

In version 2.0.2 all was normal. Tell me how to fix? And how to configure the method that would not have this problem.

Title: Re: Select shipment:
Post by: olejenya on April 12, 2012, 21:22:45 PM

Someone when you answer me?)))

Title: Re: Select shipment:
Post by: perlarenee on April 17, 2012, 07:40:15 AM

I have the same issue. Anyone know the cause? I've tried disabling all plugins, shipping, etc. to no effect.

Title: Re: Select shipment:
Post by: Earthshaker666 on April 30, 2012, 18:46:14 PM

i got the same problem.

Is there already a solution or bugfix?

Best Regards
Marco

Title: Re: Select shipment:
Post by: Earthshaker666 on April 30, 2012, 19:17:16 PM

Hi there, i'm using this not released file and it works fine:
https://dev.virtuemart.net/svn/virtuemart/trunk/virtuemart/administrator/components/com_virtuemart/plugins/vmpsplugin.php

Title: Re: Select shipment:
Post by: perlarenee on May 16, 2012, 16:38:04 PM

i got it working after some time but i don't remember exactly what i did :P works right now....all except adding multiple shipping addresses

Title: Re: Select shipment:
Post by: andreasgr on June 22, 2012, 11:28:22 AM

Hi i have the same problem with 2.0.6 can you try to remember what you did to fix it?
At least where to look?

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: olejenya on April 12, 2012, 18:33:54 PM