| 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 (6089 days ago) |
| Due | 10/28/09 (6089 days ago) |
| Updated | 1/13/10 (6012 days ago) |
| Assigned | |
| Resolved | 11/7/09 (6079 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | 3.3.6 |
| Patch | No |
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
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
Assigned to Jan Schneider
State ⇒ Resolved
Milestone ⇒ 3.3.6
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
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
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ Some errors are produced when the script create.msde.sql is executed in MSSQL 2005
Due ⇒ 10/28/09
Queue ⇒ Horde Base
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
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.