ATTN: Take the apostrophe out of team names

Help
Rob J
2010-03-18
2013-03-27
  • Rob J
    Rob J
    2010-03-18

    There is a bug we are working to fix that causes all kinds of problems. Workaround is to just take the apostrophe out of St Mary's in the master bracket AND all user submitted brackets.

    Should be a simple SQL query for both. If someone has some time, please post the query to remove this apostrophe from both tables.

     
  • Rob J
    Rob J
    2010-03-18

    Also, it's smart to back up your database as soon as bracket submissions close.

     
  • J B
    J B
    2010-03-18

    also, take it out of the team names. causes issues there as well

     
  • John Holder
    John Holder
    2010-03-18

    jbove,
    St. Marys _is_ a team name.  that is what rob is asking you to do.

     
  • J B
    J B
    2010-03-18

    i understand that, i meant the bracket names the users pick - sorry for the confusion

     
  • sksource
    sksource
    2010-03-18

    I have  a couple of folks who have apostrophes in their bracket names and don't see any problems yet.  Is an apostrophe in bracket names bad news?

     
  • chanman
    chanman
    2010-03-18

    Yep it marks all St. Marys as 0 points. How would I fix this in sql without messing up the entire site?

     
  • sksource
    sksource
    2010-03-18

    @chanmanfan - not for me?  I have people with an apostrophe in the bracket name, who have picked "St. Marys" (no apostrophe in team names), and they got scored correctly.

     
  • BigDaddyNC
    BigDaddyNC
    2010-03-19

    update `brackets`
    set `1` = replace(`1`,"'","");

    do this for column names `1` … `63`

     
  • BigDaddyNC
    BigDaddyNC
    2010-03-19

    update `brackets` set `1` = replace(`1`,"'","");
    update `brackets` set `2` = replace(`2`,"'","");
    update `brackets` set `3` = replace(`3`,"'","");
    update `brackets` set `4` = replace(`4`,"'","");
    update `brackets` set `5` = replace(`5`,"'","");
    update `brackets` set `6` = replace(`6`,"'","");
    update `brackets` set `7` = replace(`7`,"'","");
    update `brackets` set `8` = replace(`8`,"'","");
    update `brackets` set `9` = replace(`9`,"'","");
    update `brackets` set `10` = replace(`10`,"'","");
    update `brackets` set `11` = replace(`11`,"'","");
    update `brackets` set `12` = replace(`12`,"'","");
    update `brackets` set `13` = replace(`13`,"'","");
    update `brackets` set `14` = replace(`14`,"'","");
    update `brackets` set `15` = replace(`15`,"'","");
    update `brackets` set `16` = replace(`16`,"'","");
    update `brackets` set `17` = replace(`17`,"'","");
    update `brackets` set `18` = replace(`18`,"'","");
    update `brackets` set `19` = replace(`19`,"'","");
    update `brackets` set `20` = replace(`20`,"'","");
    update `brackets` set `21` = replace(`21`,"'","");
    update `brackets` set `22` = replace(`22`,"'","");
    update `brackets` set `23` = replace(`23`,"'","");
    update `brackets` set `24` = replace(`24`,"'","");
    update `brackets` set `25` = replace(`25`,"'","");
    update `brackets` set `26` = replace(`26`,"'","");
    update `brackets` set `27` = replace(`27`,"'","");
    update `brackets` set `28` = replace(`28`,"'","");
    update `brackets` set `29` = replace(`29`,"'","");
    update `brackets` set `30` = replace(`30`,"'","");
    update `brackets` set `31` = replace(`31`,"'","");
    update `brackets` set `32` = replace(`32`,"'","");
    update `brackets` set `33` = replace(`33`,"'","");
    update `brackets` set `34` = replace(`34`,"'","");
    update `brackets` set `35` = replace(`35`,"'","");
    update `brackets` set `36` = replace(`36`,"'","");
    update `brackets` set `37` = replace(`37`,"'","");
    update `brackets` set `38` = replace(`38`,"'","");
    update `brackets` set `39` = replace(`39`,"'","");
    update `brackets` set `40` = replace(`40`,"'","");
    update `brackets` set `41` = replace(`41`,"'","");
    update `brackets` set `42` = replace(`42`,"'","");
    update `brackets` set `43` = replace(`43`,"'","");
    update `brackets` set `44` = replace(`44`,"'","");
    update `brackets` set `45` = replace(`45`,"'","");
    update `brackets` set `46` = replace(`46`,"'","");
    update `brackets` set `47` = replace(`47`,"'","");
    update `brackets` set `48` = replace(`48`,"'","");
    update `brackets` set `49` = replace(`49`,"'","");
    update `brackets` set `50` = replace(`50`,"'","");
    update `brackets` set `51` = replace(`51`,"'","");
    update `brackets` set `52` = replace(`52`,"'","");
    update `brackets` set `53` = replace(`53`,"'","");
    update `brackets` set `54` = replace(`54`,"'","");
    update `brackets` set `55` = replace(`55`,"'","");
    update `brackets` set `56` = replace(`56`,"'","");
    update `brackets` set `57` = replace(`57`,"'","");
    update `brackets` set `58` = replace(`58`,"'","");
    update `brackets` set `59` = replace(`59`,"'","");
    update `brackets` set `60` = replace(`60`,"'","");
    update `brackets` set `61` = replace(`61`,"'","");
    update `brackets` set `62` = replace(`62`,"'","");
    update `brackets` set `63` = replace(`63`,"'","");

     
  • BigDaddyNC
    BigDaddyNC
    2010-03-19

    also, for the master bracket

    update `master` set `1` = replace(`1`,"'","");
    update `master` set `2` = replace(`2`,"'","");
    update `master` set `3` = replace(`3`,"'","");
    update `master` set `4` = replace(`4`,"'","");
    update `master` set `5` = replace(`5`,"'","");
    update `master` set `6` = replace(`6`,"'","");
    update `master` set `7` = replace(`7`,"'","");
    update `master` set `8` = replace(`8`,"'","");
    update `master` set `9` = replace(`9`,"'","");
    update `master` set `10` = replace(`10`,"'","");
    update `master` set `11` = replace(`11`,"'","");
    update `master` set `12` = replace(`12`,"'","");
    update `master` set `13` = replace(`13`,"'","");
    update `master` set `14` = replace(`14`,"'","");
    update `master` set `15` = replace(`15`,"'","");
    update `master` set `16` = replace(`16`,"'","");
    update `master` set `17` = replace(`17`,"'","");
    update `master` set `18` = replace(`18`,"'","");
    update `master` set `19` = replace(`19`,"'","");
    update `master` set `20` = replace(`20`,"'","");
    update `master` set `21` = replace(`21`,"'","");
    update `master` set `22` = replace(`22`,"'","");
    update `master` set `23` = replace(`23`,"'","");
    update `master` set `24` = replace(`24`,"'","");
    update `master` set `25` = replace(`25`,"'","");
    update `master` set `26` = replace(`26`,"'","");
    update `master` set `27` = replace(`27`,"'","");
    update `master` set `28` = replace(`28`,"'","");
    update `master` set `29` = replace(`29`,"'","");
    update `master` set `30` = replace(`30`,"'","");
    update `master` set `31` = replace(`31`,"'","");
    update `master` set `32` = replace(`32`,"'","");
    update `master` set `33` = replace(`33`,"'","");
    update `master` set `34` = replace(`34`,"'","");
    update `master` set `35` = replace(`35`,"'","");
    update `master` set `36` = replace(`36`,"'","");
    update `master` set `37` = replace(`37`,"'","");
    update `master` set `38` = replace(`38`,"'","");
    update `master` set `39` = replace(`39`,"'","");
    update `master` set `40` = replace(`40`,"'","");
    update `master` set `41` = replace(`41`,"'","");
    update `master` set `42` = replace(`42`,"'","");
    update `master` set `43` = replace(`43`,"'","");
    update `master` set `44` = replace(`44`,"'","");
    update `master` set `45` = replace(`45`,"'","");
    update `master` set `46` = replace(`46`,"'","");
    update `master` set `47` = replace(`47`,"'","");
    update `master` set `48` = replace(`48`,"'","");
    update `master` set `49` = replace(`49`,"'","");
    update `master` set `50` = replace(`50`,"'","");
    update `master` set `51` = replace(`51`,"'","");
    update `master` set `52` = replace(`52`,"'","");
    update `master` set `53` = replace(`53`,"'","");
    update `master` set `54` = replace(`54`,"'","");
    update `master` set `55` = replace(`55`,"'","");
    update `master` set `56` = replace(`56`,"'","");
    update `master` set `57` = replace(`57`,"'","");
    update `master` set `58` = replace(`58`,"'","");
    update `master` set `59` = replace(`59`,"'","");
    update `master` set `60` = replace(`60`,"'","");
    update `master` set `61` = replace(`61`,"'","");
    update `master` set `62` = replace(`62`,"'","");
    update `master` set `63` = replace(`63`,"'","");
    update `master` set `64` = replace(`64`,"'","");

     
  • Rob J
    Rob J
    2010-03-19

    And as always, backup your database

     
  • chanman
    chanman
    2010-03-19

    Still not getting that matchup scored. I have removed the apostrophe using the sql statements but still getting the same end results. It works if I change it to Richmond but putting it back to St Marys it marks everyone wrong. Major bug.

     
  • Rob J
    Rob J
    2010-03-19

    Does the name in the master bracket match the name in the bracket entries, exactly?

    Did you resubmit the master bracket to get it to re score?

     
  • chanman
    chanman
    2010-03-19

    Looks like that could be the issue. That query made the brackets with St Marys listed as this : "St Mary\s"

    But the master has it as this after running that: "St Marys"

     
  • Don Can Help
    Don Can Help
    2010-03-20

    Also Fails with Bracket Names!!!

     
  • Botag
    Botag
    2010-03-20

    I haven't encountered any problems with apostrophes in bracket names. There are a few instances still where the stripslashes function needs to be used, but I think we've corrected most of them. My site has half a dozen brackets with apostrophes and I haven't yet encountered any problems.

     
  • cnyballer
    cnyballer
    2011-03-17

    This reared its ugly head in my bracket scoring again. 

     
  • John Holder
    John Holder
    2011-03-17

    Please be specific - I've not seen an issue with it yet, and I have a few brackets with apostrophes (including my own).

     
  • cnyballer
    cnyballer
    2011-03-17

    I was a bit vague huh. 
    Wish I wrote down the error now but basically when I edited master bracket I got an error about "near 's " which was part of a bracket's name. 
    I went into my brackets and removed any apostrophe's for now.

    What is even more strange is my test site/database with I believe the same php files I can't duplicate the error.