Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: markc on July 30, 2019, 12:03:22 AM

Title: Lost Contacts Entries
Post by: markc on July 30, 2019, 12:03:22 AM
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?

Update: I just tried this one too...

~ php bin/updatedb.sh --dir ../SQL --package mysql
Updating database schema (2013011000)... [OK]
Updating database schema (2013042700)... [OK]
Updating database schema (2013052500)... [FAILED]
Error 500: Error in DDL upgrade 2013052500: [1050] Table 'cache_shared' already exists
Title: Re: Lost Contacts Entries
Post by: JohnDoh on July 30, 2019, 07:56:38 AM
what version of php are you running?
Title: Re: Lost Contacts Entries
Post by: markc on July 30, 2019, 11:59:42 PM
Thanks for the reply @JohnDoh. I am using PHP 7.3.7-1+ubuntu19.04
Title: Re: Lost Contacts Entries
Post by: JohnDoh on July 31, 2019, 03:07:43 AM
may be its the same issue as this? https://github.com/roundcube/roundcubemail/issues/6744
Title: Re: Lost Contacts Entries
Post by: markc on July 31, 2019, 11:07:03 PM
Thanks JonDoh, that was pretty close and I patched the file referred to and that got rid of the regex compilation error. However I still have no Contacts content for each entry. I tried the bin/updatecontact.sh again and found a similar error and patched that one too and the next I ran the script it did not have any errors. Running bin/updatedb.sh complains so maybe my database is out of whack because it's been around for a good few years now. Any more hints greatly appreciated.

~ php bin/updatedb.sh --dir ../SQL --package mysql
Updating database schema (2013061000)... [FAILED]
Error 500: Error in DDL upgrade 2013061000: [1060] Duplicate column name 'expires'
Title: Re: Lost Contacts Entries
Post by: alec on August 01, 2019, 12:30:46 AM
`--package mysql` is wrong, it should be `--package roundcube`.