Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 10:34 pm EST
Geeklog Forums
SQL error
MZ1
Anonymous
everytime i click on mysite.com/index.php i get the error:
but when i go to staticpages, filemgmt, and all my sections i dont recieve this error.
"An SQL error has occurred. Please see error.log for details"..
My error log:
Sun 10 May 2009 01:48:00 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
Sun 10 May 2009 01:48:01 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
Sun 10 May 2009 01:48:03 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
Sun 10 May 2009 01:50:05 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
Sun 10 May 2009 01:50:09 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
i tryed to repair the table, but there is the problem again.. and again...
and i dont know what to do... please i realy need help with this
but when i go to staticpages, filemgmt, and all my sections i dont recieve this error.
"An SQL error has occurred. Please see error.log for details"..
My error log:
Text Formatted Code
Sun 10 May 2009 01:47:58 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5 Sun 10 May 2009 01:48:00 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
Sun 10 May 2009 01:48:01 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
Sun 10 May 2009 01:48:03 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
Sun 10 May 2009 01:50:05 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
Sun 10 May 2009 01:50:09 UTC - 1: Can't create/write to file '/tmp/#sql_5236_0.MYD' (Errcode: 17). SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 ORDER BY featured DESC, date DESC LIMIT 0, 5
i tryed to repair the table, but there is the problem again.. and again...
and i dont know what to do... please i realy need help with this
13
10
Quote
MZ1
Anonymous
Quote by: Dirk
Looks like a problem with the filesystem the MySQL server is running on. Contact your hosting provider.
bye, Dirk
the webhosting says:
The /tmp cache of your mysql database was corrupt, I have restored it and now your site is serving normally.
thank you for your anwser
:banana:
8
14
Quote
All times are EST. The time is now 10:34 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content