phpgroupware-users
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]