Tickets :: Comment on [#8608] Wrong datatype "?" to "unsigned bigint" in datatree. \lib\Horde\DataTree\sql.php

* Your Email Address
* Spam protection	Enter the letters below: .__ .__ . .. ,. . [ __\| \\ / \./ \| \| [_./\|__/ \/ \| \|/\\|
Comment	>> Looks like scripts/sql/create.sybase.sql (on which the groupware > >> script is based) is not really up-to-date. The datatree_order column > >> is missing and the horde_datatree_attributes is missing completely. > > > > I created the missing and invalid tables on my own, by analyzing > horde-error-logs and using the datatree-create statements. > > > > My tables look like this (sql form) > > > > CREATE TABLE "php"."horde_datatree" ( > > "datatree_id" integer NOT NULL, > > "group_uid" varchar(255) NOT NULL, > > "user_uid" varchar(255) NOT NULL, > > "datatree_name" varchar(255) NOT NULL, > > "datatree_parents" varchar(255) NOT NULL, > > "datatree_order" integer NULL, > > "datatree_data" varchar(255) NULL, > > "datatree_serialized" smallint NOT NULL DEFAULT 0, > > PRIMARY KEY ( "datatree_id" ) > > ); > > > > CREATE TABLE "php"."horde_datatree_attributes" ( > > "datatree_id" integer NOT NULL, > > "attribute_name" varchar(255) NOT NULL, > > "attribute_key" varchar(255) NULL, > > "attribute_value" varchar(255) NULL > > ); > > > > Table Data visible in attachment. The Problem is attribute_value > which can not be converted to bigint (because it is a string)
Attachment
Watch this ticket