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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
@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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
Also, it's smart to back up your database as soon as bracket submissions close.
also, take it out of the team names. causes issues there as well
jbove,
St. Marys _is_ a team name. that is what rob is asking you to do.
i understand that, i meant the bracket names the users pick - sorry for the confusion
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?
Yep it marks all St. Marys as 0 points. How would I fix this in sql without messing up the entire site?
@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.
update `brackets`
set `1` = replace(`1`,"'","");
…
do this for column names `1` … `63`
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`,"'","");
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`,"'","");
And as always, backup your database
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.
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?
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"
Also Fails with Bracket Names!!!
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.
This reared its ugly head in my bracket scoring again.
Please be specific - I've not seen an issue with it yet, and I have a few brackets with apostrophes (including my own).
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.