Author Topic: VM 4.0.14 Database error order  (Read 533 times)

Margriet

  • Jr. Member
  • **
  • Posts: 115
VM 4.0.14 Database error order
« 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:
Code: [Select]
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10878
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: VM 4.0.14 Database error order
« Reply #1 on: April 04, 2023, 21:45:23 PM »
GJC Web Design
VirtueMart and Joomla Developers - php developers https://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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Margriet

  • Jr. Member
  • **
  • Posts: 115
Re: VM 4.0.14 Database error order
« Reply #2 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.

Margriet

  • Jr. Member
  • **
  • Posts: 115
Re: VM 4.0.14 Database error order
« Reply #3 on: April 08, 2023, 12:57:29 PM »
This problem is solved. Had to do something with table structure I suppose.