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.

in reply to alfredb

Please have a look for the content of the fields uid, self, network and url.
in reply to Michael Vogel

@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   |
+-----+------+---------+---------------------------------------------+
in reply to alfredb

From what I can see here, every entry is like it is expected. So please don't delete any of them.
in reply to alfredb

Each user contact (uid != 0) has always an entry with uid = 0.
in reply to Michael Vogel

@Michael Vogel OK, thanks. I wasn't aware of this.

Any idea, what happened to the system account, leaving a zombie record?

in reply to alfredb

That id = 0 account is there for technical reasons and is created intentionally.
in reply to Michael Vogel

@Michael Vogel Yes, I know that now. But what about the “migration” of the system account?
in reply to alfredb

That entry is correct as well. Everything there is totally normal.