blog gets offline when posting new message

[brakke]

Hello,

Not 100% sure this is a bug but this is my problem.
I had some problems with my weblog so I started from 0 with the newest version: 0.9.1.

I posted a first post without any problem, but when trying to post a second entry, I can't see my weblog anymore. Instead it is giving the following SQL error:

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.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
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= '1134022516' AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15


/ Can't create/write to file '/tmp/#sql_8dd_0.MYI' (Errcode: 13)

Any idea what the problem can be?

[garvinhicking]

That means you are out of disk-space, or your MySQL server is malfunctioning.

Please talk to your system administrator and give him this error message:

/ Can't create/write to file '/tmp/#sql_8dd_0.MYI' (Errcode: 13)

you could also google up "errcode 13 mysql".

Regards,
Garvin