Serendipity Forums

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
s9y_entries AS e
LEFT JOIN s9y_authors a
ON e.authorid = a.authorid
LEFT JOIN s9y_entrycat ec
ON e.id = ec.entryid
LEFT JOIN s9y_category c
ON ec.categoryid = c.categoryid
LEFT JOIN s9y_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN s9y_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 <= 1146178302 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

/ Table 'raymond_blog.s9y_entries' doesn't exist

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, (email) and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

BTW, why does s9y require a table prefix? What if I gave it its own DB and I don't want a prefix? Can't it accept a null value?

A security module that we have installed did not allow the saving of the configuration because it matched the pattern "/bin/" which is called in functions_installer.inc.php.

Since this is not a security issue I disabled our module for your blog directory to fix the problem. You admin configuration saved with no errors now.