Hallo zusammen,
nach dem upgrade sind keine Termine mehr im Kalender sichtbar.
Im setup-Hauptmenue waren einige Anwendungen nicht aktualisiert, habe wie unten angegeben die tmp_Tabelle gelöscht, dann ließen sich die Anwendungen aktualisieren. Leider werden immer noch keine Termine angezeigt!
Habe daraufhin versucht die Sicherung einzuspielen, dabei gab es folgende Fehlermeldung:
AlterColumnSQL('egw_links','link_app1 C(16) CONSTRAINT "CHARACTER SET ascii" NOTNULL','link_id I AUTOINCREMENT NOTNULL PRIMARY, link_app1 C(16) CONSTRAINT "CHARACTER SET ascii" NOTNULL, link_id1 C(50) NOTNULL, link_app2 C(25) NOTNULL, link_id2 C(50) NOTNULL, link_remark C(100), link_lastmod I8 NOTNULL, link_owner I4 NOTNULL, deleted T') sql=Array ( [0] => ALTER TABLE `egw_links` MODIFY COLUMN `link_app1` VARCHAR(16) CHARACTER SET ascii NOT NULL )
Data too long for column 'link_app1' at row 2052
AlterColumnSQL('egw_links','link_app2 C(16) CONSTRAINT "CHARACTER SET ascii" NOTNULL','link_id I AUTOINCREMENT NOTNULL PRIMARY, link_app1 C(25) NOTNULL, link_id1 C(64) NOTNULL, link_app2 C(16) CONSTRAINT "CHARACTER SET ascii" NOTNULL, link_id2 C(50) NOTNULL, link_remark C(100), link_lastmod I8 NOTNULL, link_owner I4 NOTNULL, deleted T') sql=Array ( [0] => ALTER TABLE `egw_links` MODIFY COLUMN `link_app2` VARCHAR(16) CHARACTER SET ascii NOT NULL )
Data too long for column 'link_app2' at row 2052
AlterColumnSQL('egw_addressbook','cat_id C(255) CONSTRAINT "CHARACTER SET ascii"','contact_id I AUTOINCREMENT NOTNULL PRIMARY, contact_tid C(1) DEFAULT 'n', contact_owner I8 NOTNULL, contact_private I1 NOQUOTE DEFAULT 0, cat_id C(255) CONSTRAINT "CHARACTER SET ascii", n_family C(64), n_given C(64), n_middle C(64), n_prefix C(64), n_suffix C(64), n_fn C(128), n_fileas C(255), contact_bday C(12), org_name C(128), org_unit C(64), contact_title C(64), contact_role C(64), contact_assistent C(64), contact_room C(64), adr_one_street C(64), adr_one_street2 C(64), adr_one_locality C(64), adr_one_region C(64), adr_one_postalcode C(64), adr_one_countryname C(64), contact_label X, adr_two_street C(64), adr_two_street2 C(64), adr_two_locality C(64), adr_two_region C(64), adr_two_postalcode C(64), adr_two_countryname C(64), tel_work C(40), tel_cell C(40), tel_fax C(40), tel_assistent C(40), tel_car C(40), tel_pager C(40), tel_home C(40), tel_fax_home C(40), tel_cell_private C(40), tel_other C(40), tel_prefer C(32), contact_email C(128), contact_email_home C(128), contact_url C(128), contact_url_home C(128), contact_freebusy_uri C(128), contact_calendar_uri C(128), contact_note X, contact_tz C(8), contact_geo C(32), contact_pubkey X, contact_created I8, contact_creator I4 NOTNULL, contact_modified I8 NOTNULL, contact_modifier I4, contact_jpegphoto B, account_id I4, contact_etag I4 NOQUOTE DEFAULT 0, contact_uid C(255), adr_one_countrycode C(2), adr_two_countrycode C(2), carddav_name C(200)') sql=Array ( [0] => ALTER TABLE `egw_addressbook` MODIFY COLUMN `cat_id` VARCHAR(255) CHARACTER SET ascii )
Incorrect string value: '\xC3\x9Fo\xC3\x97*...' for column 'cat_id' at row 3303
Invalid SQL: INSERT INTO egw_cal_user (cal_id,cal_recur_date,cal_user_type,cal_user_id,cal_status,cal_quantity,cal_role,cal_user_modified,cal_user_auto) SELEcT DISTINCT cal_id,cal_recur_date,cal_user_type,cal_user_id,cal_status,cal_quantity,cal_role,cal_user_modified,NULL FROM tmp_egw_cal_user
Incorrect string value: '\xC3\xBCnder...' for column 'cal_user_id' at row 14365 (1366)
Ich habe daraufhin die Tabelle tmp_egw_cal_user nach egw_cal_user kopiert und es funktioniert jetzt wieder.
War das ausreichend?
Was muss man machen, damit updates weiterhin funktionieren?
