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:

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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Looks like a problem with the filesystem the MySQL server is running on. Contact your hosting provider.

bye, Dirk
 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:
 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