Difference between revisions of "Issue:Problem with category containing a single quote character"
m (→Problem) |
m (→Problem) |
||
Line 10: | Line 10: | ||
I use DPL to list all pages that are in two categories, one is "Besoin" (Yes, I'm French) and the other one is the page name. | I use DPL to list all pages that are in two categories, one is "Besoin" (Yes, I'm French) and the other one is the page name. | ||
− | So I use the option "category=Besoin&{{PAGENAME}}" | + | So I use the option "category=Besoin&<nowiki>{{PAGENAME}}</nowiki>" |
When the page name contains a single quote character ', I get an SQL error. The SQL query seems to have 3 different categories : Besoin, the page name to the single quote character and an empty name. | When the page name contains a single quote character ', I get an SQL error. The SQL query seems to have 3 different categories : Besoin, the page name to the single quote character and an empty name. |
Revision as of 16:17, 9 July 2009
Description: | SQL error when using two categories, one containing a single quote character |
Extension / Version: | DPL / 1.7.9 |
Type / Status: | Bug / open |
Problem
I use DPL to list all pages that are in two categories, one is "Besoin" (Yes, I'm French) and the other one is the page name.
So I use the option "category=Besoin&{{PAGENAME}}"
When the page name contains a single quote character ', I get an SQL error. The SQL query seems to have 3 different categories : Besoin, the page name to the single quote character and an empty name.
I looked at DynamicPageList2.php, and found a way to solve my problem.
In the section of FILTER PARAMETERS, case category, $sArg contains the value of the option category. But in the case of a page name with a single quote, this character is changed into "'". And the character & is interpreted later as a separator between diferent category names, which is not what is expected...
I corrected the problem in a pragmatic but not really efficient way : I added the line
$sArg = str_replace("'","'",$sArg);
before the line if (strpos($sArg,'&')!==false) {
With this modification (I can't really call it a correction), the dpl query works.