Page 1 of 1

Error when opening blog

Posted: Tue Mar 02, 2010 2:22 am
by hubber
Just went to my site, which is done with Serendipity and got the following instead of my front page.
Haven't got a clue what it means. Can anyone help?

Query failed:
SELECT


e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid

WHERE isdraft = 'false' AND e.timestamp <= 1267492800
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 2
/ Can't create/write to file '/tmp/#sql_6fde_0.MYD' (Errcode: 17)

Re: Error when opening blog

Posted: Tue Mar 02, 2010 2:44 am
by hubber
Problem solved, did some searching, contacted my ISP and they corrected it immediately.

Re: Error when opening blog

Posted: Tue Mar 02, 2010 6:01 am
by Don Chambers
Perhaps you can post the solution here just in case it helps someone else in the future? :wink:

Re: Error when opening blog

Posted: Tue Mar 02, 2010 9:22 am
by kleinerChemiker
This is an MySQL error and only the provider can correct it.