There was an error adding your user account.

2014-04-24
2014-07-12
  • 0x73746566616e
    0x73746566616e
    2014-04-24

    Hi,
    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.
    Regards

     
  • Pep
    Pep
    2014-04-24

    Hi,
    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.
    https://github.com/phpservermon/phpservermon/issues/66

    Regards,
    Pep

     
  • Viki
    Viki
    2014-05-10

    Hi,

    I have the lastest version still i am facing this issue. Could someone help me on this issue? please.

    Thanks is advance

     
  • Pep
    Pep
    2014-05-10

    Hi,
    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).

    Regards,
    Pep

     
  • Robert Inzano
    Robert Inzano
    2014-07-03

    any update on this? I'm getting the same error.

     
  • Pep
    Pep
    2014-07-11

    Hi Robert,

    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.

    Regards,
    Pep

     
  • Robert Inzano
    Robert Inzano
    2014-07-12

    Pep,

    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 rob@inzanonet.com and I'll do my best to help you.