Error with the database

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,50,84,67,1,34,35,10,2 5,78,40,3,4,6,7,36,9,15,22,33,13,37,17,2,27,24,21,76,77,80,1 6,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

Re: Error with the database

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."

Thaqalainnaqvi@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,50,84,67,1,34,35,10,2 5,78,40,3,4,6,7,36,9,15,22,33,13,37,17,2,27,24,21,76,77,80,1 6,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

Re: Error with the database

>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,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.

Re: Error with the database

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