This is a two-fer;
The decks with apostrophes ( ' ) still cause sql errors when you try to add them to your deck.
2nd the character breaks aren't working properly for apostrophes or quotes ( ' , " )
You probably dont need to break the quotes " because you aren't using them in your sql to define literals. ( I added two decks with quote marks with no issues, but the break character still appears on those too)
I've also found that the Accesnt or Backtick ( ` ) (found to the left of the 1 key on your keyboard is not interpreted as any kind of literal and causes no issues (it's not an apostrophe, but is a decent enough work around for now - see pic)
CLOSED: Apostrophes!
Moderator: Playing Card DB Mod
- montecarlojoe
- Moderator
- Posts: 2529
- Joined: Mon Jun 24, 2013 7:10 am
- Collector: Yes
- Player: Yes
- White Whale: Avant Guard UL Gr - No17 Crown
- Decks Owned: 690
- Location: Portsmouth, England
- Has thanked: 253 times
- Been thanked: 268 times
- Contact:
-
- Member
- Posts: 157
- Joined: Thu Nov 22, 2012 12:52 pm
- Has thanked: 11 times
- Been thanked: 44 times
Re: Apostrophes!
Thanks!
I couldn't actually reproduce this, but I'm guessing you changed the names of the decks that had the issue which fixed the problem anyway.
I'm slowly fixing the display issues with the backslashes
EDIT: Also, please do let me know if this happens again!
I couldn't actually reproduce this, but I'm guessing you changed the names of the decks that had the issue which fixed the problem anyway.
I'm slowly fixing the display issues with the backslashes
EDIT: Also, please do let me know if this happens again!
PlayingCardDB - we bag and tag playing cards
- montecarlojoe
- Moderator
- Posts: 2529
- Joined: Mon Jun 24, 2013 7:10 am
- Collector: Yes
- Player: Yes
- White Whale: Avant Guard UL Gr - No17 Crown
- Decks Owned: 690
- Location: Portsmouth, England
- Has thanked: 253 times
- Been thanked: 268 times
- Contact:
Re: Apostrophes!
Search for guinness
Also - weird thing, if you search for Fulton the search results display the old name with the /' in
Also - weird thing, if you search for Fulton the search results display the old name with the /' in
- ecNate
- Member
- Posts: 2099
- Joined: Sat Mar 01, 2014 1:46 am
- Collector: Yes
- Player: Yes
- Decks Owned: 400
- Location: Wisconsin
- Has thanked: 420 times
- Been thanked: 440 times
- Contact:
Re: Apostrophes!
A related issue - it allows you to upload images with apostrophe's and displays them fine, but I notice that if you try and select one of those to use as the thumbnail deck then the image is broken in listings.
Here's an example and I kept both versions of the same image, just a name change to make it work.
http://playingcarddb.com/dbdeck?id=972
Here's an example and I kept both versions of the same image, just a name change to make it work.
http://playingcarddb.com/dbdeck?id=972
My card collection ('in hand' only) on Portfolio52 (the playing card database)
My wishlist, contact me if you have one to sell, let's chat! (My marketplace review thread)
My card collection thread here at UC
♠️ ♦️ My currently featured deck from my collection at Portfolio 52: Vanity Fair No 41 ♥️ ♣️
As a UC member you are encouraged to contribute/join Portfolio52, the greatest card collection site (FacebookPage)!
My wishlist, contact me if you have one to sell, let's chat! (My marketplace review thread)
My card collection thread here at UC
♠️ ♦️ My currently featured deck from my collection at Portfolio 52: Vanity Fair No 41 ♥️ ♣️
As a UC member you are encouraged to contribute/join Portfolio52, the greatest card collection site (FacebookPage)!
-
- Member
- Posts: 157
- Joined: Thu Nov 22, 2012 12:52 pm
- Has thanked: 11 times
- Been thanked: 44 times
Re: Apostrophes!
Fixed (:montecarlojoe wrote:Search for guinness
Also - weird thing, if you search for Fulton the search results display the old name with the /' in
PlayingCardDB - we bag and tag playing cards
Who is online
Users browsing this forum: No registered users and 1 guest