[Phpgroupware-users] Subject: SiteMgr in HEAD - Site Content not working.

[Magnus Nilsson]

Hi,

 

I´m working with a couple of my own blocks to integrate with SiteMgr .005, but since I realized that blocks will not be (not in the same way as before) available in the next release of SiteMgr so I decided to try the new SiteMgr in HEAD instead.

 

I removed the old SiteMgr and all tables/sequences in the database which did not drop correctly and the installed SiteMgr from HEAD without en errors.

After configure of my site a tried the various new features but "Manage Site Content" gives me a databse error.

I also get the same error when I try to manage content from "Manage Pages".

The error message look like this:

 

Database error: Invalid SQL: SELECT t1.block_id,area,cat_id,page_id,t1.module_id,app_name,module_name,arguments,arguments_lang,sort_order,title,viewable,actif FROM phpgw_sitemgr_content AS t1 AS t2 LEFT JOIN phpgw_sitemgr_content_lang as t3 ON (t1.block_id=t3.block_id AND lang='en') WHERE t1.module_id = t2.module_id AND area = 'center' AND ((page_id = 0 and cat_id = 0)) ORDER by sort_order
PostgreSQL Error: 1 (ERROR: parser: parse error at or near "AS" )

 

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

 

I connected directly to the database pgAdmin and stripped the SELECT statement to ...AS t1; The DB now complains about "app_name,module_name,arguments_lang,title". Attribute not found.

Seems to me as I don´t have a complete setup of my tables/relations for this new version.

 

My system is RH7.3 on a IBM 4500R machine with 512MB and hardware raid.
with Apache 1.3.23-11
PHP 4.1.2-7
Postgres 7.2.1-5
phpGw 0.9.14.001 (from cvs)

 

All help appreciated.

 

/Magnus