Skip to main content


Unwanted contact duplication


!Friendica Support

While browsing through my #Friendica database, I detected that I now have two identical contact records for myself. Initially, they were these records in table contact:
IdAccount
0System account
2my account

But now, something has changed to
IdAccount
0Zombie record
2my account
3my account (clone)
4System account

I have no clue, what has initiated this change, whether it is bad (I assume so) and how to cure it.

Any thoughts appreciated.
Please have a look for the content of the fields uid, self, network and url.
@Michael Vogel
+-----+------+---------+---------------------------------------------+
| uid | self | network | url                                         |
+-----+------+---------+---------------------------------------------+
|   0 |    0 |         |                                             |
|   2 |    1 | dfrn    | https://social.alfredbuehler.ch/profile/abu |
|   0 |    0 | dfrn    | https://social.alfredbuehler.ch/profile/abu |
|   0 |    1 | apub    | https://social.alfredbuehler.ch/friendica   |
+-----+------+---------+---------------------------------------------+
From what I can see here, every entry is like it is expected. So please don't delete any of them.
@Michael Vogel Wait, but what is the purpose of that clone record with uid 0?
Each user contact (uid != 0) has always an entry with uid = 0.
@Michael Vogel OK, thanks. I wasn't aware of this.

Any idea, what happened to the system account, leaving a zombie record?
That id = 0 account is there for technical reasons and is created intentionally.
@Michael Vogel Yes, I know that now. But what about the “migration” of the system account?
That entry is correct as well. Everything there is totally normal.