HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Garden master branch fix to run in Mysql strict mode
I finally figure out how to fix the issue with Garden master branch that won't install when run Mysql in strict mode.
I fork the Garden master branch and work on this issue because I am just curious why it just failed.
Here is my fork on github:
https://github.com/chanhong/Garden
I am so happy I finally get to the bottom of this issue.
0
Comments
I forgot to mention the basic idea is to look for all structure.php file and where ever you see a field with type int or datetime or may be a few other and assign them with a value of NULL.
I was able to get the setup to complete but there are so many of them I am sure there are still more places that abort or cause it to "bonk" out at setup time.
you can submit, a pull request to the core. However it they will need to be some testing so they would probably add it to alpha version, if it isn't already done.
grep is your friend.
I did submit a pull request but not sure if anyone look at it. Thanks
sure it is not going to be instant, this is just one of many things they are working towards.
grep is your friend.
I found out that just a little change in these two files will enable Vanilla to run good in MySQL that set with strict mode.
Garden\applications\dashboard\settings\structure.php
'Garden.Moderation.Manage',
'Garden.Moderation.Manage' => 0,
Garden\applications\conversations\settings\structure.php
->Column('UpdateUserID', 'int', FALSE, 'key')
->Column('DateUpdated', 'datetime')
->Column('UpdateUserID', 'int', NULL, 'key')
->Column('DateUpdated', 'datetime', NULL)