Postgresql OID issue

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
rootnl2k
Regular
Posts: 19
Joined: Tue Jul 17, 2012 7:15 am

Postgresql OID issue

Post by rootnl2k » Fri Aug 27, 2021 5:26 am

I am using the latest stable. I tried to make a modification, but now
according to the log https://www.nk.ca/~doctor/blog/serendipity/index.php yields
No entries to print
« previous page (Page 18 of 18, totaling 257 entries)

And in my postgres error messages I see

Aug 26 18:36:10 doctor postgres[8476]: [7-1] 2021-08-26 18:36:10.792 MDT [8476] ERROR: tables declared WITH OIDS are not supported
Aug 26 18:36:10 doctor postgres[8476]: [7-2] 2021-08-26 18:36:10.792 MDT [8476] STATEMENT: SET default_with_oids = true
Aug 26 18:36:10 doctor postgres[8476]: [8-1] 2021-08-26 18:36:10.855 MDT [8476] ERROR: column "serendipity_references.id" must appear in the GROUP BY clause or be used in an aggregate function at character 119
Aug 26 18:36:10 doctor postgres[8476]: [8-2] 2021-08-26 18:36:10.855 MDT [8476] STATEMENT: SELECT link, max(name) as name FROM serendipity_references WHERE entry_id = 1590 AND type = '' GROUP BY link ORDER BY id
Aug 26 18:37:02 doctor postgres[8577]: [7-1] 2021-08-26 18:37:02.659 MDT [8577] ERROR: tables declared WITH OIDS are not supported
Aug 26 18:37:02 doctor postgres[8577]: [7-2] 2021-08-26 18:37:02.659 MDT [8577] STATEMENT: SET default_with_oids = true
Aug 26 18:37:02 doctor postgres[8577]: [8-1] 2021-08-26 18:37:02.715 MDT [8577] ERROR: column "serendipity_references.id" must appear in the GROUP BY clause or be used in an aggregate function at character 119
Aug 26 18:37:02 doctor postgres[8577]: [8-2] 2021-08-26 18:37:02.715 MDT [8577] STATEMENT: SELECT link, max(name) as name FROM serendipity_references WHERE entry_id = 2337 AND type = '' GROUP BY link ORDER BY id
Aug 26 18:37:03 doctor postgres[8581]: [7-1] 2021-08-26 18:37:03.314 MDT [8581] ERROR: tables declared WITH OIDS are not supported
Aug 26 18:37:03 doctor postgres[8581]: [7-2] 2021-08-26 18:37:03.314 MDT [8581] STATEMENT: SET default_with_oids = true
Aug 26 18:37:03 doctor postgres[8627]: [7-1] 2021-08-26 18:37:03.976 MDT [8627] ERROR: tables declared WITH OIDS are not supported
Aug 26 18:37:03 doctor postgres[8627]: [7-2] 2021-08-26 18:37:03.976 MDT [8627] STATEMENT: SET default_with_oids = true
Aug 26 18:37:04 doctor postgres[8668]: [7-1] 2021-08-26 18:37:04.511 MDT [8668] ERROR: tables declared WITH OIDS are not supported
Aug 26 18:37:04 doctor postgres[8668]: [7-2] 2021-08-26 18:37:04.511 MDT [8668] STATEMENT: SET default_with_oids = true
Aug 26 18:37:04 doctor postgres[8668]: [8-1] 2021-08-26 18:37:04.569 MDT [8668] ERROR: column "serendipity_references.id" must appear in the GROUP BY clause or be used in an aggregate function at character 119
Aug 26 18:37:04 doctor postgres[8668]: [8-2] 2021-08-26 18:37:04.569 MDT [8668] STATEMENT: SELECT link, max(name) as name FROM serendipity_references WHERE entry_id = 2337 AND type = '' GROUP BY link ORDER BY id
Aug 26 18:37:04 doctor postgres[8703]: [7-1] 2021-08-26 18:37:04.979 MDT [8703] ERROR: tables declared WITH OIDS are not supported
Aug 26 18:37:04 doctor postgres[8703]: [7-2] 2021-08-26 18:37:04.979 MDT [8703] STATEMENT: SET default_with_oids = true
Aug 26 18:37:05 doctor postgres[8703]: [8-1] 2021-08-26 18:37:05.037 MDT [8703] ERROR: column "serendipity_references.id" must appear in the GROUP BY clause or be used in an aggregate function at character 119
Aug 26 18:37:05 doctor postgres[8703]: [8-2] 2021-08-26 18:37:05.037 MDT [8703] STATEMENT: SELECT link, max(name) as name FROM serendipity_references WHERE entry_id = 2337 AND type = '' GROUP BY link ORDER BY id
Aug 26 18:37:25 doctor postgres[8846]: [7-1] 2021-08-26 18:37:25.490 MDT [8846] ERROR: tables declared WITH OIDS are not supported
Aug 26 18:37:25 doctor postgres[8846]: [7-2] 2021-08-26 18:37:25.490 MDT [8846] STATEMENT: SET default_with_oids = true

I tried to go into the admin console with correct credentials only to be thrown back out.

Help!

rootnl2k
Regular
Posts: 19
Joined: Tue Jul 17, 2012 7:15 am

Re: Postgresql OID issue

Post by rootnl2k » Fri Aug 27, 2021 5:29 am

log update

