CLOSED: Apostrophes!

Having Trouble using the Playing Card Database? Post it here!

Moderator: Playing Card DB Mod

User avatar
montecarlojoe
Moderator
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:

CLOSED: Apostrophes!

Unread post by montecarlojoe »

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 ( ' , " )
Capture.JPG
Capture.JPG (14.54 KiB) Viewed 647 times
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)
rhu
Member
Member
Posts: 157
Joined: Thu Nov 22, 2012 12:52 pm
Has thanked: 11 times
Been thanked: 44 times

Re: Apostrophes!

Unread post by rhu »

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! :)
PlayingCardDB - we bag and tag playing cards
User avatar
montecarlojoe
Moderator
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!

Unread post by montecarlojoe »

Search for guinness ;)

Also - weird thing, if you search for Fulton the search results display the old name with the /' in
User avatar
ecNate
Member
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!

Unread post by ecNate »

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
rhu
Member
Member
Posts: 157
Joined: Thu Nov 22, 2012 12:52 pm
Has thanked: 11 times
Been thanked: 44 times

Re: Apostrophes!

Unread post by rhu »

montecarlojoe wrote:Search for guinness ;)

Also - weird thing, if you search for Fulton the search results display the old name with the /' in
Fixed (:
PlayingCardDB - we bag and tag playing cards
Post Reply

Who is online

Users browsing this forum: No registered users and 20 guests