Hi Mark,
the contacs are connected to the users via table users column user_id table contacts column user_id
If you try to change the user_id within the contacts table - you also have to change the user_id (table contactgroups)
Best regards
Ulli
-----Original Message----- From: users-bounces@lists.roundcube.net [mailto:users-bounces@lists.roundcube.net] On Behalf Of Mark Constable Sent: Wednesday, July 31, 2019 6:04 AM To: users@lists.roundcube.net Subject: [RCU] Lost Contacts Entries
Hi, I'm using 1.3.9 and recently switched my backend mailserver from an old server to a new server BUT the $config['default_host'] = 'ssl://mymail.server' setting remained exactly the same, only the IP for mymail.server was changed. I'd been caught out a few years ago when I changed default_host to a different IP and learnt the hard way and that doubled up with new user entries with the new IP and I think I sorted that out. This time the default_host setting is exactly the same. I did find a post that mentioned to run the bin/indexcontacts.sh script, which I did, and now the Contact labels and groups seem to be there but the actual contact content (name, email address etc) is missing. That contact content info looks like it's still in the database (obviously, I did not change or reinstall roundcube itself) but something to do with the id indexes for the contact content is not matching up with the addressbook entries.
Any hint how I fix this or or patch it up manually if I have to?
(I posted this in the forum before I found this mailing-list)