Today, when I opened a Virtualizor panel for a VM node, I found an issue like the following:
Could not make the Query. SELECT tasks.actid, tasks.action, users.uid, users.email FROM `tasks` LEFT JOIN users on tasks.uid = users.uid WHERE action NOT IN ('vpsbackups_plan_email', 'send_background_mail', 'backuply_vpsbackups_plan_email') ORDER BY tasks.actid DESC LIMIT 10 Array (  => HY000  => 144  => Table './virtualizor/tasks' is marked as crashed and last (automatic?) repair failed
Issue was the tasks table is marked as crashed. To solve this, we need to repair the table tasks.
First, find the password for database ‘virtualizor’ using the following command:
[[email protected] ~]# grep dbpass /usr/local/virtualizor/universal.php $globals['dbpass'] = 'gziqr4y989';
Now connect to the mysql using the password:
/usr/local/emps/bin/mysql -u root -p virtualizor
Now repair the table:
use virtualizor; REPAIR TABLE tasks;
Now the virtualizor shall work.