There was a typo in the schema file, fixed for 1.2.1.

Changes have been made in CVS for this ticket:

http://cvs.horde.org/diff.php/horde/scripts/sql/create.xml?r1=1.25&r2=1.26&ty=u

This is weird.

Posting here some additional information. I have the same issue with 
my Horde server (missing fields lock_owner and lock_scope in 
horde_locks table, I didn't check the other tables).



I retry an install from scratch to answer to your question. Apache 
server (2.2.3 on a Debian Etch), MySQL server (5.0.32) and PHP 
(5.2.0). Here is a summary:

  - Download horde-webmail-1.2.tar.gz

  - Extract in DocumentRoot

  - chown -R www-data: .

  - cd script; ./setup.php

      (1) Configure database settings

        answer questions, then during step 'Writing main configuration 
file', this error occurs 10 times:

            Notice: Undefined index:  secret_key in 
/nfswebuapv-test/horde-test.univ-avignon.fr/www/lib/Horde.php on line 
359

      Continuing with (2) Create database or tables

        None error occurs, except a warning because I've manually 
created the database ([  WARN  ] Database horde_test3 already exists, 
skipping.)

  - Finally, I've checked horde_locks :

mysql> desc horde_locks;

+-----------------------+--------------+------+-----+---------+-------+

| Field                 | Type         | Null | Key | Default | Extra |

+-----------------------+--------------+------+-----+---------+-------+

| lock_id               | varchar(36)  | NO   | PRI |         |       |

| lock_principal        | varchar(255) | NO   |     |         |       |

| lock_origin_timestamp | int(11)      | NO   |     | 0       |       |

| lock_update_timestamp | int(11)      | NO   |     | 0       |       |

| lock_expiry_timestamp | int(11)      | NO   |     | 0       |       |

| lock_type             | int(11)      | NO   |     | 0       |       |

+-----------------------+--------------+------+-----+---------+-------+

6 rows in set (0.00 sec)



Still missing two fields.

Did you get an error when installing the database through setup.php? 
All fields mentioned in the error message exist in 
scripts/sql/create.xml.

The script at scripts/setup.php in Horde Groupware Webmail Edition 1.2 
generates a wrong database schema.

After making a fresh install for example my horde_locks has no 
attribute lock_owner and lock_scope



This produces this error: Oct 05 17:40:12 HORDE [error] [horde] DB 
Error: no such field: SELECT lock_id, lock_owner, lock_scope, 
lock_principal, lock_origin_timestamp, lock_update_tim

estamp, lock_expiry_timestamp, lock_type FROM horde_locks WHERE 
lock_expiry_timestamp >= 1223221212 AND lock_principal = 
'/nag/hauke@hauke-m.de/hauke@hauke-m

.de.ics' AND lock_scope = 'webdav' [nativecode=1054 ** Unknown column 
'lock_owner' in 'field list'] [pid 21056 on line 536 of 
"/var/www/horde/web/lib/Horde/R

PC/webdav.php"]



After installing the tables from groupware.mysql.sql it works.

This is not the only difference between groupware.mysql.sql and the 
installed tables.