[Phpgroupware-users] Install error with SiteMgr (with versioning)

[Magnus Nilsson]

Hi,

I tried to install sitemgr (versioning) today with 0_9_16-branch of phpgw.
I got the following error during install:

Database error: Invalid SQL: INSERT INTO phpgw_categories
(cat_parent,cat_owner,cat_access,cat_appname,cat_name,cat_description) VALUES 
(0,-
1,'public','sitemgr','Default Website','This website has been added by setup')
PostgreSQL Error: 1 (ERROR: ExecAppend: Fail to add null value in not null
attribute last_mod )

Fatal error: Call to a member function on a non-object
in /var/www/html/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 545
Seems that "last_mod" column isn´t added into default_records.inc.php.


This can be corrected by edting default_records.inc.php and change to the 
following:

SQL INSERT INTO phpgw_categories
(cat_parent,cat_owner,cat_access,cat_appname,cat_name,cat_description,last_mod)
VALUES (1,-1,'public','sitemgr','Default Website','This website has been added 
by
setup',1)


There is one other thing. It´s with iDots template. the navbar icon for SiteMgr
have wrong size. It has 60x60 pixels instead of 40x60 as the other ones have.

having a public site with content and a prepublished site to edit before going 
live
with the new content is great.

Thanks for the work Michael.


/Magnus