Print Page - VM 4.0.14 Database error order

Title: VM 4.0.14 Database error order
Post by: Margriet on April 04, 2023, 16:06:55 PM

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

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.

Title: Re: VM 4.0.14 Database error order
Post by: GJC Web Design on April 04, 2023, 21:45:23 PM

VM4 is for Joomla 4....

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

Title: Re: VM 4.0.14 Database error order
Post by: Margriet on April 04, 2023, 22:17:32 PM

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.

Title: Re: VM 4.0.14 Database error order
Post by: Margriet on April 08, 2023, 12:57:29 PM

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

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: Margriet on April 04, 2023, 16:06:55 PM