# mysql --version
mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper
Yes, it is the same Version
Posts by lorddeath87
-
-
Nach einer neuinstallierung von imscp war der fehler behoben
-
This failure occours each time when I update the Password.
When I create a new user I get the following error message:Display MoreCode- An exception has been thrown in file
- /var/www/imscp/gui/library/Functions/Shared.php at line 2345:
- ==========================================================================
- SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'imscp.sql_user.sqlu_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
- Query was:
- SELECT sqlu_id, sqlu_name, sqlu_host FROM sql_user INNER JOIN
- sql_database USING(sqld_id) WHERE domain_id = :domain_id AND
- sqld_id != :sqld_id AND CONCAT(sqlu_name, sqlu_host) NOT IN(
- SELECT CONCAT(sqlu_name, sqlu_host) FROM sql_user WHERE sqld_id = :sqld_id
- ) GROUP BY sqlu_name, sqlu_host
- ==========================================================================
- Backtrace:
- __________
- File: /var/www/imscp/gui/public/client/sql_user_add.php at line 82
- Function: exec_query()
- File: /var/www/imscp/gui/public/client/sql_user_add.php at line 379
- Function: client_generateSqlUserList()
- Contextual information:
- _______________________
- Http User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0)
- Gecko/20100101 Firefox/53.0
- Request Uri: /client/sql_user_add.php?id=21 Http Referer: https://panel.xxx.de:8443/client/sql_manage.php
- Remote Addr: 84.115.253.xx
- Server Addr: 82.220.38.xx
-
Hallo
ich habe folgende Fehlermeldung beim anlegen eines Mysql Nutzers bekommen:
Display MoreCode- An exception has been thrown in file
- /var/www/imscp/gui/library/Functions/Shared.php at line 2345:
- ==========================================================================
- SQLSTATE[HY000]: General error: 1396 Operation ALTER USER failed for '2_shop'@'localhost'
- Query was:
- ALTER USER ?@? IDENTIFIED BY ? PASSWORD EXPIRE NEVER ==========================================================================
- Backtrace:
- __________
- File: /var/www/imscp/gui/public/client/sql_change_password.php at line
- 109
- Function: exec_query()
- File: /var/www/imscp/gui/public/client/sql_change_password.php at line
- 157
- Function: client_updateSqlUserPassword()
- Contextual information:
- _______________________
- Http User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0)
- Gecko/20100101 Firefox/53.0
- Request Uri: /client/sql_change_password.php?id=10
- Http Referer:
- https://panel.xx.de:8443/client/sql_change_password.php?id=10
- Remote Addr: 84.115.253.xx
- Server Addr: 82.220.38.xx
Debian Jessie
i-MSCP 1.4.3
Build: 20170417
Codename: Zimmer
MySQL: 5.7.18
Apache/2.4.10 (Debian)
Dovecot: 2.2.13 -
Yes, I think so, too.
No further error has occurred. -
This is only for me that I see the difference.
-
Yes it is the same error.
Can you change it for everyone at Github? -
Distro Debian Jessie
Dovecot 2.2.13 -
Hallo zusammen kann das sein, dass in der Dovecot.conf in der Version 1.4.3 ein Fehler enthalten ist?
Ich erhalte immer "Error: quota: Unknown namespace: Trash".
Nach auskommentieren von "quota_rule2 = Trash:storage=+100M" in der dovecot.conf ist der Fehler weg. -
Ok, i send the Log
My Distro is Debian Wheezy 8.7
IMSCP 1.4.1 Zimmer
Plugins:
Roundcube
ClamAV
OpenDKIMPolicydSPF
PolicydWeight
Postgrey
SpamAssassinit was send through Outlook 2016 and Roundcube Webmail both do the same error