Re: [RCU] Lost Contacts Entries
On 4/8/19 2:42 pm, A.L.E.C wrote: Sounds like it might be this issue https://github.com/roundcube/roundcubemail/issues/6744 I have already patched the \r\n instead of \R line in rcube_vcard.php and that got rid of the regex errors but that did not help restoring the actual contacts entries. Maybe I have messed around with my production setup desperately trying to get the contacts back for users that were complaining. If I have to write off all contacts and start from scratch I'd rather risk installing rc2 and make sure I have a staging system to test updates first then push to production. I never bothered doing this for the current installation through sheer complacency because for the last few years it had been working fine... although I don't think I updated it at all. Now I really do want to chase the Elastic theme and decent contacts and calendar integration with (ideally) Nextcloud so I guess I will have to be more actively involved and pay more attention to the github repo. -- Mark Constable 0419 530 037 https://spiderweb.com.au ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Re: [RCU] Lost Contacts Entries
On 8/4/19 5:01 AM, Mark Constable wrote: > I finally got to a weekend to investigate this. There are 6000+ contacts, > 100+ contactgroups, 2000+ contactgroupmembers and some unknown number of > users actually using contacts. If the contacts entries are not visible > within the contactgroups and contactgroupmembers (in the web interface > itself) how do I determine which user_id column in the contacts table is > meant to be > matched to the user_id column in the users table? Sounds like it might be this issue https://github.com/roundcube/roundcubemail/issues/6744 I guess we have to release 1.3.10 soon. -- Aleksander 'A.L.E.C' Machniak Kolab Groupware Developer [http://kolab.org] Roundcube Webmail Developer [http://roundcube.net] PGP: 19359DC1 # Blog: https://kolabian.wordpress.com ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Re: [RCU] Lost Contacts Entries
On 2/8/19 5:00 am, Ulli Heist wrote: the contacs are connected to the users via table users column user_id table contacts column user_id I finally got to a weekend to investigate this. There are 6000+ contacts, 100+ contactgroups, 2000+ contactgroupmembers and some unknown number of users actually using contacts. If the contacts entries are not visible within the contactgroups and contactgroupmembers (in the web interface itself) how do I determine which user_id column in the contacts table is meant to be matched to the user_id column in the users table? How do I determine what to change the user_id field in the contacts table to when I don't know which user that particular contact belongs to now that the contact entries are all messed up? I suspect I will have to truncate the contact* tables and tell my already angry users to start all over again but I am concerned that the Roundcube Contacts plugin is so fragile that this may happen again with a another update... like to 1.4 with the much anticipated Elastic theme. Has anyone got any suggestion how to future proof Roundcube? Should I perhaps look at Roundcube provided by Kolab? My testing with Rainloop and it's contact and calendar plugins remotely connecting to with Nextcloud (mainly for backup) seemed to work well but Rainloops future development seems to be in doubt. -- Mark Constable 0419 530 037 https://spiderweb.com.au ___ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users