cwp does not show websites on cgroups page?

[furkany]

hello my dear friends.

cgroups page in panel not showing websites list? this was working before. I'm using vps before, the vps disk size was 200gb, then I upgraded it to 400gb. but it was working. suddenly disappeared no more website list. please help me?

https://prnt.sc/n2hZLwXpvSYg

[cyberspace]

The service could be disabled in autoboot. It could be case if the server was rebooted after the upgrade. So make sure the service is running.

[furkany]

I found that the problem is as follows.
I changed mysql my.cnf file because I got a mysql error on some sites. but when I did this, the cgroups page did not work and no data came in the list user page. Removed sql_mode="" and everything was fine. but mysql errors still continue, I would be very happy if you could help me with this. Thank you from now.

I'm sharing it in case it happens to other friends.

[cyberspace]

Connect to mysql/mariadb as root and run the following SQL command/query:

Code Select Expand

show variables like "sql_mode";

I get "NO_ENGINE_SUBSTITUTION" only. In case you get something else, set:

Code Select Expand

sql_mode="NO_ENGINE_SUBSTITUTION"

in my.cnf and restart MySQL/MariaDB.

If it doesn't help either, provide us with the SQL error mentioned by you and detail what MySQL/MariaDB version you use.