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