Menu
▾
▴
Re: [eGroupWare-users] several issues after upgrade from 1.6 to 14.1 - database and gui remnants from old version
|
From: Ralf B. <rb...@st...> - 2014-10-27 15:17:07
|
Am 27.10.14 um 06:34 schrieb Harondel J. Sibble:
> So all the error info below is coming from the
>
> emailadmin-Requires upgrade - U EMailAdmin 1.6.001 14.1
Looks like some update already run, or you have not removed excess
tables, after importing older backup again.
> process, all the other apps upgrade without issues
>
> I see SyncML is gone :-(
>
> Problem resolution:
> "syncml" is broken Because its sources are missing!
> The tables are still in the database..
> You should either install the sources or uninstall it, to get rid of the
> tables..
>
> Searching the list history, doesn't look like much of any discussion on
> SyncML in a while, is SyncML going away now Ralf?
Yep, SyncML is gone from 14.1 in favor of CalDAV/CardDAV or eSync
(ActiveSync) with a strong preference for CalDAV/CardDAV.
Ralf
> I see a discussion in the German forums, but I don't read German :-(
>
>
> On 26 Oct 2014 at 22:07, Harondel J. Sibble wrote:
>
>> 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'
>>
>>
>>
>>
>>
>> On 26 Oct 2014 at 21:41, egr...@li... wrote:
>>
>>> 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_instru
>>> ct 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.
>> har...@pd... (use pgp keyid 0x3CC3CFCE not 0x3AD5C11D)
>> http://www.pdscc.com
>> Blog: http://www.pdscc.com/blog
>> (604) 739-3709 (voice)
>>
>>
>> ------------------------------------------------------------------------------
>> _______________________________________________ eGroupWare-users mailing list
>> eGr...@li...
>> https://lists.sourceforge.net/lists/listinfo/egroupware-users
>
--
Ralf Becker
Director Software Development
Stylite AG
Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30
Email: rb...@st...
www.stylite.de | www.egroupware.org
Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer
VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany
|
