Tickets :: [#8664] Some errors are produced when the script create.msde.sql is executed in MSSQL 2005

6.0.0-beta6

4/10/26

Summary	Some errors are produced when the script create.msde.sql is executed in MSSQL 2005
Queue	Horde Base
Queue Version	3.3.5
Type	Bug
State	Resolved
Priority	1. Low
Owners	jan (at) horde (dot) org
Requester	emma.varela (at) usc (dot) es
Created	10/28/09 (6008 days ago)
Due	10/28/2009 (6008 days ago)
Updated	1/13/10 (5931 days ago)
Assigned
Resolved	11/7/09 (5998 days ago)
Github Issue Link
Github Pull Request
Milestone	3.3.6
Patch	No

01/13/2010 12:15:04 AM	CVS Commit	Comment #6	Reply to this comment
Changes have been made in Git for this ticket: MFB: Fix syntax (~~Bug #8664~~). http://git.horde.org/diff.php/turba/docs/CHANGES?rt=horde-git&r1=389b41d559898ac62fa341280ab6456a6cec9b27&r2=9720fb85a152dc60efd14b1894ac57a45d9f1ce1 http://git.horde.org/diff.php/turba/scripts/sql/turba.mssql.sql?rt=horde-git&r1=9335aea9d1c2ac42c65d4c7f42691e1545a416bf&r2=9720fb85a152dc60efd14b1894ac57a45d9f1ce1

11/07/2009 01:13:31 PM	CVS Commit	Comment #5	Reply to this comment
Changes have been made in Git for this ticket: MFB: Fix syntax (~~Bug #8664~~). http://git.horde.org/diff.php/turba/docs/CHANGES?rt=horde-hatchery&r1=389b41d559898ac62fa341280ab6456a6cec9b27&r2=9720fb85a152dc60efd14b1894ac57a45d9f1ce1 http://git.horde.org/diff.php/turba/scripts/sql/turba.mssql.sql?rt=horde-hatchery&r1=9335aea9d1c2ac42c65d4c7f42691e1545a416bf&r2=9720fb85a152dc60efd14b1894ac57a45d9f1ce1

11/07/2009 01:08:14 PM	Jan Schneider	Comment #4 Assigned to Jan Schneider State ⇒ Resolved Milestone ⇒ 3.3.6	Reply to this comment
Fixed, thanks!

11/07/2009 01:04:58 PM	CVS Commit	Comment #3	Reply to this comment
Changes have been made in CVS for this ticket: Fix syntax (~~Bug #8664~~). http://cvs.horde.org/diff.php/turba/scripts/sql/turba.mssql.sql?rt=horde&r1=1.1.2.9&r2=1.1.2.10&ty=u

11/07/2009 01:04:16 PM	CVS Commit	Comment #2	Reply to this comment
Changes have been made in CVS for this ticket: Fix syntax. Also no index for CLOB fields (~~Bug #8664~~). http://cvs.horde.org/diff.php/horde/scripts/sql/create.msde.sql?rt=horde&r1=1.1.2.20&r2=1.1.2.21&ty=u

10/28/2009 10:02:40 AM	emma (dot) varela (at) usc (dot) es	Comment #1 Priority ⇒ 1. Low Type ⇒ Bug Summary ⇒ Some errors are produced when the script create.msde.sql is executed in MSSQL 2005 Due ⇒ 10/28/2009 Queue ⇒ Horde Base Milestone ⇒ Patch ⇒ No State ⇒ Unconfirmed	Reply to this comment
* Some errors are produced when the script create.msde.sql is executed in MSSQL 2005: 1- SQL Server does not support the UNSIGNED attribute on integer types. 2- The column 'attribute_value' of the table 'horde_datatree_attributes' is a type of data that is not valid to be used as column of key in an index. This is because varchar(MAX) columns cannot be specified as a key column in an index. * Also there is a problem with the script turba.mssql.sql in the turba module: BLOB data type is not available. It is necessary to change BLOB type for IMAGE type.