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:

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
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
Contact for any VirtueMart or Joomla development & customisation