Aug 26 21:23:42 doctor postgres[36047]: [7-18] a.email
Aug 26 21:23:42 doctor postgres[36047]: [7-19] , e.body, e.extended
Aug 26 21:23:42 doctor postgres[36047]: [7-20]
Aug 26 21:23:42 doctor postgres[36047]: [7-21] FROM
Aug 26 21:23:42 doctor postgres[36047]: [7-22] serendipity_entries AS e
Aug 26 21:23:42 doctor postgres[36047]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:23:42 doctor postgres[36047]: [7-24] ON e.authorid = a.authorid
Aug 26 21:23:42 doctor postgres[36047]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:23:42 doctor postgres[36047]: [7-26] ON e.id = ec.entryid
Aug 26 21:23:42 doctor postgres[36047]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:23:42 doctor postgres[36047]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:23:42 doctor postgres[36047]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:23:42 doctor postgres[36047]: [7-30] ON acl_a.authorid = 0
Aug 26 21:23:42 doctor postgres[36047]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:23:42 doctor postgres[36047]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:23:42 doctor postgres[36047]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:23:42 doctor postgres[36047]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:23:42 doctor postgres[36047]: [7-35] )
Aug 26 21:23:42 doctor postgres[36047]: [7-36] WHERE e.timestamp >= 1398902400 AND e.timestamp <= 1401580799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 27 AND 28))) AND e.timestamp <= 1630034700 AND (
Aug 26 21:23:42 doctor postgres[36047]: [7-37] c.categoryid IS NULL
Aug 26 21:23:42 doctor postgres[36047]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:23:42 doctor postgres[36047]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:23:42 doctor postgres[36047]: [7-40]
Aug 26 21:23:42 doctor postgres[36047]: [7-41] )
Aug 26 21:23:42 doctor postgres[36047]: [7-42] )
Aug 26 21:23:42 doctor postgres[36047]: [7-43] GROUP BY e.id
Aug 26 21:23:42 doctor postgres[36047]: [7-44]
Aug 26 21:23:42 doctor postgres[36047]: [7-45] ORDER BY timestamp DESC
Aug 26 21:23:42 doctor postgres[36047]: [7-46] LIMIT 15
Aug 26 21:24:15 doctor postgres[36119]: [7-1] 2021-08-26 21:24:15.994 MDT [36119] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:24:15 doctor postgres[36119]: [7-2] 2021-08-26 21:24:15.994 MDT [36119] STATEMENT: SELECT
Aug 26 21:24:15 doctor postgres[36119]: [7-3]
Aug 26 21:24:15 doctor postgres[36119]: [7-4]
Aug 26 21:24:15 doctor postgres[36119]: [7-5] e.id,
Aug 26 21:24:15 doctor postgres[36119]: [7-6] e.title,
Aug 26 21:24:15 doctor postgres[36119]: [7-7] e.timestamp,
Aug 26 21:24:15 doctor postgres[36119]: [7-8] e.comments,
Aug 26 21:24:15 doctor postgres[36119]: [7-9] e.exflag,
Aug 26 21:24:15 doctor postgres[36119]: [7-10] e.authorid,
Aug 26 21:24:15 doctor postgres[36119]: [7-11] e.trackbacks,
Aug 26 21:24:15 doctor postgres[36119]: [7-12] e.isdraft,
Aug 26 21:24:15 doctor postgres[36119]: [7-13] e.allow_comments,
Aug 26 21:24:15 doctor postgres[36119]: [7-14] e.last_modified,
Aug 26 21:24:15 doctor postgres[36119]: [7-15]
Aug 26 21:24:15 doctor postgres[36119]: [7-16] a.realname AS author,
Aug 26 21:24:15 doctor postgres[36119]: [7-17] a.username AS loginname,
Aug 26 21:24:15 doctor postgres[36119]: [7-18] a.email
Aug 26 21:24:15 doctor postgres[36119]: [7-19] , e.body, e.extended
Aug 26 21:24:15 doctor postgres[36119]: [7-20]
Aug 26 21:24:15 doctor postgres[36119]: [7-21] FROM
Aug 26 21:24:15 doctor postgres[36119]: [7-22] serendipity_entries AS e
Aug 26 21:24:15 doctor postgres[36119]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:24:15 doctor postgres[36119]: [7-24] ON e.authorid = a.authorid
Aug 26 21:24:15 doctor postgres[36119]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:24:15 doctor postgres[36119]: [7-26] ON e.id = ec.entryid
Aug 26 21:24:15 doctor postgres[36119]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:24:15 doctor postgres[36119]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:24:15 doctor postgres[36119]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:24:15 doctor postgres[36119]: [7-30] ON acl_a.authorid = 0
Aug 26 21:24:15 doctor postgres[36119]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:24:15 doctor postgres[36119]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:24:15 doctor postgres[36119]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:24:15 doctor postgres[36119]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:24:15 doctor postgres[36119]: [7-35] )
Aug 26 21:24:15 doctor postgres[36119]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND e.timestamp <= 1630034700 AND (
Aug 26 21:24:15 doctor postgres[36119]: [7-37] c.categoryid IS NULL
Aug 26 21:24:15 doctor postgres[36119]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:24:15 doctor postgres[36119]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:24:15 doctor postgres[36119]: [7-40]
Aug 26 21:24:15 doctor postgres[36119]: [7-41] )
Aug 26 21:24:15 doctor postgres[36119]: [7-42] )
Aug 26 21:24:15 doctor postgres[36119]: [7-43] GROUP BY e.id
Aug 26 21:24:15 doctor postgres[36119]: [7-44]
Aug 26 21:24:15 doctor postgres[36119]: [7-45] ORDER BY timestamp DESC
Aug 26 21:24:15 doctor postgres[36119]: [7-46] LIMIT 15
Aug 26 21:24:43 doctor postgres[36170]: [7-1] 2021-08-26 21:24:43.867 MDT [36170] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:24:43 doctor postgres[36170]: [7-2] 2021-08-26 21:24:43.867 MDT [36170] STATEMENT: SELECT
Aug 26 21:24:43 doctor postgres[36170]: [7-3]
Aug 26 21:24:43 doctor postgres[36170]: [7-4]
Aug 26 21:24:43 doctor postgres[36170]: [7-5] e.id,
Aug 26 21:24:43 doctor postgres[36170]: [7-6] e.title,
Aug 26 21:24:43 doctor postgres[36170]: [7-7] e.timestamp,
Aug 26 21:24:43 doctor postgres[36170]: [7-8] e.comments,
Aug 26 21:24:43 doctor postgres[36170]: [7-9] e.exflag,
Aug 26 21:24:43 doctor postgres[36170]: [7-10] e.authorid,
Aug 26 21:24:43 doctor postgres[36170]: [7-11] e.trackbacks,
Aug 26 21:24:43 doctor postgres[36170]: [7-12] e.isdraft,
Aug 26 21:24:43 doctor postgres[36170]: [7-13] e.allow_comments,
Aug 26 21:24:43 doctor postgres[36170]: [7-14] e.last_modified,
Aug 26 21:24:43 doctor postgres[36170]: [7-15]
Aug 26 21:24:43 doctor postgres[36170]: [7-16] a.realname AS author,
Aug 26 21:24:43 doctor postgres[36170]: [7-17] a.username AS loginname,
Aug 26 21:24:43 doctor postgres[36170]: [7-18] a.email
Aug 26 21:24:43 doctor postgres[36170]: [7-19] , e.body, e.extended
Aug 26 21:24:43 doctor postgres[36170]: [7-20]
Aug 26 21:24:43 doctor postgres[36170]: [7-21] FROM
Aug 26 21:24:43 doctor postgres[36170]: [7-22] serendipity_entries AS e
Aug 26 21:24:43 doctor postgres[36170]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:24:43 doctor postgres[36170]: [7-24] ON e.authorid = a.authorid
Aug 26 21:24:43 doctor postgres[36170]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:24:43 doctor postgres[36170]: [7-26] ON e.id = ec.entryid
Aug 26 21:24:43 doctor postgres[36170]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:24:43 doctor postgres[36170]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:24:43 doctor postgres[36170]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:24:43 doctor postgres[36170]: [7-30] ON acl_a.authorid = 0
Aug 26 21:24:43 doctor postgres[36170]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:24:43 doctor postgres[36170]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:24:43 doctor postgres[36170]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:24:43 doctor postgres[36170]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:24:43 doctor postgres[36170]: [7-35] )
Aug 26 21:24:43 doctor postgres[36170]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 29 AND 30))) AND e.timestamp <= 1630034700 AND (
Aug 26 21:24:43 doctor postgres[36170]: [7-37] c.categoryid IS NULL
Aug 26 21:24:43 doctor postgres[36170]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:24:43 doctor postgres[36170]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:24:43 doctor postgres[36170]: [7-40]
Aug 26 21:24:43 doctor postgres[36170]: [7-41] )
Aug 26 21:24:43 doctor postgres[36170]: [7-42] )
Aug 26 21:24:43 doctor postgres[36170]: [7-43] GROUP BY e.id
Aug 26 21:24:43 doctor postgres[36170]: [7-44]
Aug 26 21:24:43 doctor postgres[36170]: [7-45] ORDER BY timestamp DESC
Aug 26 21:24:43 doctor postgres[36170]: [7-46] LIMIT 15
Aug 26 21:25:03 doctor postgres[36188]: [7-1] 2021-08-26 21:25:03.650 MDT [36188] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:25:03 doctor postgres[36188]: [7-2] 2021-08-26 21:25:03.650 MDT [36188] STATEMENT: SELECT
Aug 26 21:25:03 doctor postgres[36188]: [7-3]
Aug 26 21:25:03 doctor postgres[36188]: [7-4]
Aug 26 21:25:03 doctor postgres[36188]: [7-5] e.id,
Aug 26 21:25:03 doctor postgres[36188]: [7-6] e.title,
Aug 26 21:25:03 doctor postgres[36188]: [7-7] e.timestamp,
Aug 26 21:25:03 doctor postgres[36188]: [7-8] e.comments,
Aug 26 21:25:03 doctor postgres[36188]: [7-9] e.exflag,
Aug 26 21:25:03 doctor postgres[36188]: [7-10] e.authorid,
Aug 26 21:25:03 doctor postgres[36188]: [7-11] e.trackbacks,
Aug 26 21:25:03 doctor postgres[36188]: [7-12] e.isdraft,
Aug 26 21:25:03 doctor postgres[36188]: [7-13] e.allow_comments,
Aug 26 21:25:03 doctor postgres[36188]: [7-14] e.last_modified,
Aug 26 21:25:03 doctor postgres[36188]: [7-15]
Aug 26 21:25:03 doctor postgres[36188]: [7-16] a.realname AS author,
Aug 26 21:25:03 doctor postgres[36188]: [7-17] a.username AS loginname,
Aug 26 21:25:03 doctor postgres[36188]: [7-18] a.email
Aug 26 21:25:03 doctor postgres[36188]: [7-19] , e.body, e.extended
Aug 26 21:25:03 doctor postgres[36188]: [7-20]
Aug 26 21:25:03 doctor postgres[36188]: [7-21] FROM
Aug 26 21:25:03 doctor postgres[36188]: [7-22] serendipity_entries AS e
Aug 26 21:25:03 doctor postgres[36188]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:25:03 doctor postgres[36188]: [7-24] ON e.authorid = a.authorid
Aug 26 21:25:03 doctor postgres[36188]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:25:03 doctor postgres[36188]: [7-26] ON e.id = ec.entryid
Aug 26 21:25:03 doctor postgres[36188]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:25:03 doctor postgres[36188]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:25:03 doctor postgres[36188]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:25:03 doctor postgres[36188]: [7-30] ON acl_a.authorid = 0
Aug 26 21:25:03 doctor postgres[36188]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:25:03 doctor postgres[36188]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:25:03 doctor postgres[36188]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:25:03 doctor postgres[36188]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:25:03 doctor postgres[36188]: [7-35] )
Aug 26 21:25:03 doctor postgres[36188]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 14 AND 15))) AND e.timestamp <= 1630035000 AND (
Aug 26 21:25:03 doctor postgres[36188]: [7-37] c.categoryid IS NULL
Aug 26 21:25:03 doctor postgres[36188]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:25:03 doctor postgres[36188]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:25:03 doctor postgres[36188]: [7-40]
Aug 26 21:25:03 doctor postgres[36188]: [7-41] )
Aug 26 21:25:03 doctor postgres[36188]: [7-42] )
Aug 26 21:25:03 doctor postgres[36188]: [7-43] GROUP BY e.id
Aug 26 21:25:03 doctor postgres[36188]: [7-44]
Aug 26 21:25:03 doctor postgres[36188]: [7-45] ORDER BY timestamp DESC
Aug 26 21:25:03 doctor postgres[36188]: [7-46] LIMIT 15
Aug 26 21:25:22 doctor postgres[36226]: [7-1] 2021-08-26 21:25:22.851 MDT [36226] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:25:22 doctor postgres[36226]: [7-2] 2021-08-26 21:25:22.851 MDT [36226] STATEMENT: SELECT
Aug 26 21:25:22 doctor postgres[36226]: [7-3]
Aug 26 21:25:22 doctor postgres[36226]: [7-4]
Aug 26 21:25:22 doctor postgres[36226]: [7-5] e.id,
Aug 26 21:25:22 doctor postgres[36226]: [7-6] e.title,
Aug 26 21:25:22 doctor postgres[36226]: [7-7] e.timestamp,
Aug 26 21:25:22 doctor postgres[36226]: [7-8] e.comments,
Aug 26 21:25:22 doctor postgres[36226]: [7-9] e.exflag,
Aug 26 21:25:22 doctor postgres[36226]: [7-10] e.authorid,
Aug 26 21:25:22 doctor postgres[36226]: [7-11] e.trackbacks,
Aug 26 21:25:22 doctor postgres[36226]: [7-12] e.isdraft,
Aug 26 21:25:22 doctor postgres[36226]: [7-13] e.allow_comments,
Aug 26 21:25:22 doctor postgres[36226]: [7-14] e.last_modified,
Aug 26 21:25:22 doctor postgres[36226]: [7-15]
Aug 26 21:25:22 doctor postgres[36226]: [7-16] a.realname AS author,
Aug 26 21:25:22 doctor postgres[36226]: [7-17] a.username AS loginname,
Aug 26 21:25:22 doctor postgres[36226]: [7-18] a.email
Aug 26 21:25:22 doctor postgres[36226]: [7-19] , e.body, e.extended
Aug 26 21:25:22 doctor postgres[36226]: [7-20]
Aug 26 21:25:22 doctor postgres[36226]: [7-21] FROM
Aug 26 21:25:22 doctor postgres[36226]: [7-22] serendipity_entries AS e
Aug 26 21:25:22 doctor postgres[36226]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:25:22 doctor postgres[36226]: [7-24] ON e.authorid = a.authorid
Aug 26 21:25:22 doctor postgres[36226]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:25:22 doctor postgres[36226]: [7-26] ON e.id = ec.entryid
Aug 26 21:25:22 doctor postgres[36226]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:25:22 doctor postgres[36226]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:25:22 doctor postgres[36226]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:25:22 doctor postgres[36226]: [7-30] ON acl_a.authorid = 0
Aug 26 21:25:22 doctor postgres[36226]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:25:22 doctor postgres[36226]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:25:22 doctor postgres[36226]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:25:22 doctor postgres[36226]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:25:22 doctor postgres[36226]: [7-35] )
Aug 26 21:25:22 doctor postgres[36226]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 18 AND 19))) AND e.timestamp <= 1630035000 AND (
Aug 26 21:25:22 doctor postgres[36226]: [7-37] c.categoryid IS NULL
Aug 26 21:25:22 doctor postgres[36226]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:25:22 doctor postgres[36226]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:25:22 doctor postgres[36226]: [7-40]
Aug 26 21:25:22 doctor postgres[36226]: [7-41] )
Aug 26 21:25:22 doctor postgres[36226]: [7-42] )
Aug 26 21:25:22 doctor postgres[36226]: [7-43] GROUP BY e.id
Aug 26 21:25:22 doctor postgres[36226]: [7-44]
Aug 26 21:25:22 doctor postgres[36226]: [7-45] ORDER BY timestamp DESC
Aug 26 21:25:22 doctor postgres[36226]: [7-46] LIMIT 15
Aug 26 21:25:45 doctor postgres[36252]: [7-1] 2021-08-26 21:25:45.495 MDT [36252] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:25:45 doctor postgres[36252]: [7-2] 2021-08-26 21:25:45.495 MDT [36252] STATEMENT: SELECT
Aug 26 21:25:45 doctor postgres[36252]: [7-3]
Aug 26 21:25:45 doctor postgres[36252]: [7-4]
Aug 26 21:25:45 doctor postgres[36252]: [7-5] e.id,
Aug 26 21:25:45 doctor postgres[36252]: [7-6] e.title,
Aug 26 21:25:45 doctor postgres[36252]: [7-7] e.timestamp,
Aug 26 21:25:45 doctor postgres[36252]: [7-8] e.comments,
Aug 26 21:25:45 doctor postgres[36252]: [7-9] e.exflag,
Aug 26 21:25:45 doctor postgres[36252]: [7-10] e.authorid,
Aug 26 21:25:45 doctor postgres[36252]: [7-11] e.trackbacks,
Aug 26 21:25:45 doctor postgres[36252]: [7-12] e.isdraft,
Aug 26 21:25:45 doctor postgres[36252]: [7-13] e.allow_comments,
Aug 26 21:25:45 doctor postgres[36252]: [7-14] e.last_modified,
Aug 26 21:25:45 doctor postgres[36252]: [7-15]
Aug 26 21:25:45 doctor postgres[36252]: [7-16] a.realname AS author,
Aug 26 21:25:45 doctor postgres[36252]: [7-17] a.username AS loginname,
Aug 26 21:25:45 doctor postgres[36252]: [7-18] a.email
Aug 26 21:25:45 doctor postgres[36252]: [7-19] , e.body, e.extended
Aug 26 21:25:45 doctor postgres[36252]: [7-20]
Aug 26 21:25:45 doctor postgres[36252]: [7-21] FROM
Aug 26 21:25:45 doctor postgres[36252]: [7-22] serendipity_entries AS e
Aug 26 21:25:45 doctor postgres[36252]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:25:45 doctor postgres[36252]: [7-24] ON e.authorid = a.authorid
Aug 26 21:25:45 doctor postgres[36252]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:25:45 doctor postgres[36252]: [7-26] ON e.id = ec.entryid
Aug 26 21:25:45 doctor postgres[36252]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:25:45 doctor postgres[36252]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:25:45 doctor postgres[36252]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:25:45 doctor postgres[36252]: [7-30] ON acl_a.authorid = 0
Aug 26 21:25:45 doctor postgres[36252]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:25:45 doctor postgres[36252]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:25:45 doctor postgres[36252]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:25:45 doctor postgres[36252]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:25:45 doctor postgres[36252]: [7-35] )
Aug 26 21:25:45 doctor postgres[36252]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 20 AND 21))) AND e.timestamp <= 1630035000 AND (
Aug 26 21:25:45 doctor postgres[36252]: [7-37] c.categoryid IS NULL
Aug 26 21:25:45 doctor postgres[36252]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:25:45 doctor postgres[36252]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:25:45 doctor postgres[36252]: [7-40]
Aug 26 21:25:45 doctor postgres[36252]: [7-41] )
Aug 26 21:25:45 doctor postgres[36252]: [7-42] )
Aug 26 21:25:45 doctor postgres[36252]: [7-43] GROUP BY e.id
Aug 26 21:25:45 doctor postgres[36252]: [7-44]
Aug 26 21:25:45 doctor postgres[36252]: [7-45] ORDER BY timestamp DESC
Aug 26 21:25:45 doctor postgres[36252]: [7-46] LIMIT 15
Aug 26 21:26:13 doctor postgres[36295]: [7-1] 2021-08-26 21:26:13.668 MDT [36295] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:26:13 doctor postgres[36295]: [7-2] 2021-08-26 21:26:13.668 MDT [36295] STATEMENT: SELECT
Aug 26 21:26:13 doctor postgres[36295]: [7-3]
Aug 26 21:26:13 doctor postgres[36295]: [7-4]
Aug 26 21:26:13 doctor postgres[36295]: [7-5] e.id,
Aug 26 21:26:13 doctor postgres[36295]: [7-6] e.title,
Aug 26 21:26:13 doctor postgres[36295]: [7-7] e.timestamp,
Aug 26 21:26:13 doctor postgres[36295]: [7-8] e.comments,
Aug 26 21:26:13 doctor postgres[36295]: [7-9] e.exflag,
Aug 26 21:26:13 doctor postgres[36295]: [7-10] e.authorid,
Aug 26 21:26:13 doctor postgres[36295]: [7-11] e.trackbacks,
Aug 26 21:26:13 doctor postgres[36295]: [7-12] e.isdraft,
Aug 26 21:26:13 doctor postgres[36295]: [7-13] e.allow_comments,
Aug 26 21:26:13 doctor postgres[36295]: [7-14] e.last_modified,
Aug 26 21:26:13 doctor postgres[36295]: [7-15]
Aug 26 21:26:13 doctor postgres[36295]: [7-16] a.realname AS author,
Aug 26 21:26:13 doctor postgres[36295]: [7-17] a.username AS loginname,
Aug 26 21:26:13 doctor postgres[36295]: [7-18] a.email
Aug 26 21:26:13 doctor postgres[36295]: [7-19] , e.body, e.extended
Aug 26 21:26:13 doctor postgres[36295]: [7-20]
Aug 26 21:26:13 doctor postgres[36295]: [7-21] FROM
Aug 26 21:26:13 doctor postgres[36295]: [7-22] serendipity_entries AS e
Aug 26 21:26:13 doctor postgres[36295]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:26:13 doctor postgres[36295]: [7-24] ON e.authorid = a.authorid
Aug 26 21:26:13 doctor postgres[36295]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:26:13 doctor postgres[36295]: [7-26] ON e.id = ec.entryid
Aug 26 21:26:13 doctor postgres[36295]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:26:13 doctor postgres[36295]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:26:13 doctor postgres[36295]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:26:13 doctor postgres[36295]: [7-30] ON acl_a.authorid = 0
Aug 26 21:26:13 doctor postgres[36295]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:26:13 doctor postgres[36295]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:26:13 doctor postgres[36295]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:26:13 doctor postgres[36295]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:26:13 doctor postgres[36295]: [7-35] )
Aug 26 21:26:13 doctor postgres[36295]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 8 AND 9))) AND e.timestamp <= 1630035000 AND (
Aug 26 21:26:13 doctor postgres[36295]: [7-37] c.categoryid IS NULL
Aug 26 21:26:13 doctor postgres[36295]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:26:13 doctor postgres[36295]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:26:13 doctor postgres[36295]: [7-40]
Aug 26 21:26:13 doctor postgres[36295]: [7-41] )
Aug 26 21:26:13 doctor postgres[36295]: [7-42] )
Aug 26 21:26:13 doctor postgres[36295]: [7-43] GROUP BY e.id
Aug 26 21:26:13 doctor postgres[36295]: [7-44]
Aug 26 21:26:13 doctor postgres[36295]: [7-45] ORDER BY timestamp DESC
Aug 26 21:26:13 doctor postgres[36295]: [7-46] LIMIT 15
Aug 26 21:26:34 doctor postgres[36316]: [7-1] 2021-08-26 21:26:34.551 MDT [36316] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:26:34 doctor postgres[36316]: [7-2] 2021-08-26 21:26:34.551 MDT [36316] STATEMENT: SELECT
Aug 26 21:26:34 doctor postgres[36316]: [7-3]
Aug 26 21:26:34 doctor postgres[36316]: [7-4]
Aug 26 21:26:34 doctor postgres[36316]: [7-5] e.id,
Aug 26 21:26:34 doctor postgres[36316]: [7-6] e.title,
Aug 26 21:26:34 doctor postgres[36316]: [7-7] e.timestamp,
Aug 26 21:26:34 doctor postgres[36316]: [7-8] e.comments,
Aug 26 21:26:34 doctor postgres[36316]: [7-9] e.exflag,
Aug 26 21:26:34 doctor postgres[36316]: [7-10] e.authorid,
Aug 26 21:26:34 doctor postgres[36316]: [7-11] e.trackbacks,
Aug 26 21:26:34 doctor postgres[36316]: [7-12] e.isdraft,
Aug 26 21:26:34 doctor postgres[36316]: [7-13] e.allow_comments,
Aug 26 21:26:34 doctor postgres[36316]: [7-14] e.last_modified,
Aug 26 21:26:34 doctor postgres[36316]: [7-15]
Aug 26 21:26:34 doctor postgres[36316]: [7-16] a.realname AS author,
Aug 26 21:26:34 doctor postgres[36316]: [7-17] a.username AS loginname,
Aug 26 21:26:34 doctor postgres[36316]: [7-18] a.email
Aug 26 21:26:34 doctor postgres[36316]: [7-19] , e.body, e.extended
Aug 26 21:26:34 doctor postgres[36316]: [7-20]
Aug 26 21:26:34 doctor postgres[36316]: [7-21] FROM
Aug 26 21:26:34 doctor postgres[36316]: [7-22] serendipity_entries AS e
Aug 26 21:26:34 doctor postgres[36316]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:26:34 doctor postgres[36316]: [7-24] ON e.authorid = a.authorid
Aug 26 21:26:34 doctor postgres[36316]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:26:34 doctor postgres[36316]: [7-26] ON e.id = ec.entryid
Aug 26 21:26:34 doctor postgres[36316]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:26:34 doctor postgres[36316]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:26:34 doctor postgres[36316]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:26:34 doctor postgres[36316]: [7-30] ON acl_a.authorid = 0
Aug 26 21:26:34 doctor postgres[36316]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:26:34 doctor postgres[36316]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:26:34 doctor postgres[36316]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:26:34 doctor postgres[36316]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:26:34 doctor postgres[36316]: [7-35] )
Aug 26 21:26:34 doctor postgres[36316]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 3 AND 4))) AND e.timestamp <= 1630035000 AND (
Aug 26 21:26:34 doctor postgres[36316]: [7-37] c.categoryid IS NULL
Aug 26 21:26:34 doctor postgres[36316]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:26:34 doctor postgres[36316]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:26:34 doctor postgres[36316]: [7-40]
Aug 26 21:26:34 doctor postgres[36316]: [7-41] )
Aug 26 21:26:34 doctor postgres[36316]: [7-42] )
Aug 26 21:26:34 doctor postgres[36316]: [7-43] GROUP BY e.id
Aug 26 21:26:34 doctor postgres[36316]: [7-44]
Aug 26 21:26:34 doctor postgres[36316]: [7-45] ORDER BY timestamp DESC
Aug 26 21:26:34 doctor postgres[36316]: [7-46] LIMIT 15
Aug 26 21:26:50 doctor postgres[36358]: [7-1] 2021-08-26 21:26:50.315 MDT [36358] ERROR: tables declared WITH OIDS are not supported
Aug 26 21:26:50 doctor postgres[36358]: [7-2] 2021-08-26 21:26:50.315 MDT [36358] STATEMENT: SET default_with_oids = true
Aug 26 21:26:51 doctor postgres[36360]: [7-1] 2021-08-26 21:26:51.562 MDT [36360] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:26:51 doctor postgres[36360]: [7-2] 2021-08-26 21:26:51.562 MDT [36360] STATEMENT: SELECT
Aug 26 21:26:51 doctor postgres[36360]: [7-3]
Aug 26 21:26:51 doctor postgres[36360]: [7-4]
Aug 26 21:26:51 doctor postgres[36360]: [7-5] e.id,
Aug 26 21:26:51 doctor postgres[36360]: [7-6] e.title,
Aug 26 21:26:51 doctor postgres[36360]: [7-7] e.timestamp,
Aug 26 21:26:51 doctor postgres[36360]: [7-8] e.comments,
Aug 26 21:26:51 doctor postgres[36360]: [7-9] e.exflag,
Aug 26 21:26:51 doctor postgres[36360]: [7-10] e.authorid,
Aug 26 21:26:51 doctor postgres[36360]: [7-11] e.trackbacks,
Aug 26 21:26:51 doctor postgres[36360]: [7-12] e.isdraft,
Aug 26 21:26:51 doctor postgres[36360]: [7-13] e.allow_comments,
Aug 26 21:26:51 doctor postgres[36360]: [7-14] e.last_modified,
Aug 26 21:26:51 doctor postgres[36360]: [7-15]
Aug 26 21:26:51 doctor postgres[36360]: [7-16] a.realname AS author,
Aug 26 21:26:51 doctor postgres[36360]: [7-17] a.username AS loginname,
Aug 26 21:26:51 doctor postgres[36360]: [7-18] a.email
Aug 26 21:26:51 doctor postgres[36360]: [7-19] , e.body, e.extended
Aug 26 21:26:51 doctor postgres[36360]: [7-20]
Aug 26 21:26:51 doctor postgres[36360]: [7-21] FROM
Aug 26 21:26:51 doctor postgres[36360]: [7-22] serendipity_entries AS e
Aug 26 21:26:51 doctor postgres[36360]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:26:51 doctor postgres[36360]: [7-24] ON e.authorid = a.authorid
Aug 26 21:26:51 doctor postgres[36360]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:26:51 doctor postgres[36360]: [7-26] ON e.id = ec.entryid
Aug 26 21:26:51 doctor postgres[36360]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:26:51 doctor postgres[36360]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:26:51 doctor postgres[36360]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:26:51 doctor postgres[36360]: [7-30] ON acl_a.authorid = 0
Aug 26 21:26:51 doctor postgres[36360]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:26:51 doctor postgres[36360]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:26:51 doctor postgres[36360]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:26:51 doctor postgres[36360]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:26:51 doctor postgres[36360]: [7-35] )
Aug 26 21:26:51 doctor postgres[36360]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 5 AND 6))) AND e.timestamp <= 1630035000 AND (
Aug 26 21:26:51 doctor postgres[36360]: [7-37] c.categoryid IS NULL
Aug 26 21:26:51 doctor postgres[36360]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:26:51 doctor postgres[36360]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:26:51 doctor postgres[36360]: [7-40]
Aug 26 21:26:51 doctor postgres[36360]: [7-41] )
Aug 26 21:26:51 doctor postgres[36360]: [7-42] )
Aug 26 21:26:51 doctor postgres[36360]: [7-43] GROUP BY e.id
Aug 26 21:26:51 doctor postgres[36360]: [7-44]
Aug 26 21:26:51 doctor postgres[36360]: [7-45] ORDER BY timestamp DESC
Aug 26 21:26:51 doctor postgres[36360]: [7-46] LIMIT 15
Aug 26 21:27:02 doctor postgres[36367]: [7-1] 2021-08-26 21:27:01.999 MDT [36367] ERROR: tables declared WITH OIDS are not supported
Aug 26 21:27:02 doctor postgres[36367]: [7-2] 2021-08-26 21:27:01.999 MDT [36367] STATEMENT: SET default_with_oids = true
Aug 26 21:27:04 doctor postgres[36417]: [7-1] 2021-08-26 21:27:04.741 MDT [36417] ERROR: column "e.title" must appear in the GROUP BY clause or be used in an aggregate function at character 212
Aug 26 21:27:04 doctor postgres[36417]: [7-2] 2021-08-26 21:27:04.741 MDT [36417] STATEMENT: SELECT
Aug 26 21:27:04 doctor postgres[36417]: [7-3] co.id,
Aug 26 21:27:04 doctor postgres[36417]: [7-4] co.entry_id, co.timestamp, co.title AS ctitle, co.email, co.url, co.ip, co.body, co.type, co.subscribed,
Aug 26 21:27:04 doctor postgres[36417]: [7-5] co.author,
Aug 26 21:27:04 doctor postgres[36417]: [7-6] e.title,
Aug 26 21:27:04 doctor postgres[36417]: [7-7] e.timestamp AS entrytimestamp,
Aug 26 21:27:04 doctor postgres[36417]: [7-8] e.id AS entryid,
Aug 26 21:27:04 doctor postgres[36417]: [7-9] e.authorid,
Aug 26 21:27:04 doctor postgres[36417]: [7-10] e.author as entryauthor,
Aug 26 21:27:04 doctor postgres[36417]: [7-11] co.id AS commentid,
Aug 26 21:27:04 doctor postgres[36417]: [7-12] co.parent_id AS parent_id,
Aug 26 21:27:04 doctor postgres[36417]: [7-13] co.status
Aug 26 21:27:04 doctor postgres[36417]: [7-14] FROM
Aug 26 21:27:04 doctor postgres[36417]: [7-15] serendipity_comments AS co
Aug 26 21:27:04 doctor postgres[36417]: [7-16] LEFT JOIN serendipity_entries AS e ON (co.entry_id = e.id)
Aug 26 21:27:04 doctor postgres[36417]: [7-17] WHERE co.type LIKE 'NORMAL' AND co.entry_id > 0 AND co.entry_id = '212' AND co.status = 'approved'
Aug 26 21:27:04 doctor postgres[36417]: [7-18] GROUP BY co.id
Aug 26 21:27:04 doctor postgres[36417]: [7-19] ORDER BY
Aug 26 21:27:04 doctor postgres[36417]: [7-20] co.id
Aug 26 21:27:04 doctor postgres[36417]: [7-21]
Aug 26 21:27:04 doctor postgres[36417]: [8-1] 2021-08-26 21:27:04.749 MDT [36417] ERROR: column "e.title" must appear in the GROUP BY clause or be used in an aggregate function at character 212
Aug 26 21:27:04 doctor postgres[36417]: [8-2] 2021-08-26 21:27:04.749 MDT [36417] STATEMENT: SELECT
Aug 26 21:27:04 doctor postgres[36417]: [8-3] co.id,
Aug 26 21:27:04 doctor postgres[36417]: [8-4] co.entry_id, co.timestamp, co.title AS ctitle, co.email, co.url, co.ip, co.body, co.type, co.subscribed,
Aug 26 21:27:04 doctor postgres[36417]: [8-5] co.author,
Aug 26 21:27:04 doctor postgres[36417]: [8-6] e.title,
Aug 26 21:27:04 doctor postgres[36417]: [8-7] e.timestamp AS entrytimestamp,
Aug 26 21:27:04 doctor postgres[36417]: [8-8] e.id AS entryid,
Aug 26 21:27:04 doctor postgres[36417]: [8-9] e.authorid,
Aug 26 21:27:04 doctor postgres[36417]: [8-10] e.author as entryauthor,
Aug 26 21:27:04 doctor postgres[36417]: [8-11] co.id AS commentid,
Aug 26 21:27:04 doctor postgres[36417]: [8-12] co.parent_id AS parent_id,
Aug 26 21:27:04 doctor postgres[36417]: [8-13] co.status
Aug 26 21:27:04 doctor postgres[36417]: [8-14] FROM
Aug 26 21:27:04 doctor postgres[36417]: [8-15] serendipity_comments AS co
Aug 26 21:27:04 doctor postgres[36417]: [8-16] LEFT JOIN serendipity_entries AS e ON (co.entry_id = e.id)
Aug 26 21:27:04 doctor postgres[36417]: [8-17] WHERE co.type LIKE 'NORMAL' AND co.entry_id > 0 AND co.entry_id = '212' AND co.status = 'approved'
Aug 26 21:27:04 doctor postgres[36417]: [8-18] GROUP BY co.id
Aug 26 21:27:04 doctor postgres[36417]: [8-19] ORDER BY
Aug 26 21:27:04 doctor postgres[36417]: [8-20] co.id
Aug 26 21:27:04 doctor postgres[36417]: [8-21]
Aug 26 21:27:21 doctor postgres[36607]: [7-1] 2021-08-26 21:27:21.230 MDT [36607] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:27:21 doctor postgres[36607]: [7-2] 2021-08-26 21:27:21.230 MDT [36607] STATEMENT: SELECT
Aug 26 21:27:21 doctor postgres[36607]: [7-3]
Aug 26 21:27:21 doctor postgres[36607]: [7-4]
Aug 26 21:27:21 doctor postgres[36607]: [7-5] e.id,
Aug 26 21:27:21 doctor postgres[36607]: [7-6] e.title,
Aug 26 21:27:21 doctor postgres[36607]: [7-7] e.timestamp,
Aug 26 21:27:21 doctor postgres[36607]: [7-8] e.comments,
Aug 26 21:27:21 doctor postgres[36607]: [7-9] e.exflag,
Aug 26 21:27:21 doctor postgres[36607]: [7-10] e.authorid,
Aug 26 21:27:21 doctor postgres[36607]: [7-11] e.trackbacks,
Aug 26 21:27:21 doctor postgres[36607]: [7-12] e.isdraft,
Aug 26 21:27:21 doctor postgres[36607]: [7-13] e.allow_comments,
Aug 26 21:27:21 doctor postgres[36607]: [7-14] e.last_modified,
Aug 26 21:27:21 doctor postgres[36607]: [7-15]
Aug 26 21:27:21 doctor postgres[36607]: [7-16] a.realname AS author,
Aug 26 21:27:21 doctor postgres[36607]: [7-17] a.username AS loginname,
Aug 26 21:27:21 doctor postgres[36607]: [7-18] a.email
Aug 26 21:27:21 doctor postgres[36607]: [7-19] , e.body, e.extended
Aug 26 21:27:21 doctor postgres[36607]: [7-20]
Aug 26 21:27:21 doctor postgres[36607]: [7-21] FROM
Aug 26 21:27:21 doctor postgres[36607]: [7-22] serendipity_entries AS e
Aug 26 21:27:21 doctor postgres[36607]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:27:21 doctor postgres[36607]: [7-24] ON e.authorid = a.authorid
Aug 26 21:27:21 doctor postgres[36607]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:27:21 doctor postgres[36607]: [7-26] ON e.id = ec.entryid
Aug 26 21:27:21 doctor postgres[36607]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:27:21 doctor postgres[36607]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:27:21 doctor postgres[36607]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:27:21 doctor postgres[36607]: [7-30] ON acl_a.authorid = 0
Aug 26 21:27:21 doctor postgres[36607]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:27:21 doctor postgres[36607]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:27:21 doctor postgres[36607]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:27:21 doctor postgres[36607]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:27:21 doctor postgres[36607]: [7-35] )
Aug 26 21:27:21 doctor postgres[36607]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 7 AND 10))) AND e.timestamp <= 1630035000 AND (
Aug 26 21:27:21 doctor postgres[36607]: [7-37] c.categoryid IS NULL
Aug 26 21:27:21 doctor postgres[36607]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:27:21 doctor postgres[36607]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:27:21 doctor postgres[36607]: [7-40]
Aug 26 21:27:21 doctor postgres[36607]: [7-41] )
Aug 26 21:27:21 doctor postgres[36607]: [7-42] )
Aug 26 21:27:21 doctor postgres[36607]: [7-43] GROUP BY e.id
Aug 26 21:27:21 doctor postgres[36607]: [7-44]
Aug 26 21:27:21 doctor postgres[36607]: [7-45] ORDER BY timestamp DESC
Aug 26 21:27:21 doctor postgres[36607]: [7-46] LIMIT 15
Aug 26 21:27:55 doctor postgres[36657]: [7-1] 2021-08-26 21:27:55.338 MDT [36657] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:27:55 doctor postgres[36657]: [7-2] 2021-08-26 21:27:55.338 MDT [36657] STATEMENT: SELECT
Aug 26 21:27:55 doctor postgres[36657]: [7-3]
Aug 26 21:27:55 doctor postgres[36657]: [7-4]
Aug 26 21:27:55 doctor postgres[36657]: [7-5] e.id,
Aug 26 21:27:55 doctor postgres[36657]: [7-6] e.title,
Aug 26 21:27:55 doctor postgres[36657]: [7-7] e.timestamp,
Aug 26 21:27:55 doctor postgres[36657]: [7-8] e.comments,
Aug 26 21:27:55 doctor postgres[36657]: [7-9] e.exflag,
Aug 26 21:27:55 doctor postgres[36657]: [7-10] e.authorid,
Aug 26 21:27:55 doctor postgres[36657]: [7-11] e.trackbacks,
Aug 26 21:27:55 doctor postgres[36657]: [7-12] e.isdraft,
Aug 26 21:27:55 doctor postgres[36657]: [7-13] e.allow_comments,
Aug 26 21:27:55 doctor postgres[36657]: [7-14] e.last_modified,
Aug 26 21:27:55 doctor postgres[36657]: [7-15]
Aug 26 21:27:55 doctor postgres[36657]: [7-16] a.realname AS author,
Aug 26 21:27:55 doctor postgres[36657]: [7-17] a.username AS loginname,
Aug 26 21:27:55 doctor postgres[36657]: [7-18] a.email
Aug 26 21:27:55 doctor postgres[36657]: [7-19] , e.body, e.extended
Aug 26 21:27:55 doctor postgres[36657]: [7-20]
Aug 26 21:27:55 doctor postgres[36657]: [7-21] FROM
Aug 26 21:27:55 doctor postgres[36657]: [7-22] serendipity_entries AS e
Aug 26 21:27:55 doctor postgres[36657]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:27:55 doctor postgres[36657]: [7-24] ON e.authorid = a.authorid
Aug 26 21:27:55 doctor postgres[36657]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:27:55 doctor postgres[36657]: [7-26] ON e.id = ec.entryid
Aug 26 21:27:55 doctor postgres[36657]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:27:55 doctor postgres[36657]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:27:55 doctor postgres[36657]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:27:55 doctor postgres[36657]: [7-30] ON acl_a.authorid = 0
Aug 26 21:27:55 doctor postgres[36657]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:27:55 doctor postgres[36657]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:27:55 doctor postgres[36657]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:27:55 doctor postgres[36657]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:27:55 doctor postgres[36657]: [7-35] )
Aug 26 21:27:55 doctor postgres[36657]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 13 AND 16))) AND e.timestamp <= 1630035000 AND (
Aug 26 21:27:55 doctor postgres[36657]: [7-37] c.categoryid IS NULL
Aug 26 21:27:55 doctor postgres[36657]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:27:55 doctor postgres[36657]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:27:55 doctor postgres[36657]: [7-40]
Aug 26 21:27:55 doctor postgres[36657]: [7-41] )
Aug 26 21:27:55 doctor postgres[36657]: [7-42] )
Aug 26 21:27:55 doctor postgres[36657]: [7-43] GROUP BY e.id
Aug 26 21:27:55 doctor postgres[36657]: [7-44]
Aug 26 21:27:55 doctor postgres[36657]: [7-45] ORDER BY timestamp DESC
Aug 26 21:27:55 doctor postgres[36657]: [7-46] LIMIT 15
Aug 26 21:28:06 doctor postgres[36666]: [7-1] 2021-08-26 21:28:06.513 MDT [36666] ERROR: tables declared WITH OIDS are not supported
Aug 26 21:28:06 doctor postgres[36666]: [7-2] 2021-08-26 21:28:06.513 MDT [36666] STATEMENT: SET default_with_oids = true
Aug 26 21:28:06 doctor postgres[36666]: [8-1] 2021-08-26 21:28:06.579 MDT [36666] ERROR: column "serendipity_references.id" must appear in the GROUP BY clause or be used in an aggregate function at character 117
Aug 26 21:28:06 doctor postgres[36666]: [8-2] 2021-08-26 21:28:06.579 MDT [36666] STATEMENT: SELECT link, max(name) as name FROM serendipity_references WHERE entry_id = 66 AND type = '' GROUP BY link ORDER BY id
Aug 26 21:28:27 doctor postgres[36700]: [7-1] 2021-08-26 21:28:27.554 MDT [36700] ERROR: column "a.realname" must appear in the GROUP BY clause or be used in an aggregate function at character 374
Aug 26 21:28:27 doctor postgres[36700]: [7-2] 2021-08-26 21:28:27.554 MDT [36700] STATEMENT: SELECT
Aug 26 21:28:27 doctor postgres[36700]: [7-3]
Aug 26 21:28:27 doctor postgres[36700]: [7-4]
Aug 26 21:28:27 doctor postgres[36700]: [7-5] e.id,
Aug 26 21:28:27 doctor postgres[36700]: [7-6] e.title,
Aug 26 21:28:27 doctor postgres[36700]: [7-7] e.timestamp,
Aug 26 21:28:27 doctor postgres[36700]: [7-8] e.comments,
Aug 26 21:28:27 doctor postgres[36700]: [7-9] e.exflag,
Aug 26 21:28:27 doctor postgres[36700]: [7-10] e.authorid,
Aug 26 21:28:27 doctor postgres[36700]: [7-11] e.trackbacks,
Aug 26 21:28:27 doctor postgres[36700]: [7-12] e.isdraft,
Aug 26 21:28:27 doctor postgres[36700]: [7-13] e.allow_comments,
Aug 26 21:28:27 doctor postgres[36700]: [7-14] e.last_modified,
Aug 26 21:28:27 doctor postgres[36700]: [7-15]
Aug 26 21:28:27 doctor postgres[36700]: [7-16] a.realname AS author,
Aug 26 21:28:27 doctor postgres[36700]: [7-17] a.username AS loginname,
Aug 26 21:28:27 doctor postgres[36700]: [7-18] a.email
Aug 26 21:28:27 doctor postgres[36700]: [7-19] , e.body, e.extended
Aug 26 21:28:27 doctor postgres[36700]: [7-20]
Aug 26 21:28:27 doctor postgres[36700]: [7-21] FROM
Aug 26 21:28:27 doctor postgres[36700]: [7-22] serendipity_entries AS e
Aug 26 21:28:27 doctor postgres[36700]: [7-23] LEFT JOIN serendipity_authors a
Aug 26 21:28:27 doctor postgres[36700]: [7-24] ON e.authorid = a.authorid
Aug 26 21:28:27 doctor postgres[36700]: [7-25] LEFT JOIN serendipity_entrycat ec
Aug 26 21:28:27 doctor postgres[36700]: [7-26] ON e.id = ec.entryid
Aug 26 21:28:27 doctor postgres[36700]: [7-27] LEFT JOIN serendipity_category c
Aug 26 21:28:27 doctor postgres[36700]: [7-28] ON ec.categoryid = c.categoryid
Aug 26 21:28:27 doctor postgres[36700]: [7-29] LEFT JOIN serendipity_authorgroups AS acl_a
Aug 26 21:28:27 doctor postgres[36700]: [7-30] ON acl_a.authorid = 0
Aug 26 21:28:27 doctor postgres[36700]: [7-31] LEFT JOIN serendipity_access AS acl_acc
Aug 26 21:28:27 doctor postgres[36700]: [7-32] ON ( acl_acc.artifact_mode = 'read'
Aug 26 21:28:27 doctor postgres[36700]: [7-33] AND acl_acc.artifact_type = 'category'
Aug 26 21:28:27 doctor postgres[36700]: [7-34] AND acl_acc.artifact_id = c.categoryid
Aug 26 21:28:27 doctor postgres[36700]: [7-35] )
Aug 26 21:28:27 doctor postgres[36700]: [7-36] WHERE e.timestamp >= 1401580800 AND e.timestamp <= 1404172799 AND isdraft = 'false' AND (( (c.category_left BETWEEN 17 AND 22))) AND e.timestamp <= 1630035000 AND (
Aug 26 21:28:27 doctor postgres[36700]: [7-37] c.categoryid IS NULL
Aug 26 21:28:27 doctor postgres[36700]: [7-38] OR ( acl_acc.groupid = 0)
Aug 26 21:28:27 doctor postgres[36700]: [7-39] OR ( acl_acc.artifact_id IS NULL
Aug 26 21:28:27 doctor postgres[36700]: [7-40]
Aug 26 21:28:27 doctor postgres[36700]: [7-41] )
Aug 26 21:28:27 doctor postgres[36700]: [7-42] )
Aug 26 21:28:27 doctor postgres[36700]: [7-43] GROUP BY e.id
Aug 26 21:28:27 doctor postgres[36700]: [7-44]
Aug 26 21:28:27 doctor postgres[36700]: [7-45] ORDER BY timestamp DESC
Aug 26 21:28:27 doctor postgres[36700]: [7-46] LIMIT 15

User avatar
onli
Regular
Posts: 2535
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

Re: Postgresql OID issue

Post by onli » Fri Aug 27, 2021 8:48 pm

I see entries now in the linked blog. The problem is solved?

Post Reply