Virtualizor kita keluar error seperti ini _“Could not make the Query. SELECT tasks.actid, tasks.action, users.uid, users.email FROM `tasks` LEFT JOIN users on tasks.uid = “_ maka bagaimana solusinya ?

Kita sudah menggunakan perintah repair disini https://www.virtualizor.com/docs/admin/repair-database/ dengan menjalankan perintah :

root# /usr/local/emps/bin/php /usr/local/virtualizor/scripts/repair_db.php 

akan tetapi database dengan table tasks masih error, maka kita coba cari solusi lain yaitu dengan.

Kita cari user dan password database mysql virtualizor, dimana bisa ditemukan disini

cat /usr/local/virtualizor/universal.php | grep db

kita catat user dan password mysql virtualizor tsb

Login ke mysql virtualizor dengan cara

/usr/local/emps/bin/mysql -u root -p

kemudian masukkan passwordnya

setelah login coba repair.

mysql> use virtualizor
Database changed
mysql> repair table tasks;
+-------------------+--------+----------+------------------------------------------------------+
| Table             | Op     | Msg_type | Msg_text                                             |
+-------------------+--------+----------+------------------------------------------------------+
| virtualizor.tasks | repair | error    | Can't create new tempfile: './virtualizor/tasks.TMD' |
| virtualizor.tasks | repair | status   | Operation failed                                     |
+-------------------+--------+----------+------------------------------------------------------+
2 rows in set (0.00 sec)

anda bisa perhatikan ada error pada './virtualizor/tasks.TMD'

pindahkan file tersebut ke tempat lain

mv /usr/local/emps/var/mysql/virtualizor/tasks.TMD  /root/

kemudian ulangi repair

mysql> repair table tasks;
+-------------------+--------+----------+----------+
| Table             | Op     | Msg_type | Msg_text |
+-------------------+--------+----------+----------+
| virtualizor.tasks | repair | status   | OK       |
+-------------------+--------+----------+----------+
1 row in set (1.33 sec)

Berhasil, selamat mencoba