News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

VM 4.0.14 Database error order

Started by Margriet, April 04, 2023, 16:06:55 PM

Previous topic - Next topic

Margriet

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.

GJC Web Design

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

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.