Usernames with single-quots makes the thread viewer break

A historical forum for issues reported in the suggestions and bugs forum that have been subsequently fixed or resolved.
Post Reply
User avatar
MatsP
Posts: 21038
Joined: 06 Oct 2004, 13:58
My articles: 4
My images: 28
My cats species list: 117 (i:33, k:0)
My aquaria list: 12 (i:10)
My BLogs: 4 (i:0, p:164)
Spotted: 187
Location 1: North of Cambridge
Location 2: England.

Usernames with single-quots makes the thread viewer break

Post by MatsP »

Jools,
Could not run clog_contribs query: 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 'lyse Eliot'' at line 1
Seems like something goes wrong when I read http://www.planetcatfish.com/forum/view ... hp?t=20858

Presumably because the user-name has a single-quote in it, and you are not escaping the SQL statement.

--
Mats
Top
User avatar
Jools
Expert
Posts: 16274
Joined: 30 Dec 2002, 15:25
My articles: 198
My images: 941
My catfish: 237
My cats species list: 87 (i:13, k:1)
My aquaria list: 21 (i:13)
My BLogs: 7 (i:10, p:167)
My Wishlist: 23
Spotted: 450
Location 1: Middle Earth,
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:
Contact Jools

Post by Jools »

Fixed.

Jools
Top
Post Reply

Return to “All Resolved Issues”