{"id":917,"date":"2022-12-10T18:23:42","date_gmt":"2022-12-10T12:23:42","guid":{"rendered":"https:\/\/mellowhost.com\/blog\/?p=917"},"modified":"2022-12-10T18:23:42","modified_gmt":"2022-12-10T12:23:42","slug":"could-not-make-the-query-virtualizor-error","status":"publish","type":"post","link":"https:\/\/mellowhost.com\/blog\/could-not-make-the-query-virtualizor-error.html","title":{"rendered":"Could not make the Query. Virtualizor Error"},"content":{"rendered":"\n<p>Today, when I opened a Virtualizor panel for a VM node, I found an issue like the following:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Could not make the Query.\nSELECT 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\nArray\n(\n    [0] => HY000\n    [1] => 144\n    [2] => Table '.\/virtualizor\/tasks' is marked as crashed and last (automatic?) repair failed<\/pre>\n\n\n\n<p>Issue was the tasks table is marked as crashed. To solve this, we need to repair the table tasks. <\/p>\n\n\n\n<p>First, find the password for database &#8216;virtualizor&#8217; using the following command:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">[root@sg40 ~]# grep dbpass \/usr\/local\/virtualizor\/universal.php\n$globals['dbpass'] = 'gziqr4y989';<\/pre>\n\n\n\n<p>Now connect to the mysql using the password:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/usr\/local\/emps\/bin\/mysql -u root -p virtualizor<\/pre>\n\n\n\n<p>Now repair the table:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">use virtualizor;\nREPAIR TABLE tasks;<\/pre>\n\n\n\n<p>Now the virtualizor shall work.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today, when I opened a Virtualizor panel for a VM node, I found an issue like the following: 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 &#8216;virtualizor&#8217; using the following command: Now connect to the mysql using the &hellip; <a href=\"https:\/\/mellowhost.com\/blog\/could-not-make-the-query-virtualizor-error.html\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Could not make the Query. Virtualizor Error&#8221;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[423],"tags":[159,426,703],"_links":{"self":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/917"}],"collection":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/comments?post=917"}],"version-history":[{"count":1,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/917\/revisions"}],"predecessor-version":[{"id":918,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/917\/revisions\/918"}],"wp:attachment":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/media?parent=917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/categories?post=917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/tags?post=917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}