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: 
... 
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/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
raw 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.


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