'contacts lost and cannot be created after upgrade 3.0 > 3.3'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: kolab-users
Subject: contacts lost and cannot be created after upgrade 3.0 > 3.3
From: "Rohrer, Bernhard" <graylion () sm-wg ! net>
Date: 2015-02-28 12:59:14
Message-ID: 2823c5a5a239ee2f6035beedb9b4fc3d () sm-wg ! net
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

Hi guys 

we had a 3.0 installation that we upgraded to 3.3 using the upgrade
notes.
https://docs.kolab.org/administrator-guide/upgrading-from-kolab-3.1-to-3.3.html
[1] 

But clearly some weird things happened. 

1) All contacts are gone. When you type one that used to be there, you
still see the name, but without email address. Creating one displays it
while you are in that part of the address book. When you leave and
return it is gone. 

we did 

DROP TABLE IF EXISTS `sharedfolder_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sharedfolder_types` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `key` text NOT NULL,
 `name` varchar(256) NOT NULL,
 `description` text NOT NULL,
 `attributes` longtext NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sharedfolder_types`
--

LOCK TABLES `sharedfolder_types` WRITE;
/*!40000 ALTER TABLE `sharedfolder_types` DISABLE KEYS */;
INSERT INTO `sharedfolder_types` VALUES (1,'addressbook','Shared Address
Book','A shared address
book','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"contact\"],\"object \
class\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone,
 lrs\"},\"cn\":[]}}'),(2,'calendar','Shared Calendar','A shared
calendar','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"event\"],\"obje \
ctclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone,
 lrs\"},\"cn\":[]}}'),(3,'journal','Shared Journal','A shared
journal','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"journal\"],\"obj \
ectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone,
 lrs\"},\"cn\":[]}}'),(4,'task','Shared Tasks','A shared tasks
folder','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"task\"],\"objectc \
lass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone,
 lrs\"},\"cn\":[]}}'),(5,'note','Shared Notes','A shared Notes
folder','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"note\"],\"objectc \
lass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone,
 lrs\"},\"cn\":[]}}'),(6,'file','Shared Files','A shared Files
folder','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"file\"],\"objectc \
lass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone,
 lrs\"},\"cn\":[]}}'),(7,'mail','Shared Mail Folder','A shared mail
folder','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"mail\"],\"objectc \
lass\":[\"top\",\"kolabsharedfolder\",\"mailrecipient\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone,
 lrs\"},\"cn\":[],\"alias\":{\"type\":\"list\",\"optional\":true},\"kolabdelegate\":{\ \
"type\":\"list\",\"autocomplete\":true,\"optional\":true},\"kolaballowsmtprecipient\": \
{\"type\":\"list\",\"optional\":true},\"kolaballowsmtpsender\":{\"type\":\"list\",\"optional\":true},\"kolabtargetfolder\":[],\"mail\":[]}}');
 /*!40000 ALTER TABLE `sharedfolder_types` ENABLE KEYS */;
UNLOCK TABLES;

so, currently unclear. 

2) Wallace doesn't love us. Somehow it would not start (been a while, so
shady on details)

3) iRony also doesn't accept logins

Any help appreciated!

Thanks!

/Bernhard

Links:
------
[1]
https://docs.kolab.org/administrator-guide/upgrading-from-kolab-3.1-to-3.3.html

[Attachment #5 (unknown)]

<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" \
/></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'> Hi \
guys we had a 3.0 installation that we upgraded to 3.3 using the upgrade \
notes.&nbsp;<a href="https://docs.kolab.org/administrator-guide/upgrading-from-kolab-3 \
.1-to-3.3.html">https://docs.kolab.org/administrator-guide/upgrading-from-kolab-3.1-to-3.3.html</a>
 But clearly some weird things happened.&nbsp;
1) All contacts are gone. When you type one that used to be there, you still see \
the name, but without email address. Creating one displays it while you are in that \
part of the address book. When you leave and return it is gone.&nbsp; we \
did&nbsp; <pre>DROP TABLE IF EXISTS `sharedfolder_types`; \
/*!40101 SET @saved_cs_client = @@character_set_client \
*/; /*!40101 SET character_set_client \
= utf8 */; CREATE TABLE `sharedfolder_types` ( \
`id` int(11) NOT NULL AUTO_INCREMENT, `key` text NOT NULL, `name` varchar(256) NOT NULL, `description` text \
NOT NULL, `attributes` longtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = \
@saved_cs_client */;

<span class="c1">--</span>
<span class="c1">-- Dumping data for table `sharedfolder_types`</span>
<span class="c1">--</span>

LOCK TABLES `sharedfolder_types` \
WRITE; /*!40000 ALTER \
TABLE `sharedfolder_types` DISABLE KEYS */; INSERT INTO `sharedfolder_types` VALUES (1,'addressbook','Shared Address Book','A \
shared address book','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"contact\"],\"o \
bjectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, \
lrs\"},\"cn\":[]}}'),(2,'calendar','Shared Calendar','A shared \
calendar','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"event\"],\"obj \
ectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, \
lrs\"},\"cn\":[]}}'),(3,'journal','Shared Journal','A shared \
journal','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"journal\"],\"o \
bjectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, \
lrs\"},\"cn\":[]}}'),(4,'task','Shared Tasks','A shared \
tasks folder','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"task\"],\"obje \
ctclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, \
lrs\"},\"cn\":[]}}'),(5,'note','Shared Notes','A shared \
Notes folder','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"note\"],\"obje \
ctclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, \
lrs\"},\"cn\":[]}}'),(6,'file','Shared Files','A shared \
Files folder','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"file\"],\"obje \
ctclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, \
lrs\"},\"cn\":[]}}'),(7,'mail','Shared Mail Folder','A \
shared mail folder','{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"mail\"],\"obje \
ctclass\":[\"top\",\"kolabsharedfolder\",\"mailrecipient\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, \
lrs\"},\"cn\":[],\"alias\":{\"type\":\"list\",\"optional\":true},\"kolabdelegate\":{\" \
type\":\"list\",\"autocomplete\":true,\"optional\":true},\"kolaballowsmtprecipient\":{ \
\"type\":\"list\",\"optional\":true},\"kolaballowsmtpsender\":{\"type\":\"list\",\"optional\":true},\"kolabtargetfolder\":[],\"mail\":[]}}'); /*!40000 ALTER TABLE `sharedfolder_types` ENABLE \
KEYS */; UNLOCK TABLES; so, currently unclear. 2) Wallace doesn't love us. Somehow it would not start (been a while, so \
shady on details) 3) iRony also doesn't accept logins Any help \
appreciated! Thanks! /Bernhard</pre> &nbsp;
</body></html>

_______________________________________________
users mailing list
users@lists.kolab.org
https://lists.kolab.org/mailman/listinfo/users

[prev in list] [next in list] [prev in thread] [next in thread] 