PusatHosting Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Virtualizor Tasks table need to repair  ======
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 :

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

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

===== - Pertama =====

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

<code>
cat /usr/local/virtualizor/universal.php | grep db
</code>

kita catat user dan password mysql virtualizor tsb

===== - Kedua =====
Login ke mysql virtualizor dengan cara
<code>
/usr/local/emps/bin/mysql -u root -p
</code>
kemudian masukkan passwordnya

setelah login coba repair.

<code>
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)
</code>

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

pindahkan file tersebut ke tempat lain
<code>
mv /usr/local/emps/var/mysql/virtualizor/tasks.TMD  /root/
</code>

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

Berhasil, selamat mencoba
Layanan
