Popped back into the setup screen and after a restart of the server and
reload of site, it’s no longer showing the 1.6 logo and such and the database
has been upgraded, but the application upgrades are failing.
I also note SyncML is showing as gone, procedure to get it back?
App install/remove/upgrade:
AlterColumnSQL('egw_emailadmin','ea_stationery_active_templates',Array (
[type] => text ) ) sql=Array ( [0] => ALTER TABLE `egw_emailadmin` ADD
`ea_stationery_active_templates` TEXT )
Duplicate column name 'ea_stationery_active_templates'
CreateTableSQL('egw_mailaccounts','mail_id I AUTOINCREMENT NOTNULL PRIMARY,
account_id I4 NOTNULL, mail_type I1 NOTNULL, mail_value C(128) NOTNULL')
sql=Array ( [0] => CREATE TABLE `egw_mailaccounts` ( `mail_id` INTEGER NOT
NULL AUTO_INCREMENT, `account_id` INTEGER NOT NULL, `mail_type` TINYINT NOT
NULL, `mail_value` VARCHAR(128) NOT NULL, PRIMARY KEY (`mail_id`) )CHARACTER
SET latin1 )
Table 'egw_mailaccounts' already exists
CreateIndexSQL(NULL,'egw_mailaccounts','mail_value',Array ( ) ) sql=Array (
[0] => ALTER TABLE `egw_mailaccounts` ADD INDEX `egw_mailaccounts_value`
(`mail_value`) )
Duplicate key name 'egw_mailaccounts_value'
CreateIndexSQL(NULL,'egw_mailaccounts',Array ( [0] => account_id [1] =>
mail_type ) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE `egw_mailaccounts`
ADD INDEX `egw_mailaccounts_account_id_type` (`account_id`, `mail_type`) )
Duplicate key name 'egw_mailaccounts_account_id_type'
CreateTableSQL('egw_ea_accounts','acc_id I AUTOINCREMENT NOTNULL PRIMARY,
acc_name C(80), ident_id I4 NOTNULL, acc_imap_host C(128) NOTNULL,
acc_imap_ssl I1 NOTNULL NOQUOTE DEFAULT 0, acc_imap_port I4 NOTNULL NOQUOTE
DEFAULT 143, acc_sieve_enabled L NOQUOTE DEFAULT 0, acc_sieve_host C(128),
acc_sieve_port I4 NOQUOTE DEFAULT 4190, acc_folder_sent C(128),
acc_folder_trash C(128), acc_folder_draft C(128), acc_folder_template C(128),
acc_smtp_host C(128), acc_smtp_ssl I1 NOTNULL NOQUOTE DEFAULT 0,
acc_smtp_port I4 NOTNULL NOQUOTE DEFAULT 25, acc_smtp_type C(32) DEFAULT
'emailadmin_smtp', acc_imap_type C(32) DEFAULT 'emailadmin_imap',
acc_imap_logintype C(20), acc_domain C(100), acc_further_identities L NOTNULL
NOQUOTE DEFAULT 1, acc_user_editable L NOTNULL NOQUOTE DEFAULT 1,
acc_sieve_ssl I1 NOQUOTE DEFAULT 1, acc_modified T DEFTIMESTAMP NOTNULL,
acc_modifier I4, acc_smtp_auth_session L') sql=Array ( [0] => CREATE TABLE
`egw_ea_accounts` ( `acc_id` INTEGER NOT NULL AUTO_INCREMENT, `acc_name`
VARCHAR(80), `ident_id` INTEGER NOT NULL, `acc_imap_host` VARCHAR(128) NOT
NULL, `acc_imap_ssl` TINYINT NOT NULL DEFAULT 0, `acc_imap_port` INTEGER NOT
NULL DEFAULT 143, `acc_sieve_enabled` TINYINT DEFAULT 0, `acc_sieve_host`
VARCHAR(128), `acc_sieve_port` INTEGER DEFAULT 4190, `acc_folder_sent`
VARCHAR(128), `acc_folder_trash` VARCHAR(128), `acc_folder_draft`
VARCHAR(128), `acc_folder_template` VARCHAR(128), `acc_smtp_host`
VARCHAR(128), `acc_smtp_ssl` TINYINT NOT NULL DEFAULT 0, `acc_smtp_port`
INTEGER NOT NULL DEFAULT 25, `acc_smtp_type` VARCHAR(32) DEFAULT
'emailadmin_smtp', `acc_imap_type` VARCHAR(32) DEFAULT 'emailadmin_imap',
`acc_imap_logintype` VARCHAR(20), `acc_domain` VARCHAR(100),
`acc_further_identities` TINYINT NOT NULL DEFAULT 1, `acc_user_editable`
TINYINT NOT NULL DEFAULT 1, `acc_sieve_ssl` TINYINT DEFAULT 1, `acc_modified`
TIMESTAMP NOT NULL, `acc_modifier` INTEGER, `acc_smtp_auth_session` TINYINT,
PRIMARY KEY (`acc_id`) )CHARACTER SET latin1 )
Table 'egw_ea_accounts' already exists
CreateTableSQL('egw_ea_credentials','cred_id I AUTOINCREMENT NOTNULL PRIMARY,
acc_id I4 NOTNULL, cred_type I1 NOTNULL, account_id I4 NOTNULL, cred_username
C(80) NOTNULL, cred_password C(80), cred_pw_enc I1 NOQUOTE DEFAULT 0')
sql=Array ( [0] => CREATE TABLE `egw_ea_credentials` ( `cred_id` INTEGER NOT
NULL AUTO_INCREMENT, `acc_id` INTEGER NOT NULL, `cred_type` TINYINT NOT NULL,
`account_id` INTEGER NOT NULL, `cred_username` VARCHAR(80) NOT NULL,
`cred_password` VARCHAR(80), `cred_pw_enc` TINYINT DEFAULT 0, PRIMARY KEY
(`cred_id`) )CHARACTER SET latin1 )
Table 'egw_ea_credentials' already exists
CreateIndexSQL(NULL,'egw_ea_credentials',Array ( [0] => acc_id [1] =>
account_id [2] => cred_type ) ,Array ( [0] => UNIQUE ) ) sql=Array ( [0] =>
ALTER TABLE `egw_ea_credentials` ADD UNIQUE INDEX
`egw_ea_credentials_acc_id_account_id_cred_type` (`acc_id`, `account_id`,
`cred_type`) )
Duplicate key name 'egw_ea_credentials_acc_id_account_id_cred_type'
CreateTableSQL('egw_ea_identities','ident_id I AUTOINCREMENT NOTNULL PRIMARY,
acc_id I4 NOTNULL, ident_realname C(128) NOTNULL, ident_email C(128),
ident_org C(128), ident_signature X, account_id I4 NOTNULL NOQUOTE DEFAULT
0') sql=Array ( [0] => CREATE TABLE `egw_ea_identities` ( `ident_id` INTEGER
NOT NULL AUTO_INCREMENT, `acc_id` INTEGER NOT NULL, `ident_realname`
VARCHAR(128) NOT NULL, `ident_email` VARCHAR(128), `ident_org` VARCHAR(128),
`ident_signature` TEXT, `account_id` INTEGER NOT NULL DEFAULT 0, PRIMARY KEY
(`ident_id`) )CHARACTER SET latin1 )
Table 'egw_ea_identities' already exists
CreateTableSQL('egw_ea_valid','acc_id I4 NOTNULL, account_id I4 NOTNULL')
sql=Array ( [0] => CREATE TABLE `egw_ea_valid` ( `acc_id` INTEGER NOT NULL,
`account_id` INTEGER NOT NULL )CHARACTER SET latin1 )
Table 'egw_ea_valid' already exists
CreateIndexSQL(NULL,'egw_ea_valid',Array ( [0] => acc_id [1] => account_id )
,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => ALTER TABLE `egw_ea_valid` ADD
UNIQUE INDEX `egw_ea_valid_acc_id_account_id` (`acc_id`, `account_id`) )
Duplicate key name 'egw_ea_valid_acc_id_account_id'
CreateIndexSQL(NULL,'egw_ea_valid',Array ( [0] => account_id [1] => acc_id )
,Array ( ) ) sql=Array ( [0] => ALTER TABLE `egw_ea_valid` ADD INDEX
`egw_ea_valid_account_id_acc_id` (`account_id`, `acc_id`) )
Duplicate key name 'egw_ea_valid_account_id_acc_id'
Post 14.1 from 1.6.002 upgrade, so far I am only seeing 1 issue. I followed
the directions here
http://www.egroupware.org/fileadmin/content/Get_help/EPL_Installation_instruct
ions/EN-CE-Installation.html
And as I was already doing a scheduled backup of the database every 3 hours, I
was okay there. OS is CentOS 5.11.
The one thing that has thrown me off in the instructions is
After the installation you will need to restore and migrate the saved
database backup using EGroupware setup. You may need to add/change your
egroupware database password in /var/lib/egroupware/header.inc.php. The
variables you need to change are: db_user and db_pass.
However there isn’t any explanation on the process to do that. After the
upgrade was completed, I went to my usual url and my data (calendar in
particular) was all there.
Is there still another step I do need to take database wise?
I have seen the following error a few times, but not quite sure yet under what
circumstances to reliably reproduce it.
Database error
Invalid SQL: SELECT * FROM egw_notificationpopup WHERE account_id=6 AND
notify_type='base' Unknown column 'notify_type' in 'where clause' (1054)
Also oddly enough if I got the setup URL, it shows
eGroupWare Version 14.1
on the bottom of the screen, but
Stylite 1.6
E-Groupware
in the top left corner.
Suggested next steps?
–
Harondel J. Sibble
Sibble Computer Consulting Ltd.
Creating Solutions for the small and medium business computer user.
harondel@pdscc.com (use pgp keyid 0x3CC3CFCE not 0x3AD5C11D)
http://www.pdscc.com
Blog: http://www.pdscc.com/blog
(604) 739-3709 (voice)
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
