--- a/lib/CrashTest/Controller/CrashGroups.pm Sun Dec 04 01:16:39 2016 +0100
+++ b/lib/CrashTest/Controller/CrashGroups.pm Sun Dec 18 20:14:31 2016 +0100
@@ -24,7 +24,13 @@
$self->validation->required('page')->like(qr/^[0-9]+$/);
$page = scalar $self->validation->param("page") if $self->validation->is_valid('page');
- my ($results, $pager) = $self->crash_groups->index($page, $crashs_per_page, $self->req->param('search'));
+ my ($results, $pager, $err) = $self->crash_groups->index($page, $crashs_per_page, $self->req->param('search'));
+
+ if($err) {
+ $self->app->log->info($err);
+ $self->stash(error => "Syntax error in search string: $err");
+ }
+
#$self->app->log->debug(dumper $results);
@@ -51,12 +57,17 @@
my $search = $self->req->param('search');
if(defined($search) && $search ne "") {
- $search .= " AND " . "group_id=$group->{id}";
+ $search = "(" . $search . ") AND " . "group_id=$group->{id}";
} else {
$search = "group_id=$group->{id}";
}
- my ($results, $pager) = $self->crash_reports->index($page, $crashs_per_page, $search);
+ my ($results, $pager, $err) = $self->crash_reports->index($page, $crashs_per_page, $search);
+
+ if($err) {
+ $self->app->log->info($err);
+ $self->stash(warning => "Syntax error in search string: $err");
+ }
#$self->app->log->debug(dumper $results);