[Phpgroupware-users] Re: More SiteMgr errors (with versioning)

[Magnus Nilsson]

Michael,

I get a new error when I try to access "Manage Archive".
Here it is:
Database error: Invalid SQL: SELECT COUNT(*) AS
cnt,t1.block_id,area,cat_id,page_id,viewable,state FROM phpgw_sitemgr_blocks AS
t1,phpgw_sitemgr_content as t2 WHERE t1.block_id=t2.block_id AND ((cat_id = 9) 
OR
(cat_id IN (10))) AND state IN (4) GROUP BY t1.block_id
PostgreSQL Error: 1 (ERROR: Attribute t1.area must be GROUPed or used in an
aggregate function )

File: /var/www/phpgroupware/sitemgr/inc/class.Content_SO.inc.php
Line: 174
Session halted.

Regarding the Adminstration block error:
I can reproduce the error with the following sequence,
1. Choose site to manage
2. Choose "Manage Site-wide module proerties"
3. In "Master Liust of permitted modules" click once on Administration.
4. Click on the configure button.
5. An error message appears

This is the error:
Array ( [0] => 10 )
Fatal error: Call to undefined function: debug_backtrace()
in /var/www/phpgroupware/sitemgr/inc/class.Categories_BO.inc.php on line 352


/Magnus



Hello Magnus,

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

> Two more errors with Sitemgr (with versioning).
>
> 1.
> When clicking configure (for Admin block) I get this response:
> It´s not a serious problem, the Admin Block still works as supposed to (I
>guess)
> when I add it from Page Content Manager instead.
>
> The error:
> Array ( [0] => 10 )
> Fatal error: Call to undefined function: debug_backtrace()
> in /var/www/phpgroupware/sitemgr/inc/class.Categories_BO.inc.php on line 352

I am afraid, I do not understand quite in what situation this error
arises! From where do you click configure?
The debug_backtrace function exists only since PHP 4.3.0. I put it
somewhere, where in normal circumstances it should not be executed. I
will remove it shortly.

>
> 2.
> This error pops up when I try to access Manage Archive.
>
> Database error: Invalid SQL: SELECT COUNT(*) AS
> cnt,t1.block_id,area,cat_id,page_id,viewable,state FROM phpgw_sitemgr_blocks
>AS
> t1,phpgw_sitemgr_content as t2 WHERE t1.block_id=t2.block_id AND ((cat_id =
>9) OR
> (cat_id IN (10))) AND state IN (4) GROUP BY block_id
> PostgreSQL Error: 1 (ERROR: Column reference "block_id" is ambiguous )
>
> File: /var/www/phpgroupware/sitemgr/inc/class.Content_SO.inc.php
> Line: 174
> Session halted.

I changed the GROUP by directive to
GROUP BY t1.block_id

does this help?

Michael