System error
| error: | Tides::Location can't SELECT locationid FROM location WHERE longitude >= ORDER BY random() LIMIT 50 : DBD::Pg::st execute failed: ERROR: operator does not exist: double precision >= LINE 3: WHERE longitude >= ORDER BY random() LIMIT 50 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. [for Statement "SELECT locationid FROM location WHERE longitude >= ORDER BY random() LIMIT 50 "] 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/books.connectedvacation.com/html/kml/tides/mapplet.kml:42] [/usr/local/share/perl5/HTML/Mason/Request.pm:848] [/home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml:40] at /home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml line 42. |
||||||||||||||||||||||
| 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/books.connectedvacation.com/html/kml/tides/mapplet.kml:42 /usr/local/share/perl5/HTML/Mason/Request.pm:848 /home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml:40 |
Tides::Location can't SELECT locationid
FROM location
WHERE longitude >= ORDER BY random() LIMIT 50
: DBD::Pg::st execute failed: ERROR: operator does not exist: double precision >=
LINE 3: WHERE longitude >= ORDER BY random() LIMIT 50
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. [for Statement "SELECT locationid
FROM location
WHERE longitude >= ORDER BY random() LIMIT 50
"] 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/books.connectedvacation.com/html/kml/tides/mapplet.kml:42]
[/usr/local/share/perl5/HTML/Mason/Request.pm:848]
[/home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml:40]
at /home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml line 42.
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 longitude >= ORDER BY random() LIMIT 50^J: DBD::Pg::st execute failed: ERROR: operator does not exist: double precision >=^JLINE 3: WHERE longitude >= ORDER BY random() LIMIT 50^J ^^JHINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. [for Statement "SELECT locationid^JFROM location^JWHERE longitude >= ORDER BY random() LIMIT 50^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/books.connectedvacation.com/html/kml/tides/mapplet.kml:42]^J [/usr/local/share/perl5/HTML/Mason/Request.pm:848]^J [/home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml:40]^J at /home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml line 42.^J') called at /usr/local/share/perl5/Carp.pm line 167
Carp::croak('Tides::Location can\'t SELECT locationid^JFROM location^JWHERE longitude >= ORDER BY random() LIMIT 50^J: DBD::Pg::st execute failed: ERROR: operator does not exist: double precision >=^JLINE 3: WHERE longitude >= ORDER BY random() LIMIT 50^J ^^JHINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. [for Statement "SELECT locationid^JFROM location^JWHERE longitude >= ORDER BY random() LIMIT 50^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/books.connectedvacation.com/html/kml/tides/mapplet.kml:42]^J [/usr/local/share/perl5/HTML/Mason/Request.pm:848]^J [/home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml:40]^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 longitude >= ORDER BY random() LIMIT 50^J: DBD::Pg::st execute failed: ERROR: operator does not exist: double precision >=^JLINE 3: WHERE longitude >= ORDER BY random() LIMIT 50^J ^^JHINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. [for Statement "SELECT locationid^JFROM location^JWHERE longitude >= ORDER BY random() LIMIT 50^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/books.connectedvacation.com/html/kml/tides/mapplet.kml:42]^J [/usr/local/share/perl5/HTML/Mason/Request.pm:848]^J [/home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml:40]^J', 'err', 'HTML::Mason::Exception=HASH(0x563981b21108)') called at /usr/local/share/perl5/Class/DBI.pm line 1143
Class::DBI::sth_to_objects('Tides::Location', 'DBIx::ContextualFetch::st=HASH(0x563981b20d78)', 'ARRAY(0x563981acf428)') called at /usr/local/share/perl5/Class/DBI.pm line 1083
Class::DBI::retrieve_from_sql('Tides::Location', ' longitude >= ORDER BY random() LIMIT 50') called at /home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml line 42
HTML::Mason::Commands::__ANON__('minlongitude', '') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x5639807c2770)', 'minlongitude', '') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 919
eval {...} at /usr/local/share/perl5/HTML/Mason/Request.pm line 918
HTML::Mason::Request::call_self('HTML::Mason::Request::ApacheHandler=HASH(0x56397e5933c8)', 'SCALAR(0x56397d4dfe90)', 'ARRAY(0x56397d4dfec0)', 'SCALAR(0x56397d4dfef0)', 'CACHE_SELF') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 848
HTML::Mason::Request::cache_self('HTML::Mason::Request::ApacheHandler=HASH(0x56397e5933c8)', 'expire_in', '4 hours', 'key', ' longitude >= ') called at /home/hosting/books.connectedvacation.com/html/kml/tides/mapplet.kml line 40
HTML::Mason::Commands::__ANON__('minlongitude', '') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x5639807c2770)', 'minlongitude', '') 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, 'minlongitude', '') 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(0x56397e5933c8)') called at /usr/local/share/perl5/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x56397e5933c8)') called at /usr/local/share/perl5/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x563981acea38)', 'Apache2::RequestRec=SCALAR(0x563981aad610)') called at (eval 30) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x563981aad610)') called at -e line 0
eval {...} at -e line 0