Bonjour,
j’ai effectué la mise à jour de EGW 1.6 vers 1.8 (sous Ubuntu 10).
Je n’arrive pas à mettre à jour le calendrier (Cf. message d’erreur):
process->upgrade(): Incoming : appname: calendar, version: 1.6.003, status: U
process->upgrade(): calendar(1.6.003 --> 1.9.004): running calendar_upgrade1_6_003()
AlterColumnSQL(‘egw_cal’,‘cal_creator’,Array ( [type] => int [precision] => 4 [comment] => creating user ) ) sql=Array ( [0] => ALTER TABLE egw_cal ADD cal_creator INTEGER )
Duplicate column name ‘cal_creator’
AlterColumnSQL(‘egw_cal’,‘cal_created’,Array ( [type] => int [precision] => 8 [comment] => creation time of event ) ) sql=Array ( [0] => ALTER TABLE egw_cal ADD cal_created BIGINT )
Duplicate column name ‘cal_created’
AlterColumnSQL(‘egw_cal’,‘cal_recurrence’,Array ( [type] => int [precision] => 8 [nullable] => [default] => 0 [comment] => cal_start of original recurrence for exception ) ) sql=Array ( [0] => ALTER TABLE egw_cal ADD cal_recurrence BIGINT NOT NULL DEFAULT 0 )
Duplicate column name ‘cal_recurrence’
–> 1.7.001
process->upgrade(): calendar(1.7.001 --> 1.9.004): running calendar_upgrade1_7_001()
AlterColumnSQL(‘egw_cal_user’,‘cal_role’,Array ( [type] => varchar [precision] => 64 [default] => REQ-PARTICIPANT ) ) sql=Array ( [0] => ALTER TABLE egw_cal_user ADD cal_role VARCHAR(64) DEFAULT ‘REQ-PARTICIPANT’ )
Duplicate column name ‘cal_role’
–> 1.7.002
process->upgrade(): calendar(1.7.002 --> 1.9.004): running calendar_upgrade1_7_002()
CreateTableSQL(‘egw_cal_timezones’,‘tz_id I AUTOINCREMENT NOTNULL PRIMARY, tz_tzid C(128) NOTNULL, tz_alias I4, tz_latitude I4, tz_longitude I4, tz_component X’) sql=Array ( [0] => CREATE TABLE egw_cal_timezones ( tz_id INTEGER NOT NULL AUTO_INCREMENT, tz_tzid VARCHAR(128) NOT NULL, tz_alias INTEGER, tz_latitude INTEGER, tz_longitude INTEGER, tz_component TEXT, PRIMARY KEY (tz_id) )CHARACTER SET latin1 )
Table ‘egw_cal_timezones’ already exists
CreateIndexSQL(NULL,‘egw_cal_timezones’,‘tz_tzid’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => ALTER TABLE egw_cal_timezones ADD UNIQUE INDEX egw_cal_timezones_tz_tzid (tz_tzid) )
Duplicate key name ‘egw_cal_timezones_tz_tzid’
CreateIndexSQL(NULL,‘egw_cal_timezones’,‘tz_alias’,Array ( ) ) sql=Array ( [0] => ALTER TABLE egw_cal_timezones ADD INDEX egw_cal_timezones_tz_alias (tz_alias) )
Duplicate key name 'egw_cal_timezones_tz_alias’
An error happened
calendar_timezones::import_sqlite(‘calendar/setup/timezones.sqlite’) required SQLite support (PHP extension pdo_sqlite) missing!
De ce fait, l’accès au calendrier n’est plus possible:
Database error
Invalid SQL: (SELECT egw_cal_repeats.recur_type,egw_cal_repeats.recur_enddate,egw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,egw_cal_repeats.recur_exception,egw_cal.cal_id,cal_uid,cal_owner,cal_category,cal_modified,cal_priority,cal_public,cal_title,cal_description,cal_location,cal_reference,cal_modifier,cal_non_blocking,cal_special,cal_etag,cal_creator,cal_created,cal_recurrence,cal_start,cal_end,egw_cal_user.cal_recur_date,NULL AS participants,NULL AS icons FROM egw_cal JOIN egw_cal_dates ON egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user ON egw_cal.cal_id=egw_cal_user.cal_id LEFT JOIN egw_cal_repeats ON egw_cal.cal_id=egw_cal_repeats.cal_id WHERE cal_deleted IS NULL AND egw_cal_user.cal_status!=‘X’ AND 1338156000 < cal_end AND cal_start < 1341176400 AND egw_cal_user.cal_user_type=‘r’ AND egw_cal_user.cal_user_id IN (‘4’,‘5’) AND recur_type IS NULL AND egw_cal_user.cal_recur_date=0 )
UNION
(SELECT egw_cal_repeats.recur_type,egw_cal_repeats.recur_enddate,egw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,egw_cal_repeats.recur_exception,egw_cal.cal_id,cal_uid,cal_owner,cal_category,cal_modified,cal_priority,cal_public,cal_title,cal_description,cal_location,cal_reference,cal_modifier,cal_non_blocking,cal_special,cal_etag,cal_creator,cal_created,cal_recurrence,cal_start,cal_end,egw_cal_user.cal_recur_date,NULL AS participants,NULL AS icons FROM egw_cal JOIN egw_cal_dates ON egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user ON egw_cal.cal_id=egw_cal_user.cal_id LEFT JOIN egw_cal_repeats ON egw_cal.cal_id=egw_cal_repeats.cal_id WHERE cal_deleted IS NULL AND egw_cal_user.cal_status!=‘X’ AND 1338156000 < cal_end AND cal_start < 1341176400 AND egw_cal_user.cal_user_type=‘r’ AND egw_cal_user.cal_user_id IN (‘4’,‘5’) AND egw_cal_user.cal_recur_date=cal_start )
UNION
(SELECT egw_cal_repeats.recur_type,egw_cal_repeats.recur_enddate,egw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,egw_cal_repeats.recur_exception,egw_cal.cal_id,cal_uid,cal_owner,cal_category,cal_modified,cal_priority,cal_public,cal_title,cal_description,cal_location,cal_reference,cal_modifier,cal_non_blocking,cal_special,cal_etag,cal_creator,cal_created,cal_recurrence,cal_start,cal_end,egw_cal_user.cal_recur_date,NULL AS participants,NULL AS icons FROM egw_cal JOIN egw_cal_dates ON egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user ON egw_cal.cal_id=egw_cal_user.cal_id LEFT JOIN egw_cal_repeats ON egw_cal.cal_id=egw_cal_repeats.cal_id WHERE cal_deleted IS NULL AND egw_cal_user.cal_status!=‘X’ AND 1338156000 < cal_end AND cal_start < 1341176400 AND egw_cal_user.cal_user_type=‘u’ AND egw_cal_user.cal_user_id IN (‘5’,’-9’,’-1’,’-36’,’-2’) AND recur_type IS NULL AND egw_cal_user.cal_recur_date=0 )
UNION
(SELECT egw_cal_repeats.recur_type,egw_cal_repeats.recur_enddate,egw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,egw_cal_repeats.recur_exception,egw_cal.cal_id,cal_uid,cal_owner,cal_category,cal_modified,cal_priority,cal_public,cal_title,cal_description,cal_location,cal_reference,cal_modifier,cal_non_blocking,cal_special,cal_etag,cal_creator,cal_created,cal_recurrence,cal_start,cal_end,egw_cal_user.cal_recur_date,NULL AS participants,NULL AS icons FROM egw_cal JOIN egw_cal_dates ON egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user ON egw_cal.cal_id=egw_cal_user.cal_id LEFT JOIN egw_cal_repeats ON egw_cal.cal_id=egw_cal_repeats.cal_id WHERE cal_deleted IS NULL AND egw_cal_user.cal_status!=‘X’ AND 1338156000 < cal_end AND cal_start < 1341176400 AND egw_cal_user.cal_user_type=‘u’ AND egw_cal_user.cal_user_id IN (‘5’,’-9’,’-1’,’-36’,’-2’) AND egw_cal_user.cal_recur_date=cal_start )
ORDER BY cal_start:
Unknown column ‘cal_deleted’ in ‘where clause’
Click here to resume your eGroupWare Session.
Quelles sont les opérations à effectuer ?
Merci.
Cordialement.
F. STOCK
