query failed
Posted: Thu Oct 01, 2015 5:36 pm
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
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