query failed

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
jason2077
Posts: 1
Joined: Thu Oct 01, 2015 5:29 pm

query failed

Post 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
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: query failed

Post 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.
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Post Reply