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

1364 Field 'oc_note' doesn't have a default value

Started by VirtueMocer, January 08, 2021, 09:41:45 AM

Previous topic - Next topic

GJC Web Design

maybe find another host that doesn't enforce strict?..  ;)

the error is explained here:  https://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime

but if the host wont help with this by disabling then a core hack will probably be needed

perhaps in administrator\components\com_virtuemart\tables\orders.php

change line 102 to

var $paid_on = NULL;

???

but this may break some logic further down the track
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