tried to install PHP Server Monitor on a Windows Server 2012 R2 with PHP 5.5.11 and MySQL 5.6.
But installation fails always with message "There was an error adding your user account."
Message in php_errors.log
[24-Apr-2014 15:08:27 Europe/Berlin] PHP Warning: SQL error: SQLSTATE[HY000]: General error: 1364 Field 'pattern' doesn't have a default value in D:\www\monitoring\src\psm\Service\Database.class.php on line 517
[24-Apr-2014 15:08:27 Europe/Berlin] PHP Warning: SQL error: SQLSTATE[HY000]: General error: 1364 Field 'mobile' doesn't have a default value in D:\www\monitoring\src\psm\Service\Database.class.php on line 517
Could you please help me to fix this? Thanks for help.
This is a problem with MySQL running in strict mode. This bug has already been fixed in the repository and will be included in the next release.
I have the lastest version still i am facing this issue. Could someone help me on this issue? please.
Thanks is advance
There has not been a new release yet which includes this fix, sorry for that. I hope to have the next version out within the next two weeks.
Until then you can try using the release directly from github (although you need to install the dependencies yourself using composer).
any update on this? I'm getting the same error.
Sorry for not having a release available as promised. Holidays and other things have kept me busy unfortunately. If it is possible for you to download a snapshot from github, that should fix it straight away. The next release should definitely be out before the end of the month..
Apologies for the delay.
Thanks, I figured out how to disable strict mode in MySQL and it works now. If anyone needs help with how to do this on a windows machine email me at firstname.lastname@example.org and I'll do my best to help you.