helpphpGroupWare - 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

Submitted by:  Sigurd Nes <sigurdne>
Submitted on:  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>
Project 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>
Project Member


No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


Do you think this task is very important?
If so, you can add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.




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.3