[Phpgroupware-tracker] [ 100629 ] Upgrading 0.9.12 to 0.9.14-RC2

[nobody]

Support Request #100629, was updated on 2002-Mar-20 05:34
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100629&group_id=509

Category: Question
Status: Open
Priority: 5
Summary: Upgrading 0.9.12 to 0.9.14-RC2

By: papt
Date: 2002-Mar-20 05:34

Message:
Logged In: NO 
Browser: Mozilla/5.0 (compatible; Konqueror/2.2.1; Linux)

Hi!

I've got a working 0.9.12 distribution with lots of 
information. The database upgrading process is failed 
with the next error message:

Database error: Invalid SQL: INSERT INTO 
phpgw_categories 
(cat_id,cat_parent,cat_owner,cat_appname,cat_name,cat_description,cat_data,cat_access,cat_main,cat_level)
 
VALUES (29,25,25,'1','2','public 
','addressbook','Belföldi szállítók',0,null)
 PostgreSQL Error: 1 (ERROR: ExecAppend: Fail to add 
null value in not null attribute cat_level )
 
The cat_level attribute is '1' in the original 
phpgw_categories_tmp table.

Other info:
Mandrake Linux 8.1
phpGroupWare 0.9.12 from .tar.gz
upgrading to phpGroupWare 0.9.14-RC2 .tar.gz
Database: PostgreSQL 7.1.2

Thanks.

--Tibor



----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100629&group_id=509