Error with the database

[Thaqalainnaqvi]

There appears to be an error with the database.
You can try to refresh the page by clicking here.

Error Returned

mySQL query error: SELECT t.forum_id, COUNT(p.author_id) as f_posts
FROM ib_posts p
LEFT JOIN ib_topics t ON ( p.topic_id=t.tid AND t.forum_id IN
(0,74,68,75,69,73,70,71,72,79,28,29,30,32,41,85,42 ,43,66,52,54,55,51,53,58,56,62,63,65,26,47,61,60,5 0,84,67,1,34,35,10,25,78,40,3,4,6,7,36,9,15,22,33, 13,37,17,2,27,24,21,76,77,80,16,59,49,19,86,87,45, 46)
)
WHERE p.author_id=10844 AND t.tid IS NOT NULL
GROUP BY t.forum_id
ORDER BY f_posts DESC

SQL error: Can't open file: 'ib_posts.MYI' (errno: 144)
SQL error code:
Date: Sunday 01st of October 2006 07:38:20 PM

How can I fix that error

[Peter]

Try cutting and pasting the t.forum_id clause before the group by
statement.

It is not joining to anything... it's saying "filter by forum."

Th************@gmail.com wrote:

There appears to be an error with the database.
You can try to refresh the page by clicking here.

Error Returned

mySQL query error: SELECT t.forum_id, COUNT(p.author_id) as f_posts
FROM ib_posts p
LEFT JOIN ib_topics t ON ( p.topic_id=t.tid AND t.forum_id IN
(0,74,68,75,69,73,70,71,72,79,28,29,30,32,41,85,42 ,43,66,52,54,55,51,53,58,56,62,63,65,26,47,61,60,5 0,84,67,1,34,35,10,25,78,40,3,4,6,7,36,9,15,22,33, 13,37,17,2,27,24,21,76,77,80,16,59,49,19,86,87,45, 46)
)
WHERE p.author_id=10844 AND t.tid IS NOT NULL
GROUP BY t.forum_id
ORDER BY f_posts DESC

SQL error: Can't open file: 'ib_posts.MYI' (errno: 144)
SQL error code:
Date: Sunday 01st of October 2006 07:38:20 PM

How can I fix that error

[Gordon Burditt]

>There appears to be an error with the database.

>You can try to refresh the page by clicking here.

Error Returned

mySQL query error: SELECT t.forum_id, COUNT(p.author_id) as f_posts
FROM ib_posts p
LEFT JOIN ib_topics t ON ( p.topic_id=t.tid AND t.forum_id IN
(0,74,68,75,69,73,70,71,72,79,28,29,30,32,41,85,4 2,43,66,52,54,55,51,53,58,56,62,63,65,26,47,61,60, 50,84,67,1,34,35,10,25,78,40,3,4,6,7,36,9,15,22,33 ,13,37,17,2,27,24,21,76,77,80,16,59,49,19,86,87,45 ,46)
)
WHERE p.author_id=10844 AND t.tid IS NOT NULL
GROUP BY t.forum_id
ORDER BY f_posts DESC

SQL error: Can't open file: 'ib_posts.MYI' (errno: 144)

You have a crashed table. Execute "REPAIR TABLE" on every table mentioned
in the query.

[Thaqalainnaqvi]

Thats being repaired and now I am again getting following error:

IPB WARNING [2] mysql_query() [function.mysql-query]: Unable to save
result set (Line: 457 of /ips_kernel/class_db_mysql.php)
There appears to be an error with the database.
You can try to refresh the page by clicking here.

Error Returned
mySQL query error: SELECT MIN(pid) as pid FROM ib_posts WHERE queued=0
AND topic_id=85734 AND post_date 1160298086 LIMIT 0,1

SQL error: Got error 134 from storage engine
SQL error code:
Date: Wednesday 13th of October 2006 04:51:36 PM