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
http://forum.virtuemart.net/index.php?topic=136097.0
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
I have the same problems, is there any solution ?
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
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
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.