Author Topic: 1364 Field 'oc_note' doesn't have a default value  (Read 594 times)

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10027
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: 1364 Field 'oc_note' doesn't have a default value
« Reply #15 on: January 12, 2021, 11:07:40 am »
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 http://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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation