Warning: pg_query() [function.pg-query]: Query failed: ERROR: la columna «e.timestamp» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación in /home/hosts/zarate.net.ve/htdocs/santiago/blog/include/db/postgres.inc.php on line 210
Error in SELECT e.timestamp
FROM blog_entries e
LEFT JOIN blog_entrycat ec
ON e.id = ec.entryid
LEFT JOIN blog_category c
ON ec.categoryid = c.categoryid
WHERE isdraft = 'false' AND timestamp <= 1228288200 AND ( (c.category_left BETWEEN 17 AND 20)) GROUP BY e.id
ERROR: la columna «e.timestamp» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
array (
0 =>
array (
'file' => '/home/hosts/zarate.net.ve/htdocs/santiago/blog/include/functions_entries.inc.php',
'line' => 1482,
'function' => 'serendipity_db_query',
'args' =>
array (
0 => 'SELECT e.timestamp
FROM blog_entries e
LEFT JOIN blog_entrycat ec
ON e.id = ec.entryid
LEFT JOIN blog_category c
ON ec.categoryid = c.categoryid
WHERE isdraft = \'false\' AND timestamp <= 1228288200 AND ( (c.category_left BETWEEN 17 AND 20)) GROUP BY e.id',
1 => false,
2 => 'assoc',
),
),
1 =>
array (
'file' => '/home/hosts/zarate.net.ve/htdocs/santiago/blog/include/genpage.inc.php',
'line' => 109,
'function' => 'serendipity_printArchives',
'args' =>
array (
),
),
2 =>
array (
'file' => '/home/hosts/zarate.net.ve/htdocs/santiago/blog/index.php',
'line' => 381,
'args' =>
array (
0 => '/home/hosts/zarate.net.ve/htdocs/santiago/blog/include/genpage.inc.php',
),
'function' => 'include',
),
)
SELECT e.timestamp
FROM blog_entries e
LEFT JOIN blog_entrycat ec
ON e.id = ec.entryid
LEFT JOIN blog_category c
ON ec.categoryid = c.categoryid
WHERE isdraft = 'false' AND timestamp <= 1228288200 AND ( (c.category_left BETWEEN 17 AND 20)) GROUP BY e.id
Warning: Invalid argument supplied for foreach() in /home/hosts/zarate.net.ve/htdocs/santiago/blog/include/functions_entries.inc.php on line 1485
