[phpGroupWare-users] Little fix...

[Marco Gaiarin]

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