helpphpGroupWare - Support: sr #100400, Microsoft sql server

 
 

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

sr #100400: Microsoft sql server

Submitted by:  Sigurd Nes <sigurdne>
Submitted on:  Thu 07 Feb 2002 03:21:14 PM UTC  
 
Category: Feature RequestPriority: 5 - Normal
Severity: 2 - MinorStatus: None
Privacy: PublicAssigned to: None
Open/Closed: OpenOperating 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.

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

-brad

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

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 click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follows 1 latest change.

Date Changed By Updated Field Previous Value => Replaced By
Sun 08 Dec 2002 12:51:06 AM UTCskwashdsupport_category_id10161=>

Back to the top


Powered by Savane 3.1-cleanup