summaryrefslogtreecommitdiff
path: root/app/Report
diff options
context:
space:
mode:
authorGreg Roach <fisharebest@gmail.com>2015-06-15 14:49:07 +0100
committerGreg Roach <fisharebest@gmail.com>2015-06-15 14:49:07 +0100
commitb0d2e7432246725e6679d0cbf9aed561c689748e (patch)
tree16110673110d4a670c7231a41fc70b90005906d0 /app/Report
parent727f238cd22e70e36392127f0b2bce4f7aec649a (diff)
downloadwebtrees-b0d2e7432246725e6679d0cbf9aed561c689748e.tar.gz
webtrees-b0d2e7432246725e6679d0cbf9aed561c689748e.tar.bz2
webtrees-b0d2e7432246725e6679d0cbf9aed561c689748e.zip
Fix #615 - typo in SQL
Diffstat (limited to 'app/Report')
-rw-r--r--app/Report/ReportParserGenerate.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/app/Report/ReportParserGenerate.php b/app/Report/ReportParserGenerate.php
index a8dcfc3cec..be16114213 100644
--- a/app/Report/ReportParserGenerate.php
+++ b/app/Report/ReportParserGenerate.php
@@ -1873,7 +1873,7 @@ class ReportParserGenerate extends ReportParserBase {
// Convert the various filters into SQL
if (preg_match('/^(\w+):DATE (LTE|GTE) (.+)$/', $value, $match)) {
$sql_join .= " JOIN `##dates` AS {$attr} ON ({$attr}.d_file=i_file AND {$attr}.d_gid=i_id)";
- $sql_where .= " AND {$attr}.d_fact = :{$attr}fact'";
+ $sql_where .= " AND {$attr}.d_fact = :{$attr}fact";
$sql_params[$attr . 'fact'] = $match[1];
$date = new Date($match[3]);
if ($match[2] == "LTE") {
@@ -1948,7 +1948,7 @@ class ReportParserGenerate extends ReportParserBase {
$value = $this->substituteVars($value, false);
// Convert the various filters into SQL
if (preg_match('/^(\w+):DATE (LTE|GTE) (.+)$/', $value, $match)) {
- $sql_where .= " AND {$attr}.d_fact = :{$attr}fact'";
+ $sql_where .= " AND {$attr}.d_fact = :{$attr}fact";
$sql_params[$attr . 'fact'] = $match[1];
$date = new Date($match[3]);
if ($match[2] == "LTE") {