| Can't find file: 'fud1_fc_view.MYD' [message #20178] |
Thu, 30 September 2004 20:05  |
spacemanbiff
Messages: 3
Registered: September 2004
Karma: 0
|
Junior Member |
|
|
I'm in serious trouble here. I installed FUDforum with no problem, started to use it and today I started my first backup and I have run into problems. I did not realize that I had run out of disk space so the backup did not complete and now I cannot even get the home page back. I get the following error when trying to opening up the front page to my forum.
/var/www/html/crabforum/index.php) 1017: Can't find file: 'fud1_fc_view.MYD' (errno: 2)
Query: SELECT m.subject, m.id, m.post_stamp, u.id, u.alias, c.description, c.name, c.cat_opt, f.cat_id, f.forum_icon, f.id, f.last_post_id, f.moderators, f.name, f.descr, f.post_count, f.thread_count, fr.last_view, mo.id AS md, CASE WHEN g2.group_cache_opt IS NULL THEN g1.group_cache_opt ELSE g2.group_cache_opt END AS group_cache_opt FROM fud1_fc_view v INNER JOIN fud1_forum f ON f.id=v.f INNER JOIN fud1_cat c ON c.id=v.c INNER JOIN fud1_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id LEFT JOIN fud1_msg m ON f.last_post_id=m.id LEFT JOIN fud1_users u ON u.id=m.poster_id LEFT JOIN fud1_forum_read fr ON fr.forum_id=f.id AND fr.user_id=2 LEFT JOIN fud1_mod mo ON mo.user_id=2 AND mo.forum_id=f.id LEFT JOIN fud1_group_cache g2 ON g2.user_id=2 AND g2.resource_id=f.id ORDER BY v.id
Server Version: 3.23.58
I checked mysql and basically it's missing the fud1_fc_view.MYD file. Without a backup, how can I get my forum back, it has some very important information I really need in it.
Please help, in desperation here!!
|
|
|
|
|
|
|
|
| Re: Can't find file: 'fud1_fc_view.MYD' [message #20187 is a reply to message #20183] |
Thu, 30 September 2004 22:45  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Try running:
REPAIR fud1_fc_view; query in mysql client as admin user.
If that fails, you can drop the table, import it from the fud_fc_view.tbl defenition and then go into FUDforum's admin control and run consistency checker. This will rebuild data inside this table.
FUDforum Core Developer
|
|
|
|
| Re: Can't find file: 'fud1_fc_view.MYD' [message #20191 is a reply to message #20178] |
Thu, 30 September 2004 23:35 |
spacemanbiff
Messages: 3
Registered: September 2004
Karma: 0
|
Junior Member |
|
|
Ah you are a life saver!
The REPAIR TABLE fud1_fc_view; did not work.
I did however get it to work by removing the table from the database by going into mysql as root and using this command:
truncate table fud1_fc_view;
Then I restarted my forum and ran the consitency checker as you mentioned and everything returned to normal.
Thanks again, I now have a good backup of my database as well as my forum.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]