Differences

This shows you the differences between two versions of the page.

--- virtualizor:table-tasks-error-repair [2025/01/18 00:52] – created kbadmin
+++ virtualizor:table-tasks-error-repair [2025/01/18 04:58] (current) – [2. Kedua] kbadmin
@@ Line 1: / Line 1: @@
 ====== 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                                     |
++-------------------+--------+----------+------------------------------------------------------+
+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       |
++-------------------+--------+----------+----------+
+row in set (1.33 sec)
+</code>
+Berhasil, selamat mencoba

Layanan