<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'>
<p>Hi guys</p>
<p>we had a 3.0 installation that we upgraded to 3.3 using the upgrade notes. <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></p>
<p>But clearly some weird things happened. </p>
<p>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. </p>
<p>we did </p>
<pre><span class="k">DROP</span> <span class="k">TABLE</span> <span class="n">IF</span> <span class="k">EXISTS</span> <span class="o">`</span><span class="n">sharedfolder_types</span><span class="o">`</span><span class="p">;</span>
<span class="cm">/*!40101 SET @saved_cs_client = @@character_set_client */</span><span class="p">;</span>
<span class="cm">/*!40101 SET character_set_client = utf8 */</span><span class="p">;</span>
<span class="k">CREATE</span> <span class="k">TABLE</span> <span class="o">`</span><span class="n">sharedfolder_types</span><span class="o">`</span> <span class="p">(</span>
<span class="o">`</span><span class="n">id</span><span class="o">`</span> <span class="nb">int</span><span class="p">(</span><span class="mi">11</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span> <span class="n">AUTO_INCREMENT</span><span class="p">,</span>
<span class="o">`</span><span class="k">key</span><span class="o">`</span> <span class="nb">text</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
<span class="o">`</span><span class="n">name</span><span class="o">`</span> <span class="nb">varchar</span><span class="p">(</span><span class="mi">256</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
<span class="o">`</span><span class="n">description</span><span class="o">`</span> <span class="nb">text</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
<span class="o">`</span><span class="n">attributes</span><span class="o">`</span> <span class="n">longtext</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
<span class="k">PRIMARY</span> <span class="k">KEY</span> <span class="p">(</span><span class="o">`</span><span class="n">id</span><span class="o">`</span><span class="p">),</span>
<span class="k">UNIQUE</span> <span class="k">KEY</span> <span class="o">`</span><span class="n">name</span><span class="o">`</span> <span class="p">(</span><span class="o">`</span><span class="n">name</span><span class="o">`</span><span class="p">)</span>
<span class="p">)</span> <span class="n">ENGINE</span><span class="o">=</span><span class="n">InnoDB</span> <span class="n">AUTO_INCREMENT</span><span class="o">=</span><span class="mi">8</span> <span class="k">DEFAULT</span> <span class="n">CHARSET</span><span class="o">=</span><span class="n">latin1</span><span class="p">;</span>
<span class="cm">/*!40101 SET character_set_client = @saved_cs_client */</span><span class="p">;</span>
<span class="c1">--</span>
<span class="c1">-- Dumping data for table `sharedfolder_types`</span>
<span class="c1">--</span>
<span class="k">LOCK</span> <span class="n">TABLES</span> <span class="o">`</span><span class="n">sharedfolder_types</span><span class="o">`</span> <span class="k">WRITE</span><span class="p">;</span>
<span class="cm">/*!40000 ALTER TABLE `sharedfolder_types` DISABLE KEYS */</span><span class="p">;</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="o">`</span><span class="n">sharedfolder_types</span><span class="o">`</span> <span class="k">VALUES</span> <span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="s1">'addressbook'</span><span class="p">,</span><span class="s1">'Shared Address Book'</span><span class="p">,</span><span class="s1">'A shared address book'</span><span class="p">,</span><span class="s1">'{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"contact\"],\"objectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, lrs\"},\"cn\":[]}}'</span><span class="p">),(</span><span class="mi">2</span><span class="p">,</span><span class="s1">'calendar'</span><span class="p">,</span><span class="s1">'Shared Calendar'</span><span class="p">,</span><span class="s1">'A shared calendar'</span><span class="p">,</span><span class="s1">'{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"event\"],\"objectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, lrs\"},\"cn\":[]}}'</span><span class="p">),(</span><span class="mi">3</span><span class="p">,</span><span class="s1">'journal'</span><span class="p">,</span><span class="s1">'Shared Journal'</span><span class="p">,</span><span class="s1">'A shared journal'</span><span class="p">,</span><span class="s1">'{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"journal\"],\"objectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, lrs\"},\"cn\":[]}}'</span><span class="p">),(</span><span class="mi">4</span><span class="p">,</span><span class="s1">'task'</span><span class="p">,</span><span class="s1">'Shared Tasks'</span><span class="p">,</span><span class="s1">'A shared tasks folder'</span><span class="p">,</span><span class="s1">'{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"task\"],\"objectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, lrs\"},\"cn\":[]}}'</span><span class="p">),(</span><span class="mi">5</span><span class="p">,</span><span class="s1">'note'</span><span class="p">,</span><span class="s1">'Shared Notes'</span><span class="p">,</span><span class="s1">'A shared Notes folder'</span><span class="p">,</span><span class="s1">'{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"note\"],\"objectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, lrs\"},\"cn\":[]}}'</span><span class="p">),(</span><span class="mi">6</span><span class="p">,</span><span class="s1">'file'</span><span class="p">,</span><span class="s1">'Shared Files'</span><span class="p">,</span><span class="s1">'A shared Files folder'</span><span class="p">,</span><span class="s1">'{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"file\"],\"objectclass\":[\"top\",\"kolabsharedfolder\"]},\"form_fields\":{\"acl\":{\"type\":\"imap_acl\",\"optional\":true,\"default\":\"anyone, lrs\"},\"cn\":[]}}'</span><span class="p">),(</span><span class="mi">7</span><span class="p">,</span><span class="s1">'mail'</span><span class="p">,</span><span class="s1">'Shared Mail Folder'</span><span class="p">,</span><span class="s1">'A shared mail folder'</span><span class="p">,</span><span class="s1">'{\"auto_form_fields\":[],\"fields\":{\"kolabfoldertype\":[\"mail\"],\"objectclass\":[\"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\":[]}}'</span><span class="p">);</span>
<span class="cm">/*!40000 ALTER TABLE `sharedfolder_types` ENABLE KEYS */</span><span class="p">;</span>
<span class="n">UNLOCK</span> <span class="n">TABLES</span><span class="p">;<br /><br /></span>so, currently unclear. <br /><br />2) Wallace doesn't love us. Somehow it would not start (been a while, so shady on details)<br /><br />3) iRony also doesn't accept logins<br /><br />Any help appreciated!<br /><br />Thanks!<br /><br />/Bernhard</pre>
<p> </p>
</body></html>