Unable to add Users
Unable to add Users
When I try adding new users, I am getting Error while processing the requested operation. Here is my system settings:
Server configuration
Server address:
Server port: 443
Server name: learntapos.net
Server admin mail:
Server software: Microsoft-IIS/7.5
MySQL information
MySQL version: 5.6.25-log
Sql mode: STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Mysql Encoding: utf8
Mysql Collation: utf8_general_ci
Mysql Timezone: SYSTEM
Info about PHP
PHP version: 5.4.42
Site Timezone: America/Chicago
"safe_mode" configuration: Off
Configuration of "register_global": Off
Configuration of "magic_quotes_gpc": Off
Configuration of "upload_max_filesize": 10000M
Configuration of "post_max_size": 10000M
Configuration of "max_execution_time": 300s
LDAP: Off Consider this parameter only if you need to authenticate through LDAP
Configuration of "allow_url_include": Off
Php extension php_openssl: On
Configuration of "allow_url_fopen": Off Attention without these settings the social login will not work
Server configuration
Server address:
Server port: 443
Server name: learntapos.net
Server admin mail:
Server software: Microsoft-IIS/7.5
MySQL information
MySQL version: 5.6.25-log
Sql mode: STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Mysql Encoding: utf8
Mysql Collation: utf8_general_ci
Mysql Timezone: SYSTEM
Info about PHP
PHP version: 5.4.42
Site Timezone: America/Chicago
"safe_mode" configuration: Off
Configuration of "register_global": Off
Configuration of "magic_quotes_gpc": Off
Configuration of "upload_max_filesize": 10000M
Configuration of "post_max_size": 10000M
Configuration of "max_execution_time": 300s
LDAP: Off Consider this parameter only if you need to authenticate through LDAP
Configuration of "allow_url_include": Off
Php extension php_openssl: On
Configuration of "allow_url_fopen": Off Attention without these settings the social login will not work
Re: Unable to add Users
The problem is related to mysql configuration . in particular with
i.e
remove from "SQL MODE" the STRICT_TRANS_TABLES options. You must edit the my.ini or my.cnf ( depending on your configuration) and modify the line options . If you don't have a corresponding line , add a new one in the section [mysqld]Sql mode: STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
i.e
Code: Select all
[mysqld]
sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Cercate nel forum le riposte prima di chiedere. Check the forum before posting
---------------
Claudio Anelli
Joint Technologies - Sistemi avanzati per l'information technology
http://www.joint-tech.com
---------------
---------------
Claudio Anelli
Joint Technologies - Sistemi avanzati per l'information technology
http://www.joint-tech.com
---------------
Re: Unable to add Users
Thank you. That took care of it. I missed that when my server rebooted.
Re: Unable to add Users
Moving this thread to "installation and configuration" forum