[Tickets #8206] unable to create new calendar

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/8206
------------------------------------------------------------------------------
  Ticket             | 8206
  Created By         | jpedwardspost at yahoo.co.uk
  Summary            | unable to create new calendar
  Queue              | Horde Groupware Webmail Edition
  Version            | 1.2.3-RC1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


jpedwardspost at yahoo.co.uk (2009-04-22 05:42) wrote:

Fresh install of horde groupware webmail edition 1.2.3-RC1 on Ubuntu  
Linux webserver, PHP Version: 4.4.2-1

Login to horde as Imp authorised user and unable to create a new calendar.

Message in horde.log (pasted at the bottom) complains about Unknown  
column 'id' in 'field list' for table kronolith_shares_seq.

Problem seems to be resolved by renaming existing column 'sequence' to  
new name of 'id'.
ALTER TABLE `kronolith_shares_seq` CHANGE `sequence` `id` INT( 11 )  
NOT NULL AUTO_INCREMENT

--------Message in horde.log pasted below------
Apr 21 16:17:53 HORDE [error] [kronolith] MDB2 Error: no such field:  
_doquery: [Error message: Could not execute statement]
[Last executed query: INSERT INTO kronolith_shares_seq (id) VALUES (NULL)]
[Native code: 1054]
[Native message: Unknown column 'id' in 'field list']
  [pid 5574 on line 1006 of  
"/var/www/vhosts/mywebsite.co.uk/httpdocs/horde/lib/Horde/Share/sql.php"]
--------Paste End----------