my weblog located at http://ez2cu.free.fr/serendipity stopped to work a few days ago.
The last time it failed was because my ISP had moved my files to another server, but that's not the case this time.
The articles summaries can still be seen, but not the articles, even in the administration part.
I get this error:
Code: Select all
Warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: integer ~~ unknown LINE 37: e.id LIKE '92' ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /mnt/159/sdd/d/a/ez2cu/serendipity/include/db/postgres.inc.php on line 210
Error in 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 = 1 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 ) LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended') LEFT OUTER JOIN serendipity_entryproperties ep_cache_body ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body') LEFT OUTER JOIN serendipity_entryproperties ep_access ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access') WHERE e.id LIKE '92' AND ( c.categoryid IS NULL OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0) OR ( acl_acc.artifact_id IS NULL ) ) AND (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1)) LIMIT 1
ERROR: operator does not exist: integer ~~ unknown LINE 37: e.id LIKE '92' ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
array (
0 =>
array (
'file' => '/mnt/159/sdd/d/a/ez2cu/serendipity/include/functions_entries.inc.php',
'line' => 542,
'function' => 'serendipity_db_query',
'args' =>
array (
0 => '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 = 1
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
) LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended
ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = \'ep_cache_extended\')
LEFT OUTER JOIN serendipity_entryproperties ep_cache_body
ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = \'ep_cache_body\')
LEFT OUTER JOIN serendipity_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = \'ep_access\')
WHERE
e.id LIKE \'92\'
AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
) AND (ep_access.property IS NULL OR ep_access.value = \'member\' OR ep_access.value = \'public\' OR (ep_access.value = \'private\' AND e.authorid = 1))
LIMIT 1',
1 => true,
2 => 'assoc',
),
),
1 =>
array (
'file' => '/mnt/159/sdd/d/a/ez2cu/serendipity/include/admin/entries.inc.php',
'line' => 583,
'function' => 'serendipity_fetchentry',
'args' =>
array (
0 => 'id',
1 => '92',
2 => 1,
3 => 1,
),
),
2 =>
array (
'file' => '/mnt/159/sdd/d/a/ez2cu/serendipity/serendipity_admin.php',
'line' => 184,
'args' =>
array (
0 => '/mnt/159/sdd/d/a/ez2cu/serendipity/include/admin/entries.inc.php',
),
'function' => 'include',
),
)
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 = 1 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 ) LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended') LEFT OUTER JOIN serendipity_entryproperties ep_cache_body ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body') LEFT OUTER JOIN serendipity_entryproperties ep_access ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access') WHERE e.id LIKE '92' AND ( c.categoryid IS NULL OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0) OR ( acl_acc.artifact_id IS NULL ) ) AND (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1)) LIMIT 1
Can someone point me to a hint in order to solve this problem?
Kind regards.