I've installed Serendipity on my server with apache, mod_rewrite an PostgreSQL. Everything work just fine, but when I click on the title of the entry I get 'No entries to print' message instead of the entry view. I tried switching mod_rewrite off, but it didn't help. How can I fix it?
SQL log entry looks like this:
Code: Select all
ERROR: operator does not exist: integer ~~ unknown at character 1559
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: SELECT e.id,
e.title,
e.timestamp,
e.body,
e.comments,
e.trackbacks,
e.extended,
e.exflag,
e.authorid,
e.isdraft,
e.allow_comments,
e.last_modified,
e.moderate_comments,
a.realname AS author,
a.username AS loginname,
a.email
FROM
serendipity_entries 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 = 2
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
e.id LIKE '9'
AND e.isdraft = 'false' AND e.timestamp <= 1204208700 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
LIMIT 1
And I can't locate place, where the query is built... I'll stay in toutch.