Hallo zusammen,
nach dem Restore des DB-Backups aus Version 1.8 auf 17.1 und anschließendem Starten der Migration tritt folgender Fehler auf:
Invalid SQL: SELECT contact_files FROM egw_addressbook WHERE contact_id=1245
Unknown column ‘contact_files’ in ‘field list’ (1054)
Die 17.1 läuft auf CentOS 7.4 (also mit mariadb/mysql)
Hier weitere Details. Ich bin für jeden Hinweis dankbar, vielen Dank im Voraus!
process->pass(): #1 for upgrade processing
process->upgrade(): Incoming : appname: phpgwapi, version: 1.8.001, status: U
process->upgrade(): phpgwapi(1.8.001 --> 14.3.909): running phpgwapi_upgrade1_8_001() --> 1.9.001
process->upgrade(): phpgwapi(1.9.001 --> 14.3.909): running phpgwapi_upgrade1_9_001() --> 1.9.002
process->upgrade(): phpgwapi(1.9.002 --> 14.3.909): running phpgwapi_upgrade1_9_002() --> 1.9.003
process->upgrade(): phpgwapi(1.9.003 --> 14.3.909): running phpgwapi_upgrade1_9_003() --> 1.9.004
process->upgrade(): phpgwapi(1.9.004 --> 14.3.909): running phpgwapi_upgrade1_9_004() --> 1.9.005
process->upgrade(): phpgwapi(1.9.005 --> 14.3.909): running phpgwapi_upgrade1_9_005()
CreateIndexSQL(‘egw_access_log’,‘li’,Array ( ) ,‘egw_access_log_li’) sql=Array ( [0] => ALTER TABLE egw_access_log
ADD INDEX egw_access_log_li
(li
) )
Duplicate key name ‘egw_access_log_li’
–> 1.9.006
process->upgrade(): phpgwapi(1.9.006 --> 14.3.909): running phpgwapi_upgrade1_9_006() --> 1.9.007
process->upgrade(): phpgwapi(1.9.007 --> 14.3.909): running phpgwapi_upgrade1_9_007() --> 1.9.008
process->upgrade(): phpgwapi(1.9.008 --> 14.3.909): running phpgwapi_upgrade1_9_008() --> 1.9.009
process->upgrade(): phpgwapi(1.9.009 --> 14.3.909): running phpgwapi_upgrade1_9_009()
Enabling password migration to blowfish_crypt
–> 1.9.010
process->upgrade(): phpgwapi(1.9.010 --> 14.3.909): running phpgwapi_upgrade1_9_010() --> 1.9.011
process->upgrade(): phpgwapi(1.9.011 --> 14.3.909): running phpgwapi_upgrade1_9_011() --> 1.9.012
process->upgrade(): phpgwapi(1.9.012 --> 14.3.909): running phpgwapi_upgrade1_9_012()
CreateIndexSQL(‘egw_addressbook’,‘contact_modified’,Array ( ) ,‘egw_addressbook_contact_modified’) sql=Array ( [0] => ALTER TABLE egw_addressbook
ADD INDEX egw_addressbook_contact_modified
(contact_modified
) )
Duplicate key name ‘egw_addressbook_contact_modified’
–> 1.9.013
process->upgrade(): phpgwapi(1.9.013 --> 14.3.909): running phpgwapi_upgrade1_9_013() --> 1.9.014
process->upgrade(): phpgwapi(1.9.014 --> 14.3.909): running phpgwapi_upgrade1_9_014() --> 1.9.015
process->upgrade(): phpgwapi(1.9.015 --> 14.3.909): running phpgwapi_upgrade1_9_015() --> 1.9.016
process->upgrade(): phpgwapi(1.9.016 --> 14.3.909): running phpgwapi_upgrade1_9_016() --> 1.9.017
process->upgrade(): phpgwapi(1.9.017 --> 14.3.909): running phpgwapi_upgrade1_9_017()
CreateIndexSQL(‘egw_history_log’,Array ( [0] => history_appname [1] => history_record_id [2] => history_id ) ,Array ( ) ,‘egw_history_log_appname_record_id_id’) sql=Array ( [0] => ALTER TABLE egw_history_log
ADD INDEX egw_history_log_appname_record_id_id
(history_appname
, history_record_id
, history_id
) )
Duplicate key name ‘egw_history_log_appname_record_id_id’
–> 1.9.018
process->upgrade(): phpgwapi(1.9.018 --> 14.3.909): running phpgwapi_upgrade1_9_018() --> 1.9.019
process->upgrade(): phpgwapi(1.9.019 --> 14.3.909): running phpgwapi_upgrade1_9_019() --> 1.9.020
process->upgrade(): phpgwapi(1.9.020 --> 14.3.909): running phpgwapi_upgrade1_9_020() --> 1.9.021
process->upgrade(): phpgwapi(1.9.021 --> 14.3.909): running phpgwapi_upgrade1_9_021() --> 14.1
process->upgrade(): phpgwapi(14.1 --> 14.3.909): running phpgwapi_upgrade14_1() --> 14.1.900
process->upgrade(): phpgwapi(14.1.900 --> 14.3.909): running phpgwapi_upgrade14_1_900()
Invalid SQL: SELECT contact_files FROM egw_addressbook WHERE contact_id=1245
Unknown column ‘contact_files’ in ‘field list’ (1054)