Uncaught exception: unknown error entry: (function => errorHandler, args => Array, )
File: /var/www/serpanalytics.com/html/include/pgsql.class.php (Line: 108)
Function: pg_query
File: /var/www/serpanalytics.com/html/keyword_new.php (Line: 305)
Function: query
pg_query(): Query failed: ERROR: operator does not exist: text >= bigint
LINE 9: join ip2country on (a.column2 >= ip2country.begin and a.c...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
/*|usr|sbin|httpd
*/
select
a.column1 as domain,
ip2country.code,
ip2country.country
from
(values ('moneymanagement.org', '203413356'),('moneymanagement.org', '203413388'),('freedomfinancialnetwork.com', '1137255138'),('freedomfinancialnetwork.com', '1137255138'),('freedomfinancialnetwork.com', '1137255138'),('freedomfinancialnetwork.com', '1137255138'),('trinitycreditservices.com', '1158490555'),('trinitycreditservices.com', '1158490555'),('freedomdebtrelief.com', '1160905177'),('freedomdebtrelief.com', '1160905177'),('hellolocal.com', '1102495818'),('hellolocal.com', '1102495818'),('christiandebtcounselors.net', '1244994114'),('christiandebtcounselors.net', '1244994114'),('freedomfinancialnetwork.com', '1137255138'),('freedomfinancialnetwork.com', '1137255138'),('freedomfinancialnetwork.com', '1137255138'),('freedomfinancialnetwork.com', '1137255138'),('christiandebtcounselors.net', '1244994114'),('christiandebtcounselors.net', '1244994114'),('hellolocal.com', '1102495818'),('hellolocal.com', '1102495818'),('freedomfinancialnetwork.com', '1137255138'),('freedomfinancialnetwork.com', '1137255138'),('freedomfinancialnetwork.com', '1137255138'),('freedomfinancialnetwork.com', '1137255138'),('trinitycreditservices.com', '1158490555'),('trinitycreditservices.com', '1158490555'),('freedomdebtrelief.com', '1160905177'),('freedomdebtrelief.com', '1160905177'),('moneymanagement.org', '203413356'),('moneymanagement.org', '203413388')) as a
join ip2country on (a.column2 >= ip2country.begin and a.column2 <= ip2country.end)