[Phpgroupware-tracker] [ 100400 ] Microsoft sql server

[nobody]

Support Request #100400, was updated on 2002-Feb-07 15:21
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100400&group_id=509

Category: Bug Report
Status: Open
Priority: 5
Summary: Microsoft sql server

By: sigurdne
Date: 2002-Feb-07 15:21

Message:
Logged In: YES 
user_id=5071
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)

When trying to install phpwg with MSSQL I get the 
following message when trying to "install all 
applications" from the setup menu:

"Cannot insert the value NULL into 
column 'server_host', 
table 'phpgroupware.dbo.phpgw_interserv'; column does 
not allow nulls. INSERT fails..."

This problem seem to get solved by by adding to 
class.schema_proc.inc.php at line 386 :

else
{       
        $sFieldSQL .= ' NULL';
}

but still there is a problem by not beeing able to 
insert values for autonumbers...:

"Cannot insert explicit value for identity column in 
table 'phpgw_applications' when IDENTITY_INSERT is set 
to OFF"



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