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

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8608
------------------------------------------------------------------------------
  Ticket             | 8608
  Updated By         | c-master at freenet.de
  Summary            | Wrong datatype "?" to "unsigned bigint" in datatree.
                     | \lib\Horde\DataTree\sql.php
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
+New Attachment     | hordeTables.JPG
------------------------------------------------------------------------------


c-master at freenet.de (2009-09-30 05:28) wrote:

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