Page 1 of 1

query failed

Posted: Thu Oct 01, 2015 5:36 pm
by jason2077
On my website I have a link that brings me to my serendipity page. Today I got the following message. I tried reinstalling all the serendipity files on the server but still got the same message. Yesterday I accidentally downloaded viruses on my desktop. The credentials for serendipity were saved in windows to auto fill. I tried using these credentials on the serendipity homepage but they are no recognized. This was the first time I tried using these credentials on the serendipity homepage. So I am not sure if this query fail is caused by viruses or something else. Please 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
sere_entries AS e
LEFT JOIN sere_authors a
ON e.authorid = a.authorid
LEFT JOIN sere_entrycat ec
ON e.id = ec.entryid
LEFT JOIN sere_category c
ON ec.categoryid = c.categoryid
LEFT JOIN sere_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN sere_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 <= 1443714000 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id

ORDER BY timestamp DESC
LIMIT 15
/ Got error 28 from storage engine

Re: query failed

Posted: Thu Oct 01, 2015 6:24 pm
by Timbalu
https://www.google.de/search?q=Got+erro ... 8&oe=utf-8
Please read some of those, since this Mysql error "Got error 28 from storage engine" normally means "not enough disk space". It may be some other dir or partition as the mysql data dir is on, since it may be the swapping "/tmp" directory for temporary files (by mysql temporary tables) or "/" altogether. Howtos how to get more information which directory or partition has to get cleaned-up, are available in these threads. Else, if you can't do that yourself, talk with your hoster.