The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/printthread.php 16 require_once



UserSpice
Mysql Strict Mode Compliance? - Printable Version

+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: Mysql Strict Mode Compliance? (/showthread.php?tid=782)



Mysql Strict Mode Compliance? - cardmaverick - 10-07-2017

Hi, is UserSpice 4.2 compliant with Mysql strict mode enabled? This is now the default setting for Mysql 5.7+ which I'm currently using.

Thanks!


Mysql Strict Mode Compliance? - mudmin - 10-08-2017

To be honest, I don't know. You're welcome to try. I'm thinking that there are a few places that we relied on 0000-00-00 type dates etc. If you wouldn't mind attempting to install it and see what happens, that would be awesome. If changes need to be made, they should be pretty simple.


Mysql Strict Mode Compliance? - mudmin - 10-08-2017

I will definitely go through and change the schema for upcoming releases. Thanks for bringing this to my attention as I use mariaDB