change admin folder name results in 404 error

[clusterx]

if I change the admin folder e.g. to "PPpAA23wTiSvwfm"
this is saved correctly but when I log out & log in again with the new URL, I get a 404 error
Page not found!

https://www.mydomain.tld/client/PPpAA23wTiSvwfm/login

I also get an error message when changing mysql strict mode to off:

nano /etc/mysql/my.cnf
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
unknown variable 'sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

Debian 10
MariaDB 10.3
PHP 7.3-fpm

Edited May 15, 2021 by clusterx

[Onur]

29 minutes ago, clusterx said:

if I change the admin folder e.g. to "PPpAA23wTiSvwfm"
this is saved correctly but when I log out & log in again with the new URL, I get a 404 error
Page not found!

https://www.mydomain.tld/client/PPpAA23wTiSvwfm/login

Most likely you forgot the new url or it is not like you defined earlier. Please send me your phpmyadmin panel login information via private message. I will do a reset for you and then change the admin path to "PPpAA23wTiSvwfm" and we will see the situation together.

 

30 minutes ago, clusterx said:

I also get an error message when changing mysql strict mode to off:

nano /etc/mysql/my.cnf
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
unknown variable 'sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

 

The definition you add should be under the [mysqld] line. If your file does not contain the line [mysqld], you can add it manually.

Please define as below. If possible, edit and save the "/etc/mysql/my.cnf" file after SSH login with Filezilla.

Quote

sql_mode=

 

[clusterx]

thank you!

changing the admin folder name worked now, it seems that only lower case letters are accepted here

when I do a check in mysql the following is displayed

mysql -u root -p -e "SHOW VARIABLES LIKE 'sql_mode';"
+---------------+-------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                     |
+---------------+-------------------------------------------------------------------------------------------+
| sql_mode      | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+-------------------------------------------------------------------------------------------+

It seems the strict mode is already off, but the health status shows a message to turn it of in /etc/mysql/my.cnf

[clusterx]

ok I got it, I missed to add the [mysqld] section header 😀

thank you Onur!