VM 4.0.14 Database error order

[Margriet]

After upgrade from Joomla 3.10.11 to Joomla 4.2.9 the following error occurs when ordering:

Code Select Expand

vmError: vmTable store insertObject #__virtuemart_order_userinfos Field 'modified_on' doesn't have a default value INSERT INTO `jos_virtuemart_order_userinfos`
In backend order is visible, but no user info present.
I've copied the Joomla 3 site to a subfolder, ordered a product to make sure everything was working. Order was placed normally. After upgrade to Joomla 4, the error occured.

[GJC Web Design]

VM4 is for Joomla 4....

https://dev.virtuemart.net/projects/virtuemart/files

[Margriet]

I am using VM 4.0.14. It works without problems in Joomla 3, but I am getting database errors after upgrading to Joomla 4.
Fresh install Joomla 4.2.9 and VM 4.0.14 with sample data no problem.

[Margriet]

This problem is solved. Had to do something with table structure I suppose.