Author Topic: Error after updating to 3.2.4.  (Read 751 times)

Connecting

  • Beginner
  • *
  • Posts: 15
  • Tis mooi te weten wat ik eens zal weten
    • Toiletpapierkopen
Error after updating to 3.2.4.
« on: August 25, 2017, 15:45:50 pm »
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9450
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Connecting

  • Beginner
  • *
  • Posts: 15
  • Tis mooi te weten wat ik eens zal weten
    • Toiletpapierkopen
Re: Error after updating to 3.2.4.
« Reply #2 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

bebekus

  • Beginner
  • *
  • Posts: 1
  • A beginner
Re: Error after updating to 3.2.4.
« Reply #3 on: October 09, 2017, 11:28:09 am »
I have the same problems, is there any solution ?

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7690
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.2
Re: Error after updating to 3.2.4.
« Reply #4 on: October 09, 2017, 12:07:34 pm »
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 http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

maurizius

  • Beginner
  • *
  • Posts: 10
Re: Error after updating to 3.2.4.
« Reply #5 on: December 19, 2017, 08:56:51 am »
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9450
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Error after updating to 3.2.4.
« Reply #6 on: December 29, 2017, 12:00:05 pm »
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 :-)

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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/