Author Topic: cwp does not show websites on cgroups page?  (Read 1931 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
cwp does not show websites on cgroups page?
« on: May 17, 2023, 06:20:20 AM »
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

Offline
***
Re: cwp does not show websites on cgroups page?
« Reply #1 on: May 19, 2023, 07:24:10 PM »
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.

Offline
*
Re: cwp does not show websites on cgroups page?
« Reply #2 on: May 22, 2023, 10:57:27 AM »
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.

Offline
***
Re: cwp does not show websites on cgroups page?
« Reply #3 on: May 22, 2023, 02:54:37 PM »
Connect to mysql/mariadb as root and run the following SQL command/query:

Code: [Select]
show variables like "sql_mode";
I get "NO_ENGINE_SUBSTITUTION" only. In case you get something else, set:

Code: [Select]
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.