Cart Error: 1064 You have an error in your SQL syntax;

[snstfd]

In the checkout at the top of the page is a save button. I'm not even sure why it is there but when I hit it, it produces the following error:

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 '' at line 3 SQL=SELECT mf_name FROM #__virtuemart_manufacturers_en_gb WHERE virtuemart_manufacturer_id =

I have included the screenshot of the button.

I'm not sure if this is relevant but we have store locations set up as manufacturers so they can pick which store they are ordering from. Those locations do not appear in the pull down menu shown under "cart" in the attachment. The main name of the store which is also our company name does appear. 


Joomla version, 3.6.2.
VirtueMart 3.0.16

[GJC Web Design]

rule 1!!!

don't test ANYTHING front end as an administrator!

[snstfd]

I am not sure that applies. I tested in several browsers which I do not use to log in to the CMS so I don't think that would apply but it's a good rule I will keep in mind.

You should be able to reproduce the error here:

dev.sunsetfoods.com/cart

or www.sunsetfoods.com/cart

[GJC Web Design]

is this multi vendor?

afaik this is

// This displays the form to change the current shopper
   if ($this->allowChangeShopper){
      echo $this->loadTemplate ('shopperform');
   }

and set in admin by

Allow Administrators to change the current Shopper   

so should only show for admins

[snstfd]

Thank you for your follow up. I have attached a screenshot of what is selected in the back-end.

Enable Multi-vendor: administrated multi-vendor
Multi-vendor cart handling: Selectable by user

Are those the correct settings?

[GJC Web Design]

I don't know.. I have never used multi vendor

http://docs.virtuemart.net/manual/general-concepts/211-multivendor.html

[snstfd]

This is a SQL Syntax error - not VM

[GJC Web Design]

I agree.. but my question is why is this form shown to non admins?

I have never seen it on my installs

[Milbo]

rule 1!!!

don't test ANYTHING front end as an administrator!

Of course, you should test as guest, registered and also administrator.

snstfd, the multivendor setup looks correct. Can you copy paste the sql error?

[GJC Web Design]

don't test ANYTHING front end as an administrator!

I meant when testing your shop as a user..  have seen this so many times by clients asking why they see different elements and options from std. and the reason is they are using their super admin login as a normal shopper on the FE
Of course use admin IF u want to test as an admin

[sgrunch]

same problem after update to 3.22 with J 3.71 product detail page:
'ASC FROM `#__virtuemart_products` as p INNER JOIN `#__virtuemart_products_it

[Milbo]

That is the neighboured product function, please read here http://forum.virtuemart.net/index.php?topic=137501.msg481450#msg481450