[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-users] Re: Subject: SiteMgr in HEAD - Site Content notwor
From: |
totschnig . michael |
Subject: |
[Phpgroupware-users] Re: Subject: SiteMgr in HEAD - Site Content notworking. |
Date: |
Fri, 31 Jan 2003 01:00:30 -0500 |
User-agent: |
Gnus/5.090008 (Oort Gnus v0.08) XEmacs/21.4 (Common Lisp, i386-redhat-linux) |
Magnus,
I looked into the postgres manual, and I might have found a reason for
the problem. Could you try the following SQL statement and post what
you get.
SELECT
t1.block_id,cat_id,page_id,area,t1.module_id,app_name,module_name,arguments,arguments_lang,sort_order,title,viewable,actif
FROM phpgw_sitemgr_modules AS t2, phpgw_sitemgr_content AS t1 LEFT JOIN
phpgw_sitemgr_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
Michael