If i click on 'archived content' on sitemanager, with postgresql i got
a sql error. Easy fixed:
--- /usr/local/share/phpgroupware/sitemgr/inc/class.Content_SO.inc.php.orig
2007-04-26 14:49:17.000000000 +0200
+++ /usr/local/share/phpgroupware/sitemgr/inc/class.Content_SO.inc.php
2007-04-26 14:49:32.000000000 +0200
@@ -186,7 +186,7 @@
. ' WHERE t1.block_id=t2.block_id '
. ' AND cat_id IN (' .
implode(',',$cat_list) . ')'
. ' AND state IN (' .
implode(',',$states) .')'
- . ' GROUP BY
t1.block_id,area,cat_id,page_id,viewable', __LINE__, __FILE__);
+ . ' GROUP BY
t1.block_id,area,cat_id,page_id,viewable,state', __LINE__, __FILE__);
$result = array();
--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bontà , 7 - 33078 - San Vito al Tagliamento (PN)
marco.gaiarin(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797
_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@gnu.org
http://lists.gnu.org/mailman/listinfo/phpgroupware-users
