[horde] problems with postgresql install script

Jonathan Meyers me at jonathanmeyers.name
Sat Oct 11 11:34:39 UTC 2008 

I get the following errors when trying to run the postgresql install sql 
script for horde. Any ideas?

 It looks like this section of the  script is not right somehow:
CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name);
CREATE INDEX datatree_group_idx ON horde_datatree (group_uid);
CREATE INDEX datatree_user_idx ON horde_datatree (user_uid);
CREATE INDEX datatree_order_idx ON horde_datatree (datatree_order);
CREATE INDEX datatree_serialized_idx ON horde_datatree 
(datatree_serialized);
CREATE INDEX datatree_parents_idx ON horde_datatree (datatree_parents);
*
Errors:*
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:23: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index "horde_users_pkey" 
for table "horde_users"
CREATE TABLE
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:32: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index 
"horde_signups_pkey" for table "horde_signups"
CREATE TABLE
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:40: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index 
"horde_groups_pkey" for table "horde_groups"
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:40: NOTICE:  
CREATE TABLE / UNIQUE will create implicit index 
"horde_groups_group_name_key" for table "horde_groups"
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:56: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index "horde_perms_pkey" 
for table "horde_perms"
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:56: NOTICE:  
CREATE TABLE / UNIQUE will create implicit index 
"horde_perms_perm_name_key" for table "horde_perms"
CREATE TABLE
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:65: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index "horde_prefs_pkey" 
for table "horde_prefs"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:81: ERROR:  syntax 
error at or near "UNSIGNED" at character 51
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:81: LINE 2:     
datatree_id INT UNSIGNED NOT NULL,
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:81:                             
^
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:83: ERROR:  
relation "horde_datatree" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:84: ERROR:  
relation "horde_datatree" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:85: ERROR:  
relation "horde_datatree" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:86: ERROR:  
relation "horde_datatree" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:87: ERROR:  
relation "horde_datatree" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:88: ERROR:  
relation "horde_datatree" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:95: ERROR:  syntax 
error at or near "UNSIGNED" at character 62
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:95: LINE 2:     
datatree_id INT UNSIGNED NOT NULL,
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:95:                             
^
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:97: ERROR:  
relation "horde_datatree_attributes" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:98: ERROR:  
relation "horde_datatree_attributes" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:99: ERROR:  
relation "horde_datatree_attributes" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:100: ERROR:  
relation "horde_datatree_attributes" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:108: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index 
"horde_tokens_pkey" for table "horde_tokens"
CREATE TABLE
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:120: ERROR:  
syntax error at or near "UNSIGNED" at character 48
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:120: LINE 2:     
vfs_id        INT UNSIGNED NOT NULL,
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:120:                               
^
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:122: ERROR:  
relation "horde_vfs" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:123: ERROR:  
relation "horde_vfs" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:135: ERROR:  
syntax error at or near "UNSIGNED" at character 57
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:135: LINE 2:     
history_id       INT UNSIGNED NOT NULL,
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:135:                                  
^
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:137: ERROR:  
relation "horde_histories" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:138: ERROR:  
relation "horde_histories" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:139: ERROR:  
relation "horde_histories" does not exist
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:146: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index 
"horde_sessionhandler_pkey" for table "horde_sessionhandler"
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:203: NOTICE:  
CREATE TABLE / PRIMARY KEY will create implicit index "horde_cache_pkey" 
for table "horde_cache"
CREATE TABLE
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:215: ERROR:  
syntax error at or near "UNSIGNED" at character 358
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:215: LINE 8:     
lock_type                SMALLINT UNSIGNED NOT NULL,
psql:/web/websites/horde/scripts/sql/create.pgsql.sql:215:       
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3651 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.horde.org/archives/horde/attachments/20081011/3fb9200c/attachment.bin>

More information about the horde mailing list