Project

General

Profile

Bug #6203

Error handling username with single quote in Captive Portal SQL Database

Added by Phillip Davis about 3 years ago. Updated about 3 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
Captive Portal
Target version:
Start date:
04/19/2016
Due date:
% Done:

0%

Estimated time:
Affected Version:
2.3
Affected Architecture:

Description

Forum: https://forum.pfsense.org/index.php?topic=110243.0

Single quotes in user names need to be escaped as 2 single quotes in order to insert them as string literals in SQL statements.

I suspect this was also a problem in older versions prior to 2.3, but for whatever reason did not cause a "crash"report.

History

#2 Updated by Phillip Davis about 3 years ago

And PR has already been merged while I was typing the redmine issue!

#3 Updated by Steve Beaver about 3 years ago

  • Status changed from New to Feedback

#4 Updated by Chris Buechler about 3 years ago

  • Status changed from Feedback to Resolved

works, thanks Phil

Also available in: Atom PDF