Warning: pg_query() [function.pg-query]: Query failed: ERROR: column "e.timestamp" must appear in the GROUP BY clause or be used in an aggregate function in /home/furryzone/public_html/user/insane_kangaroo/include/db/postgres.inc.php on line 210
Error in SELECT DISTINCT e.id, e.timestamp
FROM serendipity_entries e
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
WHERE isdraft = 'false' AND ( (c.category_left BETWEEN 2 AND 3)) GROUP BY e.id
ERROR: column "e.timestamp" must appear in the GROUP BY clause or be used in an aggregate function
array (
0 =>
array (
'file' => '/home/furryzone/public_html/user/insane_kangaroo/include/functions_entries.inc.php',
'line' => 1587,
'function' => 'serendipity_db_query',
'args' =>
array (
0 => 'SELECT DISTINCT e.id, e.timestamp
FROM serendipity_entries e
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
WHERE isdraft = \'false\' AND ( (c.category_left BETWEEN 2 AND 3)) GROUP BY e.id',
1 => false,
2 => 'assoc',
),
),
1 =>
array (
'file' => '/home/furryzone/public_html/user/insane_kangaroo/include/genpage.inc.php',
'line' => 117,
'function' => 'serendipity_printArchives',
'args' =>
array (
),
),
2 =>
array (
'file' => '/home/furryzone/public_html/user/insane_kangaroo/index.php',
'line' => 398,
'args' =>
array (
0 => '/home/furryzone/public_html/user/insane_kangaroo/include/genpage.inc.php',
),
'function' => 'include',
),
)
SELECT DISTINCT e.id, e.timestamp
FROM serendipity_entries e
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
WHERE isdraft = 'false' AND ( (c.category_left BETWEEN 2 AND 3)) GROUP BY e.id
