FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » UNABLE TO WRITE TO SQL LOG FILE
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
UNABLE TO WRITE TO SQL LOG FILE [message #30172] Thu, 09 February 2006 02:34 Go to next message
duru1 is currently offline  duru1   United States
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.
Re: UNABLE TO WRITE TO SQL LOG FILE [message #30176 is a reply to message #30172] Thu, 09 February 2006 17:59 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: UNABLE TO WRITE TO SQL LOG FILE [message #30180 is a reply to message #30176] Thu, 09 February 2006 18:05 Go to previous messageGo to next message
duru1 is currently offline  duru1   United States
Messages: 24
Registered: September 2005
Karma: 0
Junior Member
Could this be caused by users sending large amounts of data
as a text or html file to the forum instead of sending an attachement.
Re: UNABLE TO WRITE TO SQL LOG FILE [message #30200 is a reply to message #30180] Sat, 11 February 2006 20:00 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
No.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Example of "Syndicating this forum" shows disabled or error message
Next Topic: Breaking out of frames
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 02:16:45 GMT 2024

Total time taken to generate the page: 0.03121 seconds