Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

BUG: Errors with MySQL 5.7 strict_mode #137

Closed
YaWK opened this issue Nov 21, 2017 · 6 comments
Closed

BUG: Errors with MySQL 5.7 strict_mode #137

YaWK opened this issue Nov 21, 2017 · 6 comments
Assignees
@YaWK
Labels
Backend Backend related issues BUG Bugs or other unwanted insects
Milestone
Remove Bugs

Comments

@YaWK
Copy link
Owner

YaWK commented Nov 21, 2017

Pages add / modify; Blog add / modify wont work on MySQL 5.7 - this really needs to be fixed before release!
@YaWK YaWK added Backend Backend related issues BUG Bugs or other unwanted insects labels Nov 21, 2017
@YaWK YaWK self-assigned this Nov 21, 2017
@YaWK
Copy link
Owner Author

YaWK commented Jan 7, 2018

Installer should detect the MySQL version and load the appropriate .sql file.

@YaWK YaWK changed the title BUG: Some Backend Actions won't work on MySQL 5.7 BUG: Errors with MySQL 5.7 Feb 2, 2018
@YaWK
Copy link
Owner Author

YaWK commented Feb 2, 2018 •
edited

MySQL 5.7: default SQL mode conflicts with having 0000-00-00 00:00:00 as default datetime. Zero Date is used in many cases. Due this it is necessary to change all affected datetime fields. Solution would be to set it to 'null' on default. A lot of classes and methods are needed to be updated to smash this bug.

@YaWK YaWK closed this as completed Feb 2, 2018
@YaWK YaWK reopened this Feb 2, 2018
@YaWK YaWK added this to the Remove Bugs milestone Feb 2, 2018
YaWK added a commit that referenced this issue Mar 2, 2018
@YaWK
issue #137: fixed menu display() method. (switched from zero date to …
914a1b9 
…NULL values) updated .sql file too.
YaWK added a commit that referenced this issue Mar 2, 2018
@YaWK
issue #137: updated class pages() and .sql file
aafd427
@YaWK
Copy link
Owner Author

YaWK commented Mar 2, 2018

updated .sql file during this commit

YaWK added a commit that referenced this issue Mar 2, 2018
@YaWK
issue #137: updated widget class
fb10254
@YaWK
Copy link
Owner Author

YaWK commented Mar 5, 2018

seems to be fixed!

@YaWK YaWK closed this as completed Mar 5, 2018
@YaWK
Copy link
Owner Author

YaWK commented Aug 20, 2019

blog-edit view in backend needs to be fixed: new version of datetimepicker requires different markup

YaWK added a commit that referenced this issue Aug 20, 2019
@YaWK
issue #137: updated datetimepicker markup
92747ab
@YaWK YaWK reopened this Sep 2, 2019
@YaWK
Copy link
Owner Author

YaWK commented Sep 2, 2019

re-opened because there are still some errors with mysql_strict_mode.

@YaWK YaWK changed the title BUG: Errors with MySQL 5.7 BUG: Errors with MySQL 5.7 strict_mode Sep 2, 2019
YaWK added a commit that referenced this issue Sep 2, 2019
@YaWK
issue #137: fixed a bug on page-edit - an empty submenu could cause a…
4b0623b 
…n error in mysql_strict_mode during $page->save process. (fixed for now)
YaWK added a commit that referenced this issue Sep 2, 2019
@YaWK
issue #137: hotfix for submenu select field
e53c057
YaWK added a commit that referenced this issue Jun 7, 2021
@YaWK
issue #137: fixed add menu entries, caused by faulty query string
f21e13a
YaWK added a commit that referenced this issue Jun 7, 2021
@YaWK
issue #137: fixed adding menu entries during page creation, caused by…
a65e566 
… faulty db query string in pages class
YaWK added a commit that referenced this issue Jun 7, 2021
@YaWK
issue #137: fixed saving widget settings bug
7c8f1dd
@YaWK YaWK closed this as completed Feb 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@YaWK YaWK

Labels
Backend Backend related issues BUG Bugs or other unwanted insects
Projects
None yet
Milestone
Remove Bugs
Development

No branches or pull requests
1 participant
@YaWK