Author Topic: Lost Contacts Entries  (Read 662 times)

Offline markc

  • Newbie
  • *
  • Posts: 6
Lost Contacts Entries
« 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
« Last Edit: July 30, 2019, 02:03:44 AM by markc »

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,328
Re: Lost Contacts Entries
« Reply #1 on: July 30, 2019, 07:56:38 AM »
what version of php are you running?
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more…

Offline markc

  • Newbie
  • *
  • Posts: 6
Re: Lost Contacts Entries
« Reply #2 on: July 30, 2019, 11:59:42 PM »
Thanks for the reply @JohnDoh. I am using PHP 7.3.7-1+ubuntu19.04

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,328
Re: Lost Contacts Entries
« Reply #3 on: July 31, 2019, 03:07:43 AM »
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more…

Offline markc

  • Newbie
  • *
  • Posts: 6
Re: Lost Contacts Entries
« Reply #4 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'

Offline alec

  • Hero Member
  • *****
  • Posts: 1,165
Re: Lost Contacts Entries
« Reply #5 on: August 01, 2019, 12:30:46 AM »
`--package mysql` is wrong, it should be `--package roundcube`.