News:

Looking for documentation? Take a look on our wiki

Main Menu

Error after updating to 3.2.4.

Started by Connecting, August 25, 2017, 15:45:50 PM

Previous topic - Next topic

Connecting

Hi,

Im getting a error in my cart when I want to confirm the order: 42S22 - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_shoppergroups' in 'field list.
Im also get the possibilty to choose what kind of customer I am :-(

Whats wrong?

Regards,

Carel

Milbo

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

Connecting

Hi Milbo,

Thanks for your answer. I have execute the "Install or if necessary update tables" but then Im getting a error: 0 00000, ,
What can I do about it?

Best regards,

Carel

bebekus

I have the same problems, is there any solution ?

GJC Web Design

I don't recognise the error but most problems with the table updater are hosting/server limits

In some cases I have had to copy the site to a good server or local host,  do the updating and transfer back
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

maurizius

Hi Carel,
I had your same problem.
I searched a lot for a solution without results.
At the end I had copy my web site in a local enviroment for debug the problem.

I don't know why but I found that in the orders table (virtuemart_orders) the column user_shoppergroups  missing.

I added the column (varchar 39) and now all works fine.

I hope that will resolve also your problem.

Regards,
MP

Milbo

Thank you for your add on. Actually I did not write that, because it was for me obvious, that a missing column can be added manually. But nice that you did :-)

Quote from: Connecting on August 26, 2017, 09:55:00 AM
Hi Milbo,

Thanks for your answer. I have execute the "Install or if necessary update tables" but then Im getting a error: 0 00000, ,
What can I do about it?

Best regards,

Carel

In August we had no clue, what this error means, but we maybe we found out last month. It seems that this error happens when people use the PDO driver instead of mysqli. VM is not even tested on PDO ! Do not use it, there is a general milestone planned to change anything using pdo, but that is another topic.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/