[Phpgroupware-users] Re: Sitemgr does not work in .001 together with PostgreSQL

[totschnig . michael]

Hello Magnus,

I see where the problem comes from. I am searching for a solution. As
a workaround I propose that you edit the file
class.Categories_BO.inc.php and comment out the line
$rv = $db_so->convert_to_phpgwapi();
This should make sitemgr work.

Michael

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

> Hi,
>
> I have done a fresh install of .001 with Postgres as a DB.
> SiteMgr install fine but as soon as I try to access the app is show this 
> error message:
>
> Database error: Invalid SQL: SELECT cat_id FROM phpgw_sitemgr_categories 
> WHERE 1=1
> PostgreSQL Error: 1 (ERROR: Relation "phpgw_sitemgr_categories" does not 
> exist )
>
> File: /var/www/html/phpgroupware/sitemgr/inc/class.Categories_db_SO.inc.php
> Line: 83
> Session halted. 
>
> The script try to query the table phpgw_sitemgr_categories but it does not 
> exist in the DB.
> I have verified that it does not exist using PSQL.
> Seems to be a problem with the install script.
>
> My installation is done from the tar distribution.
>
>
> Any help is appreicated.
>
> /Magnus