Hydev

# Fix Android “bug” with UIDs/URIs on CardDav contacts

## Overview

I recently experienced a strange bug on Android 5.1, when trying to sync my owncloud contacts through DAVDroid. Only some of my contacts would get sync-ed… I finally figured it was because of the domain being included in the UIDs (or URIs) of the vCard in the DB. Example: `01234567-89ab-cdef-0123-456789abcdef@MY_OC_DOMAIN`. Manually changing the ID to `01234567-89ab-cdef-0123-456789abcdef` in the database would fix it.

I made a quick PHP script to update my DB.

## Fix

<note warning>Disclaimer: Although it worked fine for me, I can't be held responsible if it destroys your contact list…</note>

<pre><?php
define('__offStr','@YOUR_DOMAIN');;
mysql_connect('localhost','SQL_USER','SQL_PWD');
mysql_select_db('OC_DATABASE');
 
$rq = 'select id, carddata, uri from oc_contacts_cards';
$rx = mysql_query($rq) or die(mysql_error());
$t = mysql_num_rows($rx);
$n = 0;
while($rs = mysql_fetch_object($rx))
{
        #var_dump($rs);
        $a = !empty($rs->uri) && strpos($rs->uri,__offStr);
        $b = !empty($rs->carddata) && strpos($rs->carddata,__offStr);
        if($a || $b) 
        {
                $r = 'update oc_contacts_cards set';
                if($a)  
                        $r .= ' uri=\''.mysql_real_escape_string(str_replace(__offStr,'',$rs->uri)).'\',';
                if($b)
                        $r .= ' carddata=\''.mysql_real_escape_string(str_replace(__offStr,'',$rs->carddata)).'\',';
                $r .= ' id='.$rs->id.' where id='.$rs->id;      
                $rq = mysql_query($r) or die(mysql_error());
                #var_dump($rs->id);
                #var_dump($n_cd);
                #var_dump($n_uri);
                #var_dump($r);
                #echo '<hr />';
                $n++;
        }
}       
var_dump('Updated '.$n.' of '.$t.' contacts');
?>