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

[Magnus Nilsson]

Michael,

The changes you comitted to HEAD now works in Postgres too.

/Magnus

address@hidden wrote:
>
>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 w
>ith
>> 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,view
>able,acti
>> f FROM phpgw_sitemgr_modules AS t2,phpgw_sitemgr_content AS t1 LEFT JOI
>N phpgw_s
>> itemgr_content_lang as t3 ON (t1.block_id=t3.block_id AND lang='$la
>ng') WHERE t1
>> .module_id = t2.module_id AND area = '$area' AND ((page_id = 0 an
>d 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,view
>able,acti
>> f FROM phpgw_sitemgr_modules AS t2,phpgw_sitemgr_content AS t1 LEFT JOI
>N phpgw_s
>> itemgr_content_lang as t3 ON (t1.block_id=t3.block_id AND lang='$la
>ng') 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 ea
>sier.
>>
>> /Magnus
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

--
Magnus Nilsson
Sweden Infrastructure & Management Solutions AB
tel. +46 11 40 00 142
www.sim-solutions.com