I tryed to remove a member from my team "Modcity" (http://setiweb.ssl.berkeley.edu/team_display.php?teamid=113811) because the person dident fully understand the system and had created 2 accounts to use on to PC's So i attempted to remove a user. I attempted to use the remove inactive member function and checked to box next to the offending account.

Next to my horror i got a message saying that the team was disbanded because of there were no members or something when there should still have been 4 other members. To my horror when i went to go to the team page it gave me an error saying the team did not exist or something then i refeshed it about 15 secons lator and the team was stil there the offending account still there aswell but in my profile i lost all the management features and only have the option to quit the team nothing more.

The team doent show up on search but doesnt show up but if i link directaly its there but none of the stats have been updated sice the incident and i cant quit from the team

---

Someone must have fixed it, your team is back.

But there's still not everything correct with the database, it says :

"Members 1"

but shows 5 users.

Maybe a database reorg would be needed where the nusers field in the teams database is evaluated with a count(*) instead of calculating web input up and down.

There's more wrong in the database - there are user entries with a user->teamid of a team that does not exist. It generates :

"team_display.php?teamid=" instead of
"team_display.php?teamid=113811" or
"None"

but it still lists the users on the team page - maybe from some caching mechanism?


This is a situation that should not encounter at all, the referential integrity is somehow broken.

Nothings Changed. The teams shows up yes. but the stats are old and i cant even quit from the team let alone view the management functions. The ability to view the team plage flucuates between showing me what is there now and telling me the team doesnt exist

> Someone must have fixed it, your team is back.
>
> But there's still not everything correct with the database, it says :
>
> "Members 1"
>
> but shows 5 users.
>
> Maybe a database reorg would be needed where the nusers field in the teams
> database is evaluated with a count(*) instead of calculating web input up and
> down.
>

---

When i try and create a new team " You already belong to a team. You must quit your current team before creating a new one. "

When i try and quit my current team " swherdman is not a member of . "


> Someone must have fixed it, your team is back.
>
> But there's still not everything correct with the database, it says :
>
> "Members 1"
>
> but shows 5 users.
>
> Maybe a database reorg would be needed where the nusers field in the teams
> database is evaluated with a count(*) instead of calculating web input up and
> down.
>

---

> When i try and create a new team " You already belong to a team. You must quit
> your current team before creating a new one. "
>
> When i try and quit my current team " swherdman is not a member of . "
>
>
> > Someone must have fixed it, your team is back.
> >
> > But there's still not everything correct with the database, it says :
> >
> > "Members 1"
> >
> > but shows 5 users.
> >
> > Maybe a database reorg would be needed where the nusers field in the
> teams
> > database is evaluated with a count(*) instead of calculating web input up
> and
> > down.



On your user profile page it shows "team=" with nothing behind it - that should not be possible and means you do have a team ID but lookup_team() with that number fails. Something definitely is broken.

It does not find the team with the "search" function either although it definitely exists.

I checked some numbers that are not in the XML export :

http://setiweb.ssl.berkeley.edu/team_display.php?teamid=145 (8 members, none show)

http://setiweb.ssl.berkeley.edu/team_display.php?teamid=146 (16 members, none show)

http://setiweb.ssl.berkeley.edu/team_display.php?teamid=150 (1 member, none show)

http://setiweb.ssl.berkeley.edu/team_display.php?teamid=158 (11 members, none show)

From how I understand the PHP functions, there should not be any team numbers missing with a user count nusers > 0 in the team table as it is "auto increment" so I guess, all missing numbers stand for a team with inconsistent data.

Does any one know a way we can directley report this to an admin to atleat delete teh offending rows from the sql or whatever db there using so i can atleat quit or make a new team

> > When i try and create a new team " You already belong to a team. You must
> quit
> > your current team before creating a new one. "
> >
> > When i try and quit my current team " swherdman is not a member of . "
> >
> >
> > > Someone must have fixed it, your team is back.
> > >
> > > But there's still not everything correct with the database, it says
> :
> > >
> > > "Members 1"
> > >
> > > but shows 5 users.
> > >
> > > Maybe a database reorg would be needed where the nusers field in
> the
> > teams
> > > database is evaluated with a count(*) instead of calculating web
> input up
> > and
> > > down.
>
>
>
> On your user profile page it shows "team=" with nothing behind it - that
> should not be possible and means you do have a team ID but lookup_team() with
> that number fails. Something definitely is broken.
>
> It does not find the team with the "search" function either although it
> definitely exists.
>
> I checked some numbers that are not in the XML export :
>
> http://setiweb.ssl.berkeley.edu/team_display.php?teamid=145 (8 members, none
> show)
>
> http://setiweb.ssl.berkeley.edu/team_display.php?teamid=146 (16 members, none
> show)
>
> http://setiweb.ssl.berkeley.edu/team_display.php?teamid=150 (1 member, none
> show)
>
> http://setiweb.ssl.berkeley.edu/team_display.php?teamid=158 (11 members, none
> show)
>
> From how I understand the PHP functions, there should not be any team numbers
> missing with a user count nusers > 0 in the team table as it is "auto
> increment" so I guess, all missing numbers stand for a team with inconsistent
> data.
>

---

Please look here.

---

Greetings from Bremen/Germany
Jens Seidler (TheBigJens)