 the table forumsfud_read.MYD broke twice in two days.... [message #26022] |
Fri, 01 July 2005 06:55  |
matthieu_phpmv
Messages: 44
Registered: November 2004
Karma:
|
Member |
|
|
Hello
yesterday afternoon was an error saying Can't open file: 'forumsfud_read.MYD'
The admin restored a save of the table but today when I try to answer a message, I see
| Quote: |
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /home/phpmyvis/www/forums/index.php on line 58
|
And back on the /forums/ page i see
| Quote: |
(/home/phpmyvis/www/forums/index.php:125
/home/phpmyvis/www/forums/index.php:225
/home/phpmyvis/www/forums/theme/FRANCAIS/msg.php:801
/home/phpmyvis/www/forums/index.php:1178
) 1016: Can't open file: 'forumsfud_read.MYD'. (errno: 144)
Query: SELECT c.id AS cat_id, f.name, m.subject, t.id, t.forum_id, t.replies, t.rating, t.n_rating, t.root_msg_id, t.moved_to, t.thread_opt, t.last_post_date, tn.thread_id AS subscribed, mo.forum_id AS md, tr.thread_id AS cant_rate, r.last_view, r2.last_view AS last_forum_view, tv.pos AS th_pos, tv.page AS th_page, m2.thread_id AS last_thread, (CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) AS group_cache_opt FROM forumsfud_thread t INNER JOIN forumsfud_msg m ON m.id=t.root_msg_id INNER JOIN forumsfud_forum f ON f.id=t.forum_id INNER JOIN forumsfud_cat c ON f.cat_id=c.id INNER JOIN forumsfud_thread_view tv ON tv.forum_id=t.forum_id AND tv.thread_id=t.id INNER JOIN forumsfud_msg m2 ON f.last_post_id=m2.id LEFT JOIN forumsfud_thread_notify tn ON tn.user_id=4 AND tn.thread_id=1786 LEFT JOIN forumsfud_mod mo ON mo.user_id=4 AND mo.forum_id=t.forum_id LEFT JOIN forumsfud_thread_rate_track tr ON tr.thread_id=1786 AND tr.user_id=4 LEFT JOIN forumsfud_read r ON r.thread_id=t.id AND r.user_id=4 LEFT JOIN forumsfud_forum_read r2 ON r2.forum_id=t.forum_id AND r2.user_id=4 INNER JOIN forumsfud_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id LEFT JOIN forumsfud_group_cache g2 ON g2.user_id=4 AND g2.resource_id=f.id WHERE t.id=1786
_GET: rid=4&t=msg&th=1786&SQ=e2e18e615c48b13e971d5b487202a2e3&
Server Version: 3.23.58-log
[Referring Page] http://www.phpmyvisites.net/forums/index.php/f/7/4/
|
What could be the source of these problems ? Please help.
I don't know what to do, because if I restore the database, it will break again I think ?
Thank you ilia
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]