Repair jos_session table joomla

Setelah listrik padam, web saya menjadi tidak dapat diakses, dan muncul pesan error berikut ini:

jtablesession::Store Failed
DB function failed with error number 145
Table ‘./fk/jos_session’ is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( ‘7502d90bd7d1810adb11a68f559c1c10′,’1382490022′,”,’0′,’1′,’0’ )

Web saya memakai Joomla sebagai CMS dan FreeBSD sebagai OS webservernya. Adapun cara untuk resolvnya adalah:

1. Masuk ke web server

2.  Masuk ke MySQL database server dengan cara:

n# mysql -u admin -p

3. Kemudian Masuk keDB dari web yang error tadi:

n# mysql -u admin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 62726
Server version: 5.1.60 FreeBSD port: mysql-server-5.1.60

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| fk |
| mysql |
+——————–+
5 rows in set (0.01 sec)

mysql> use fk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>

4. Repair table yang error yaitu jos_session dengan perintah:

mysql> repair table jos_session;

+—————-+——–+———-+—————————————— ———————————–+
| Table | Op | Msg_type | Msg_text |
+—————-+——–+———-+—————————————— ———————————–+
| fk.jos_session | repair | info | Wrong block with wrong total length start ing at 286988 |
| fk.jos_session | repair | info | Wrong block with wrong total length start ing at 287056 |
| fk.jos_session | repair | info | Wrong block with wrong total length start ing at 287124 |
| fk.jos_session | repair | info | Found link that points at 737730677328080 9274 (outside data file) at 287200 |
| fk.jos_session | repair | info | Found link that points at 824199459006389 8474 (outside data file) at 287268 |
| fk.jos_session | repair | info | Found block that points outside data file at 287336 |
| fk.jos_session | repair | info | Found block that points outside data file at 287404 |
| fk.jos_session | repair | info | Found block that points outside data file at 287472 |
| fk.jos_session | repair | info | Found block that points outside data file at 287540 |
| fk.jos_session | repair | info | Found block that points outside data file at 287608 |
| fk.jos_session | repair | info | Found block with too small length at 2876 68; Skipped |
| fk.jos_session | repair | info | Wrong block with wrong total length start ing at 288900 |
| fk.jos_session | repair | info | Found block that points outside data file at 288976 |
| fk.jos_session | repair | info | Found block that points outside data file at 289012 |
| fk.jos_session | repair | info | Found link that points at 793941118925651 6142 (outside data file) at 289112 |
| fk.jos_session | repair | info | Found block that points outside data file at 289148 |
| fk.jos_session | repair | info | Wrong block with wrong total length start ing at 303904 |
| fk.jos_session | repair | info | Found block that points outside data file at 304048 |
| fk.jos_session | repair | info | Found block that points outside data file at 304116 |
| fk.jos_session | repair | info | Found block that points outside data file at 304184 |
| fk.jos_session | repair | info | Found block that points outside data file at 304252 |
| fk.jos_session | repair | info | Found block that points outside data file at 304320 |
| fk.jos_session | repair | info | Found link that points at 737730677328080 9274 (outside data file) at 305008 |
| fk.jos_session | repair | info | Wrong block with wrong total length start ing at 305516 |
| fk.jos_session | repair | info | Found block that points outside data file at 305592 |
| fk.jos_session | repair | info | Wrong block with wrong total length start ing at 311108 |
| fk.jos_session | repair | info | Found block that points outside data file at 311388 |
| fk.jos_session | repair | info | Found block with too small length at 3863 40; Skipped |
| fk.jos_session | repair | info | Found block with too small length at 3865 44; Skipped |
| fk.jos_session | repair | warning | Number of rows changed from 162 to 139 |
| fk.jos_session | repair | status | OK |
+—————-+——–+———-+—————————————— ———————————–+
31 rows in set (0.05 sec)

mysql>

5. Kalau sudah Ok, maka web sudah bisa diakses kembali.

Selesai.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s