[horde] Task, Memo, Calendar Issue

[Jan Schneider]

Zitat von Carlos Bergero <rak at fcien.edu.uy>:

> I install lately Horde Groupware webmail version 1.2.3 in two  
> servers, in both im experiencing some database issues that are  
> annoying to say the least, though I have some troubles at the  
> beginning the instalation was smooth in one server Im using Apache2  
> and Postgresql 8 with php5 in the other I'm using MySQL 5 instead of  
> Postgres with apache2 and php5.
> The problem seam to rise when trying to create a new task memo or  
> Calendar which call forth a function that attemp to insert a la  
> tabla _seq, for example kronolith_share_seq this is the horde.log  
> output after traying to create a new calendar:
> May 27 17:09:37 HORDE [debug] [kronolith] Hook  
> _horde_hook_share_init in application horde not called. [pid 29265  
> on line 1688 of "/var/www/horde/lib/Horde.php"]
> May 27 17:09:37 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: La columna 'id' en field list  
> es desconocida]  [pid 29265 on line 1020 of  
> "/var/www/horde/lib/Horde/Share/sql.php"]
> May 27 17:09:37 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: La columna 'id' en  
> field list es desconocida]  [pid 29265 on line 1020 of  
> "/var/www/horde/lib/Horde/Share/sql.php"]
> May 27 17:09:37 HORDE [debug] [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: La columna 'id' en field list  
> es desconocida]  [pid 29265 on line 176 of   
> "/var/www/horde/lib/Horde/Notification.php"]
> May 27 17:09:38 HORDE [debug] [kronolith] Hook  
> _horde_hook_share_init in application horde not called. [pid 29265  
> on line 1688 of "/var/www/horde/lib/Horde.php"]
> May 27 17:09:38 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: La columna 'id' en field list  
> es desconocida]  [pid 29265 on line 1020 of  
> "/var/www/horde/lib/Horde/Share/sql.php"]
> May 27 17:09:38 HORDE [debug] [kronolith] SQL query by  
> Horde_Alarm_sql::_list(): SELECT alarm_id, alarm_uid, alarm_start,  
> alarm_end, alarm_methods, alarm_par ams, alarm_title, alarm_text,  
> alarm_snooze, alarm_internal FROM horde_alarms WHERE alarm_dismissed  
> = 0 AND ((alarm_snooze IS NULL AND alarm_start <= ?)   OR al
> arm_snooze <= ?) AND (alarm_end IS NULL OR alarm_end >= ?) AND  
> (alarm_uid = ? OR alarm_uid = ?) ORDER BY alarm_start, alarm_end  
> [pid 29265 on line 148  of "/var/www/horde/lib/Horde/Alarm/sql.php"]
> May 27 17:09:39 HORDE [debug] [kronolith] Hook  
> _horde_hook_share_init in application horde not called. [pid 29287  
> on line 1688 of "/var/www/horde/lib/Horde.php"]
> May 27 17:09:39 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: La columna 'id' en field list  
> es desconocida]
>
> It seams to be traying to incert something in the shares_seq table  
> but this table has no structure and the .sql files of horde or  
> kronolith dont create any structure, the same happends when I try to  
> create a task or note.

The datebase user that you specified in the setup (the one to use in  
Horde, not the one to create the database) must have sufficient  
permissions to create new and change existing tables in the horde  
database.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digitale PGP-Unterschrift
URL: <http://lists.horde.org/archives/horde/attachments/20090528/d65a970e/attachment.bin>