[horde] Task, Memo, Calendar Issue

Carlos Bergero rak at fcien.edu.uy
Wed May 27 20:43:09 UTC 2009


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.

Any advice is wellcame.
Sincerely,
                Carlos Bergero




More information about the horde mailing list