[Phpgroupware-users] Re: Subject: SiteMgr in HEAD - Site Content notworking.

[totschnig . michael]

Magnus,

thank you for testing. I think, the change of line 167 should not make
any problem and I commited it. the change you propose for line 63
could make reappear the problem Sigurd observed with MSSQL. By the
way, I am not sure if you already updated from CVS to the last change
I made that solved the problem for MSSQL. Could you do an update and
report if there is still a problem with function getallblocksforarea?

Michael

"Magnus Nilsson" <address@hidden> a écrit:

> Michael,
>
> Your SELECT statement works from withing psql/pgadmin.
> I edited row 63 and 167 in class.Content_SO.inc.php and replaced them with
> the following statements:
>
> Row 63 - function getallblocksforarea(...)
> $sql = "SELECT t1.block_id,area,cat_id,page_id,t1.module
> _id,app_name,module_name,arguments,arguments_lang,sort_order,title,viewable,acti
> f FROM phpgw_sitemgr_modules AS t2,phpgw_sitemgr_content AS t1 LEFT JOIN 
> phpgw_s
> itemgr_content_lang as t3 ON (t1.block_id=t3.block_id AND lang='$lang') WHERE 
> t1
> .module_id = t2.module_id AND area = '$area' AND ((page_id = 0 and cat_id = 
> 0)";
>
> Row 167 - function getblock(...)
> $sql = "SELECT t1.block_id,cat_id,page_id,area,t1.module
> _id,app_name,module_name,arguments,arguments_lang,sort_order,title,viewable,acti
> f FROM phpgw_sitemgr_modules AS t2,phpgw_sitemgr_content AS t1 LEFT JOIN 
> phpgw_s
> itemgr_content_lang as t3 ON (t1.block_id=t3.block_id AND lang='$lang') WHERE 
> t1
> .module_id = t2.module_id AND t1.block_id = $block_id";
>
> With these changes everything works in sitemgr (as far as I can see).
> Though I have not done much testing.
>
> Wonder if these statements break comatibility with mysql and mssql?
>
> By the way thanks for the new install/admin manual, it makes my life easier.
>
> /Magnus