1) Message boards : Number crunching : Problem with the teams sql table(s) Cant Quit/Join team + No managemnt functions (Message 48646) Posted 22 Nov 2004 by swherdman Post: Thanks so much i was just about to snap. this was my last resort thanks it looks like its fixed. Now to go and recreate my team!

2) Message boards : Number crunching : Problem with the teams sql table(s) Cant Quit/Join team + No managemnt functions (Message 48318) Posted 21 Nov 2004 by swherdman Post: i have posted this so many times now and no one has any idear of what to do. I was suguest that i post it here The other 7 posts i have made reguarding this problem but no one has any idear what to do http://setiweb.ssl.berkeley.edu/forum_thread.php?id=6783 http://setiweb.ssl.berkeley.edu/forum_thread.php?id=6344 http://setiweb.ssl.berkeley.edu/forum_thread.php?id=6545 http://setiweb.ssl.berkeley.edu/forum_thread.php?id=6502 http://setiweb.ssl.berkeley.edu/forum_thread.php?id=6344 http://setiweb.ssl.berkeley.edu/forum_thread.php?id=6341 http://setiweb.ssl.berkeley.edu/forum_thread.php?id=6261 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 "

3) Questions and Answers : Getting started : THE SETI SQL TABLES ARE FUKED AND NO ADMIN WANTS TO HERE A FUKING THING ABOUT IT WILL ONE OF YOU FUKING FIX IT! (Message 48317) Posted 21 Nov 2004 by swherdman Post: > The Brainiacs are over in number crunching Please post there and help > generally comes in droves. I wouldn/t use this heading though... > > Keep a cool head... > > > Timmy > i have posted this 9 times i am starting to get anoyed

4) Questions and Answers : Getting started : THE SETI SQL TABLES ARE FUKED AND NO ADMIN WANTS TO HERE A FUKING THING ABOUT IT WILL ONE OF YOU FUKING FIX IT! (Message 48117) Posted 20 Nov 2004 by swherdman Post: I have posted this 8 times now and i havent herd a responce from any admin. i cant do any thing with my team at all the stats dont update ... oh im not typing it for the 9th time heres one of it bits i have written over the last month in a vain effort to get this problem FUKING fixed. I am sorry it has come to this but there is nowhere i have found that people cawn submit bugs like this NOTHING and im getting FUKING FED UP! ALL I WANT IS THE PROGRAM TO WORK IT WILL TAKE 1 LINE OF SQL CODE TO RESET MY TEAM. COME ON THIS IS GETTING FUKING STUPID 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. >

5) Questions and Answers : Getting started : MAJOR PROBLEMS WITH TEAM ON WEBSITE - MAJOR BUG - URGENT! (Message 46994) Posted 16 Nov 2004 by swherdman Post: 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. >

6) Questions and Answers : Preferences : PROBLEMS WITH DATABSE - Can anyone tell me whats wrong? (Message 45858) Posted 12 Nov 2004 by swherdman Post: 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 "

7) Questions and Answers : Getting started : URGENT PROBLEM WITH TEAMS - CAN AN ADMIN FIX THIS (Message 45510) Posted 11 Nov 2004 by swherdman Post: 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 " Orignal Post http://setiweb.ssl.berkeley.edu/forum_thread.php?id=6344

8) Questions and Answers : Getting started : MAJOR PROBLEMS WITH TEAM ON WEBSITE - MAJOR BUG - URGENT! (Message 44252) Posted 8 Nov 2004 by swherdman Post: 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. >

9) Questions and Answers : Getting started : MAJOR PROBLEMS WITH TEAM ON WEBSITE - MAJOR BUG - URGENT! (Message 44251) Posted 8 Nov 2004 by swherdman Post: 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. >

10) Questions and Answers : Getting started : MAJOR PROBLEMS WITH TEAM ON WEBSITE - MAJOR BUG - URGENT! (Message 43861) Posted 7 Nov 2004 by swherdman Post: 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

11) Message boards : Number crunching : Problem WIth Teams on website - Who should i sent it to? (Message 43768) Posted 7 Nov 2004 by swherdman Post: 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. Who sould i send this to/tell?

12) Questions and Answers : Windows : Management funcytions gone (Message 42735) Posted 4 Nov 2004 by swherdman Post: 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. Whats going on?

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