PROBLEMS WITH DATABSE - Can anyone tell me whats wrong?

Questions and Answers : Preferences : PROBLEMS WITH DATABSE - Can anyone tell me whats wrong?
Message board moderation

To post messages, you must log in.

AuthorMessage
Profile swherdman

Send message
Joined: 24 Jan 02
Posts: 12
Credit: 36,201
RAC: 0
Australia
Message 45858 - Posted: 12 Nov 2004, 14:28:57 UTC

Can an admin fix this or someone give me a way to solve this problem PLEASE

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

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 . "

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

Comment from species 8472

"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.
ID: 43874 / Score: 0 "
ID: 45858 · Report as offensive
Profile Doris and Jens
Volunteer developer
Volunteer tester
Avatar

Send message
Joined: 21 Nov 99
Posts: 362
Credit: 3,539,386
RAC: 13
Germany
Message 48503 - Posted: 21 Nov 2004, 22:00:43 UTC

Please look here.
Greetings from Bremen/Germany
Jens Seidler (TheBigJens)

ID: 48503 · Report as offensive

Questions and Answers : Preferences : PROBLEMS WITH DATABSE - Can anyone tell me whats wrong?


 
©2024 University of California
 
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.