mainphpGroupWare - Support: sr #100400, Microsoft sql server


You are not allowed to post comments on this tracker with your current authentication level.

sr #100400: Microsoft sql server

Submitter:  Sigurd Nes <sigurdne>
Submitted:  Thu 07 Feb 2002 03:21:14 PM UTC
Category:  Feature Request Priority:  5 - Normal
Severity:  2 - Minor Status:  None
Privacy:  Public Assigned to:  None
Open/Closed:  Open Operating System:  None

Sun 08 Dec 2002 12:51:06 AM UTC, comment #3: 

This is a feature request and has been marked as such.  The
request will be evaluated, and possibly included in the next (or
later) release.

Dave Hall <skwashd>
Group administrator
Mon 04 Nov 2002 05:22:33 PM UTC, comment #2: 

The problem is that SQL Server defaults to non-ANSI
compliant behaviour when a field is not specified to be
nullable or not.

Set the ANSI null property to true for the database, it will
take care of the null values problem.

Sat 09 Feb 2002 12:03:31 AM UTC, comment #1: 

All columns default to NOT NULL in sql server 6.5 or less.
If you're using freetds, setting the tds version to 7.0 or higher (assuming you're using 7.0 or higher) takes care of
the null/not null problem.  Though specifying NULL explicitly is probably not a bad idea.


Bradley Bell <btb>
Thu 07 Feb 2002 03:21:14 PM UTC, original submission:  

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 at line 386 :

$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"

Sigurd Nes <sigurdne>
Group Member


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.


Follows 1 latest change.

Date Changed by Updated Field Previous Value => Replaced by
2002-12-08 skwashd support_category_id10161

Back to the top

Powered by Savane 3.13-4448.
Corresponding source code