There are 3 members in my team :
https://boinc.bakerlab.org/rosetta/team_display.php?teamid=661
but on top of page, it's written :
Members (with AND without Credit) 2

Can anyone tell me why and how ?

---

I count 3 members ...


1) Toutouf 36,622.01 641.84 France
2) Becky 18,467.33 555.03 United States
3) TOOCOOL 37,988.41 548.58 United States

---

But stats say only 2 when giving numbers of members.

---

Foundere, member, member = 3 total

2 members ...

---

Mine says 14 and 14 so I do not think that is quite right?
Here

---

Mine says 14 and 14 so I do not think that is quite right?
Here

Though the founder IS in the list, there is nothing to prove that there is not a member that has zero credit and therefore is not in the list.

You would have to contact the founder to know for certain. If I recall correctly the founder hs the complete list of participants ...

So one count is of participants/members with credit, the other is with and without ....

---

...but his problem is that it shows LESS that the team total...if there was a member with zero credit you would get - 3 Members with and without credit, and the 'list' would show 2. His problem is the list shows 3 and the 'total' shows 2! (and that count does show the 'founder' as shown in my team pointed to above where I am the founder and included in the 14 total and 14 list.

You are correct in that as the founder I can show those 'hidden' members who have zero credit.....I removed a coiple the other day!

---

...but his problem is that it shows LESS that the team total...if there was a member with zero credit you would get - 3 Members with and without credit, and the 'list' would show 2. His problem is the list shows 3 and the 'total' shows 2! (and that count does show the 'founder' as shown in my team pointed to above where I am the founder and included in the 14 total and 14 list.

You are correct in that as the founder I can show those 'hidden' members who have zero credit.....I removed a coiple the other day!

something similar here for XPC:

Members (with AND without Credit) = 47
No listed with no credit = 3
No listed with credit (includes me - founder)= 45

there is one member in the list twice though - njolakoski is listed once with credit and once without, but I don't think that's the problem - it looks like a general bug.

---

Could that come from members who joined using the
"Create team account URL" shortcut ?

---

there is one member in the list twice though - njolakoski is listed once with credit and once without, but I don't think that's the problem - it looks like a general bug.

Possible ...

But, the number of Participants at the top is calculated as a count of the rows in the database table. So, not clear to me how that can be wrong. I grant you that the update should occur as a result of a trigger on the table, but the MySQL version most of the projects are using is 3 or 4 and triggers did not exist at that time.

---

Duplicate

---

there is one member in the list twice though - njolakoski is listed once with credit and once without, but I don't think that's the problem - it looks like a general bug.

Possible ...

But, the number of Participants at the top is calculated as a count of the rows in the database table. So, not clear to me how that can be wrong. I grant you that the update should occur as a result of a trigger on the table, but the MySQL version most of the projects are using is 3 or 4 and triggers did not exist at that time.

My knowledge of databases is limited to Access, but could it be that the count is based on a query that groups members by name, rather than directly on the table?

I guess that still wouldn't solve Toutouf's error though!

---

No, it is SELECT Count(*) from Team WHERE ...

---