Hi all,
I upgraded from 16 -> 17. Everything else went smoothly, but not Infolog-upgrade.
I got the following error message from the system:
App install/remove/upgrade:
CreateTableSQL(‘egw_infolog_users’,‘info_res_id I AUTOINCREMENT NOTNULL PRIMARY, info_id I4 NOTNULL, account_id I4 NOTNULL, info_res_deleted L, info_res_modified T DEFTIMESTAMP, info_res_modifier I4, info_res_status C(16) DEFAULT ‘NEEDS-ACTION’, info_res_attendee C(255)’) sql=Array ( [0] => CREATE TABLE egw_infolog_users ( info_res_id INTEGER NOT NULL AUTO_INCREMENT, info_id INTEGER NOT NULL, account_id INTEGER NOT NULL, info_res_deleted TINYINT, info_res_modified TIMESTAMP, info_res_modifier INTEGER, info_res_status VARCHAR(16) DEFAULT ‘NEEDS-ACTION’, info_res_attendee VARCHAR(255), PRIMARY KEY (info_res_id) )CHARACTER SET utf8 )
Table ‘egw_infolog_users’ already exists
CreateIndexSQL(‘egw_infolog_users’,Array ( [0] => info_id [1] => account_id ) ,Array ( [0] => UNIQUE ) ,‘egw_infolog_users_id_account_id’) sql=Array ( [0] => ALTER TABLE egw_infolog_users ADD UNIQUE INDEX egw_infolog_users_id_account_id (info_id, account_id) )
Duplicate key name ‘egw_infolog_users_id_account_id’
CreateIndexSQL(‘egw_infolog_users’,‘account_id’,Array ( ) ,‘egw_infolog_users_account_id’) sql=Array ( [0] => ALTER TABLE egw_infolog_users ADD INDEX egw_infolog_users_account_id (account_id) )
Duplicate key name ‘egw_infolog_users_account_id’
Database error
Invalid SQL: INSERT INTO egw_infolog_users (info_id,account_id) VALUES (2,’-1’)
Duplicate entry ‘2–1’ for key ‘egw_infolog_users_id_account_id’ (1062)
Any good ways to handle the issue?
Fortunately everything seems to work despite the error.
Br. JaJu
