System error

error:  Tides::Location can't SELECT locationid
FROM location
WHERE name ilike 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England%'
: DBD::Pg::st execute failed: ERROR: syntax error at or near "s"
LINE 3: WHERE name ilike 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20E...
^ [for Statement "SELECT locationid
FROM location
WHERE name ilike 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England%'
"] at /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.

Stack:
[/usr/local/share/perl5/DBIx/ContextualFetch.pm:52]
[/usr/local/share/perl5/DBIx/ContextualFetch.pm:32]
[/usr/local/share/perl5/Class/DBI.pm:1139]
[/usr/local/share/perl5/Class/DBI.pm:1083]
[/home/hosting/www.tides.info/html/index2.html:39]
[/home/hosting/www.tides.info/html/new.html:102]
[/home/hosting/www.tides.info/html/autohandler:8]
at /home/hosting/www.tides.info/html/index2.html line 39.
context: 
... 
163:  local @CARP_NOT = $cgc ? $cgc->() : caller();
164:  shortmess_heavy(@_);
165:  }
166: 
167:  sub croak { die shortmess @_ }
168:  sub confess { die longmess @_ }
169:  sub carp { warn shortmess @_ }
170:  sub cluck { warn longmess @_ }
171: 
... 
code stack:  /usr/local/share/perl5/Carp.pm:167
/usr/local/share/perl5/Class/DBI.pm:169
/usr/local/share/perl5/Class/DBI.pm:1143
/usr/local/share/perl5/Class/DBI.pm:1083
/home/hosting/www.tides.info/html/index2.html:39
/home/hosting/www.tides.info/html/new.html:102
/home/hosting/www.tides.info/html/autohandler:8
raw error






























Tides::Location can't SELECT locationid
FROM   location
WHERE  name ilike 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England%'
: DBD::Pg::st execute failed: ERROR:  syntax error at or near "s"
LINE 3: WHERE  name ilike 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20E...
                                       ^ [for Statement "SELECT locationid
FROM   location
WHERE  name ilike 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England%'
"] at /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.

Stack:
  [/usr/local/share/perl5/DBIx/ContextualFetch.pm:52]
  [/usr/local/share/perl5/DBIx/ContextualFetch.pm:32]
  [/usr/local/share/perl5/Class/DBI.pm:1139]
  [/usr/local/share/perl5/Class/DBI.pm:1083]
  [/home/hosting/www.tides.info/html/index2.html:39]
  [/home/hosting/www.tides.info/html/new.html:102]
  [/home/hosting/www.tides.info/html/autohandler:8]
 at /home/hosting/www.tides.info/html/index2.html line 39.


Trace begun at /usr/local/share/perl5/HTML/Mason/Exceptions.pm line 125
HTML::Mason::Exceptions::rethrow_exception('Tides::Location can\'t SELECT locationid^JFROM   location^JWHERE  name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20England%\'^J: DBD::Pg::st execute failed: ERROR:  syntax error at or near "s"^JLINE 3: WHERE  name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20E...^J                                       ^ [for Statement "SELECT locationid^JFROM   location^JWHERE  name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20England%\'^J"] at /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.^J^JStack:^J  [/usr/local/share/perl5/DBIx/ContextualFetch.pm:52]^J  [/usr/local/share/perl5/DBIx/ContextualFetch.pm:32]^J  [/usr/local/share/perl5/Class/DBI.pm:1139]^J  [/usr/local/share/perl5/Class/DBI.pm:1083]^J  [/home/hosting/www.tides.info/html/index2.html:39]^J  [/home/hosting/www.tides.info/html/new.html:102]^J  [/home/hosting/www.tides.info/html/autohandler:8]^J at /home/hosting/www.tides.info/html/index2.html line 39.^J') called at /usr/local/share/perl5/Carp.pm line 167
Carp::croak('Tides::Location can\'t SELECT locationid^JFROM   location^JWHERE  name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20England%\'^J: DBD::Pg::st execute failed: ERROR:  syntax error at or near "s"^JLINE 3: WHERE  name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20E...^J                                       ^ [for Statement "SELECT locationid^JFROM   location^JWHERE  name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20England%\'^J"] at /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.^J^JStack:^J  [/usr/local/share/perl5/DBIx/ContextualFetch.pm:52]^J  [/usr/local/share/perl5/DBIx/ContextualFetch.pm:32]^J  [/usr/local/share/perl5/Class/DBI.pm:1139]^J  [/usr/local/share/perl5/Class/DBI.pm:1083]^J  [/home/hosting/www.tides.info/html/index2.html:39]^J  [/home/hosting/www.tides.info/html/new.html:102]^J  [/home/hosting/www.tides.info/html/autohandler:8]^J') called at /usr/local/share/perl5/Class/DBI.pm line 169
Class::DBI::_croak('Tides::Location', 'Tides::Location can\'t SELECT locationid^JFROM   location^JWHERE  name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20England%\'^J: DBD::Pg::st execute failed: ERROR:  syntax error at or near "s"^JLINE 3: WHERE  name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20E...^J                                       ^ [for Statement "SELECT locationid^JFROM   location^JWHERE  name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20England%\'^J"] at /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.^J^JStack:^J  [/usr/local/share/perl5/DBIx/ContextualFetch.pm:52]^J  [/usr/local/share/perl5/DBIx/ContextualFetch.pm:32]^J  [/usr/local/share/perl5/Class/DBI.pm:1139]^J  [/usr/local/share/perl5/Class/DBI.pm:1083]^J  [/home/hosting/www.tides.info/html/index2.html:39]^J  [/home/hosting/www.tides.info/html/new.html:102]^J  [/home/hosting/www.tides.info/html/autohandler:8]^J', 'err', 'HTML::Mason::Exception=HASH(0x55bcf95a7ed8)') called at /usr/local/share/perl5/Class/DBI.pm line 1143
Class::DBI::sth_to_objects('Tides::Location', 'DBIx::ContextualFetch::st=HASH(0x55bcf9463e80)', 'ARRAY(0x55bcf93a6740)') called at /usr/local/share/perl5/Class/DBI.pm line 1083
Class::DBI::retrieve_from_sql('Tides::Location', 'name ilike \'St.%20Mary\\'s,%20Isles%20of%20Scilly,%20England%\'') called at /home/hosting/www.tides.info/html/index2.html line 39
HTML::Mason::Commands::__ANON__('location', 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x55bcf948d3d8)', 'location', 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, 'location', 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England', 'command', 'view') called at /home/hosting/www.tides.info/html/new.html line 102
HTML::Mason::Commands::__ANON__('location', 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x55bcf9472d48)', 'location', 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, 'location', 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England', 'command', 'view') called at /home/hosting/www.tides.info/html/autohandler line 8
HTML::Mason::Commands::__ANON__('location', 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x55bcf9461ae0)', 'location', 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1297
eval {...} at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'location', 'St.%20Mary\'s,%20Isles%20of%20Scilly,%20England', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 481
eval {...} at /usr/local/share/perl5/HTML/Mason/Request.pm line 481
eval {...} at /usr/local/share/perl5/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x55bcf8410348)') called at /usr/local/share/perl5/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x55bcf8410348)') called at /usr/local/share/perl5/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x55bcf835a8f0)', 'Apache2::RequestRec=SCALAR(0x55bcf79d7c20)') called at (eval 30) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x55bcf79d7c20)') called at -e line 0
eval {...} at -e line 0