Home
Forum
Extensions
Developer Portal
VirtueMart Forum
VirtueMart & Joomla! - The Future of eCommerce
Home
Help
Search
Login
Register
Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Looking for documentation? Take a look on our
wiki
VirtueMart Forum
»
VirtueMart 2 + 3
»
General Questions
»
1364 Field 'oc_note' doesn't have a default value
« previous
next »
Print
Pages:
1
[
2
]
Go Down
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
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
Logged
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
Print
Pages:
1
[
2
]
Go Up
« previous
next »
VirtueMart Forum
»
VirtueMart 2 + 3
»
General Questions
»
1364 Field 'oc_note' doesn't have a default value
We use cookies, just to track visits to our website, we store no personal details.
OK
Learn more