low to medium priority bug - user name with apostrophe

[blueginko]

I have a user with an apostrophe in their name, so I thought I should check how it looks in Coppermine. It's a ah, minor (is there a minor show stopepr) but the escape symbol shows before the apostrophe in the name in:

1.  top menu Logout [O\'test]
2.  Profile header bar "O\'test's profile"
(see image for example).

appears correctly (O'test) in but causes issues:

1.  If you create a user album "O'test's album" it's shown correctly.
2.  Memberlist and admin userlist - NOTE however if you click on the users name DB throws an error clearly because of the apostrophe:

While executing query "SELECT pid FROM cpg_pictures WHERE owner_name = 'O'test'" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'test'' at line 1.

So, it displays incorrectly in many areas, and will throw an error in a db query because it's not dealt with in the query.



Excellent release thou!  So many issues fixed.

[Joachim Müller]

Confirming this bug:
1.  top menu Logout [O\'test]

2.  Profile header bar "O\'test's profile" (the <title> tag)

3. In http://domain.tld/cpg14x/profile.php?uid=6

Code Select Expand

While executing query "SELECT pid FROM cpg140_pictures WHERE owner_name = 'O'Test'" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Test'' at line 1
. The line reads

Code Select Expand

        $result = cpg_db_query("SELECT pid FROM {$CONFIG['TABLE_PICTURES']} WHERE owner_name = '$user_data[user_name]'");, so the $user_data array needs proper escaping


@devs: volunteers?

[Aditya Mooley]

Updating my devel. Will soon commit fix.

[Aditya Mooley]

Fixed and commited to CVS.

[Joachim Müller]

Confirming fix. Thanks for looking into it. Marking thread as "fixed"

[stock]

Could someone explain about this.

I am suddenly getting this problem the the escape symbol showing before the single apostrophe in image description, not even in title (I dont use them in titles)

But this is not happening in captions I did earlier.

Why is this suddently happening and what can I do about this?

Thanks

Stock

[stock]

Here is what is happening. In fact it puts in three escape symbols!

I have take off read EXif data.

The one further down is where I re-typed it in case the one above was Exif data. I have even tried using the &#and the number code instead of the apostrophe but this is too much as plants need to have apostrophes around a port of the name for official naming purposes, so it's important to get this right.

this is what is happening sometimes (the three)
Aquilegia State Series \\\'Kansas\\\'
(Columbine) on show at
2005 rhs Hampton
Court Palace flower show

this is the re-type:
Aquilegia State Series \'Kansas\' (Columbine) on show at 2005 rhs Hampton Court Palace Flower show

Stock

[Joachim Müller]

are you requesting support for cpg1.4.x? There is no support yet. If this is suppossed to be a bug report, then post the needed data as suggested in section 0 of the dev docs. Make sure you actually have the most recent cvs checkout of cpg1.4.x when posting here. If you have another version, post on the board that deals with your version!

[stock]

sorry I am confused. I searched for the right topic and put this on the end of one posting. I am not 1.4

thanks
Stock