FUDforum: How To » UNABLE TO WRITE TO SQL LOG FILE

Home » FUDforum » How To » UNABLE TO WRITE TO SQL LOG FILE

Show: Today's Messages :: Polls :: Message Navigator

UNABLE TO WRITE TO SQL LOG FILE [message #30172]

Thu, 09 February 2006 02:34

duru1

Messages: 24
Registered: September 2005

Karma: 0

Junior Member

UNABLE TO WRITE TO SQL LOG FILE
(/opt/xampp/htdocs/index.php:116
/opt/xampp/htdocs/index.php:214
/opt/xampp/htdocs/index.php:302
/opt/xampp/htdocs/index.php:939
/opt/xampp/htdocs/index.php:1110
) 1017: Can't find file: './fudbase/fud26_users.frm' (errno: 24)
Query: SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt, u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq FROM fud26_ses s INNER JOIN fud26_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN fud26_themes t ON t.id=u.theme WHERE s.ses_id='f710a44c5d85388a2f619f5c052e5061'
Server Version: 4.0.18-log

What seems to cause this, it has been happening quit often?
I seem to fix the problem by running myisamchk.

Report message to a moderator

Re: UNABLE TO WRITE TO SQL LOG FILE [message #30176 is a reply to message #30172]

Thu, 09 February 2006 17:59

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

This a MySQL error indicating that a critical database file went away or a table became corrupt and can no longer parse the relavent file. This is not a forum bug, but a rather a MySQL issue that affects the forum's operation.

FUDforum Core Developer

Report message to a moderator