I was wondering why I have duplicate entries in my profile views and I suspect that's because the profile table is quite messed up (see attached screenshot).
At the moment I have 2 profile types: 2_espace_abonne and 3_film
All the 1_annuaire / 1_main / main are old profiles I deleted. But they are still referenced to users in this table. Even because I once modified 2_espace_abonne machine name and renamed it again with the same name, I now have a user (id 69) with is referenced twice to the same Profile type.

So I backed up my database and deleted the rows I don't need to clean up things manually and renumbered sequentially the pids. It worked , my view has no duplicates now.

CommentFileSizeAuthor
Capture d’écran 2011-04-22 à 20.41.16.png75.51 KBJerome F

Comments

Jerome F’s picture

Jerome F commented

Something else seems strange, one of my users Uid: 68 is just missing in this table, and I really wonder who are users 26 and 62 ! They just don't exist in the users table - so perhaps some test users I once deleted, but I'm not sure. Once again I corrected that manually in phpMyAdmin

Jerome F’s picture

Jerome F commented
Status: Active » Closed (duplicate)

I guess this is a duplicate of http://drupal.org/node/1065860