System error
error: | Tides::Location can't SELECT locationid FROM location WHERE name ilike 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current%' : DBD::Pg::st execute failed: ERROR: syntax error at or near "5" LINE 3: WHERE name ilike 'Folly%20Reach,%20Buoy%20\'5\',%20South%20... ^ [for Statement "SELECT locationid FROM location WHERE name ilike 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current%' "] 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: |
|
||||||||||||||||||||||
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 |
Tides::Location can't SELECT locationid FROM location WHERE name ilike 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current%' : DBD::Pg::st execute failed: ERROR: syntax error at or near "5" LINE 3: WHERE name ilike 'Folly%20Reach,%20Buoy%20\'5\',%20South%20... ^ [for Statement "SELECT locationid FROM location WHERE name ilike 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current%' "] 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 \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20Carolina%20Current%\'^J: DBD::Pg::st execute failed: ERROR: syntax error at or near "5"^JLINE 3: WHERE name ilike \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20...^J ^ [for Statement "SELECT locationid^JFROM location^JWHERE name ilike \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20Carolina%20Current%\'^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 \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20Carolina%20Current%\'^J: DBD::Pg::st execute failed: ERROR: syntax error at or near "5"^JLINE 3: WHERE name ilike \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20...^J ^ [for Statement "SELECT locationid^JFROM location^JWHERE name ilike \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20Carolina%20Current%\'^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 \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20Carolina%20Current%\'^J: DBD::Pg::st execute failed: ERROR: syntax error at or near "5"^JLINE 3: WHERE name ilike \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20...^J ^ [for Statement "SELECT locationid^JFROM location^JWHERE name ilike \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20Carolina%20Current%\'^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(0x55bcfaf60780)') called at /usr/local/share/perl5/Class/DBI.pm line 1143 Class::DBI::sth_to_objects('Tides::Location', 'DBIx::ContextualFetch::st=HASH(0x55bcfafdac48)', 'ARRAY(0x55bcfaef4bb0)') called at /usr/local/share/perl5/Class/DBI.pm line 1083 Class::DBI::retrieve_from_sql('Tides::Location', 'name ilike \'Folly%20Reach,%20Buoy%20\\'5\\',%20South%20Carolina%20Current%\'') called at /home/hosting/www.tides.info/html/index2.html line 39 HTML::Mason::Commands::__ANON__('location', 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x55bcf9c53c70)', 'location', 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current', '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', 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current', 'command', 'view') called at /home/hosting/www.tides.info/html/new.html line 102 HTML::Mason::Commands::__ANON__('location', 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x55bcf9c3a5e0)', 'location', 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current', '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', 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current', 'command', 'view') called at /home/hosting/www.tides.info/html/autohandler line 8 HTML::Mason::Commands::__ANON__('location', 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current', 'command', 'view') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x55bcf9c29748)', 'location', 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current', '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', 'Folly%20Reach,%20Buoy%20\'5\',%20South%20Carolina%20Current', '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(0x55bcfaf387b0)') called at /usr/local/share/perl5/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x55bcfaf387b0)') called at /usr/local/share/perl5/HTML/Mason/ApacheHandler.pm line 825 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x55bcf7a49770)', 'Apache2::RequestRec=SCALAR(0x55bcfaf84980)') called at (eval 30) line 8 HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x55bcfaf84980)') called at -e line 0 eval {...} at -e line 0