Array
(
[http] => Array
(
[method] => POST
[header] => Content-Type: application/x-www-form-urlencoded
[content] => query=%7B%22lat%22%3A%2246.793%22%2C%22lng%22%3A%2224.714%22%2C%22lang%22%3A%22en%22%7D
)
)
https://localapi.adverto.sale/v1/get_location_by_gps.php
responce =
( ! ) Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused
Is the server running on host "10.10.10.11" and accepting
TCP/IP connections on port 5432? in /data/www/api.adverto.sale/v1/vendor/pomm-project/foundation/sources/lib/Session/Connection.php on line 212 Call Stack # Time Memory Function Location 1 0.0001 394464 {main}( ) .../get_location_by_gps.php:0 2 0.0068 598816 getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ) .../get_location_by_gps.php:50 3 0.0068 598840 getLocationByGPS( $lat = '46.793', $lng = '24.714' ) .../lib.php:1370 4 0.0079 692728 PommProject\Foundation\QueryManager\SimpleQueryManager->query( $sql = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($*::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ) .../lib.php:1300 5 0.0080 694624 PommProject\Foundation\QueryManager\SimpleQueryManager->doQuery( $sql = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($*::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ) .../SimpleQueryManager.php:53 6 0.0081 694784 PommProject\Foundation\Session\Connection->sendQueryWithParameters( $query = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($1::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ) .../SimpleQueryManager.php:88 7 0.0081 694784 PommProject\Foundation\Session\Connection->getHandler( ) .../Connection.php:418 8 0.0081 694784 PommProject\Foundation\Session\Connection->launch( ) .../Connection.php:132 9 0.0081 694896 pg_connect( $connection_string = 'user=adv_geo dbname=adv_geo host=10.10.10.11 port=5432 password=OhPha9ux', $connect_type = 2 ) .../Connection.php:212
Array
(
[http] => Array
(
[method] => POST
[header] => Content-Type: application/x-www-form-urlencoded
[content] => query=%7B%22uid%22%3A%22%22%2C%22distance_min%22%3A0%2C%22distance_max%22%3A5000%2C%22limit%22%3A40%2C%22page%22%3A1%2C%22search%22%3A%22%22%2C%22lang%22%3A%22en%22%2C%22adv_id%22%3A%22%22%2C%22sort_direction%22%3A%22asc%22%2C%22sort_field%22%3A%22%22%2C%22server_sort%22%3A2%2C%22from%22%3A%22%22%2C%22to%22%3A%22%22%2C%22timestamp%22%3A1614550592%2C%22category%22%3A%22electronics-audio-and-stereo%22%2C%22fields%22%3A%5B%5D%2C%22app_id%22%3A%22adverto.sale%22%2C%22published%22%3A0%2C%22is_new%22%3A0%2C%22with_photo%22%3A0%2C%22country%22%3A%22300%22%7D
)
)
( ! ) Fatal error: Uncaught PommProject\Foundation\Exception\ConnectionException: Error connecting to the database with parameters 'user=adv_geo dbname=adv_geo host=10.10.10.11 port=5432 password=xxxx'. in /data/www/api.adverto.sale/v1/vendor/pomm-project/foundation/sources/lib/Session/Connection.php on line 215 ( ! ) PommProject\Foundation\Exception\ConnectionException: Error connecting to the database with parameters 'user=adv_geo dbname=adv_geo host=10.10.10.11 port=5432 password=xxxx'. in /data/www/api.adverto.sale/v1/vendor/pomm-project/foundation/sources/lib/Session/Connection.php on line 215 Call Stack # Time Memory Function Location 1 0.0001 394464 {main}( ) .../get_location_by_gps.php:0 2 0.0068 598816 getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ) .../get_location_by_gps.php:50 3 0.0068 598840 getLocationByGPS( $lat = '46.793', $lng = '24.714' ) .../lib.php:1370 4 0.0079 692728 PommProject\Foundation\QueryManager\SimpleQueryManager->query( $sql = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($*::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ) .../lib.php:1300 5 0.0080 694624 PommProject\Foundation\QueryManager\SimpleQueryManager->doQuery( $sql = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($*::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ) .../SimpleQueryManager.php:53 6 0.0081 694784 PommProject\Foundation\Session\Connection->sendQueryWithParameters( $query = 'SELECT location_id FROM location_polygons WHERE ST_Intersects($1::text::geography, geom::geography)', $parameters = [0 => 'POINT(24.714 46.793)'] ) .../SimpleQueryManager.php:88 7 0.0081 694784 PommProject\Foundation\Session\Connection->getHandler( ) .../Connection.php:418 8 0.0081 694784 PommProject\Foundation\Session\Connection->launch( ) .../Connection.php:132
https://localapi.adverto.sale/v1/products.php
responce = {"data":[{"id":"Otvnnc","id_lang":"el","category":12294,"lang_advert":"el","price":"10","old_price":"","name_original":"ΗΧΕΙΑ ΥΠΟΛΟΓΙΣΤΗ σε αριστη κατασταση.υποδοχη ακουστικων,ρυθμιση","description_original":"ηχεια υπολογιστη σε αριστη κατασταση. υποδοχη ακουστικων,ρυθμιση εντασης και ωραιος μπλε φωτισμος","name":"COMPUTER SPEAKERS in perfect condition. Receiving headphones, tuning","description":"computer in optimum state. headphone jack, volume control and beautiful blue light","slug":"computer-speakers-in-perfect-condition-receiving-headphones-tuning-Otvnnc","date_created":1519035255,"date_updated":1601160243,"date_published":1519035255,"url":"/GR/all/category/computer-speakers-in-perfect-condition-receiving-headphones-tuning-Otvnnc","url_branch":"https://i.adverto.sale/K34a/Otvnnc","short_url":"https://adverto.sale/Otvnnc","group_id":1,"group_text":"","favorite_counter":0,"distance":"","is_published":true,"is_sold":false,"is_deleted":false,"is_blocked":false,"is_expiring":false,"is_allocated":false,"is_archived":false,"is_favorite":false,"is_top":false,"viewed":false,"views":1165,"owner":{"id":"9ww7Tp5i"},"currency":{"code":"EUR","symbol":"€","symbol_html":"\u0026euro;"},"location":{"city":"","description":"GR","latitude":37.9838096,"longitude":23.7275388},"images":[{"hash":"00cqdod058mugcloqon46f5j","url":"https://cache.adverto.sale/files/images/original/00/cq/00cqdod058mugcloqon46f5j.jpg","width":700,"height":524,"sort":0}]},{"id":"7F5fps","id_lang":"el","category":1306,"lang_advert":"el","price":"160","old_price":"","name_original":"Jabra Elite 65t μαύρα","description_original":"Τα καλύτερα Bluetooth noise cancelling ακουστικά σε τέλεια κατάσταση","name":"Jabra Elite 65t black","description":"The best Bluetooth noise cancelling headphones in perfect condition","slug":"jabra-elite-65t-black-7F5fps","date_created":1579038669,"date_updated":1579039995,"date_published":1579038669,"url":"/GR/all/electronics/electronics-audio-and-stereo/electronics-headphones/jabra-elite-65t-black-7F5fps","url_branch":"https://i.adverto.sale/K34a/7F5fps","short_url":"https://adverto.sale/7F5fps","group_id":1,"group_text":"","favorite_counter":0,"distance":"","is_published":true,"is_sold":false,"is_deleted":false,"is_blocked":false,"is_expiring":false,"is_allocated":false,"is_archived":false,"is_favorite":false,"is_top":false,"viewed":false,"views":657,"owner":{"id":"ZRlxjAVa"},"currency":{"code":"EUR","symbol":"€","symbol_html":"\u0026euro;"},"location":{"city":"","description":"GR","latitude":38.0849256,"longitude":23.8183989},"images":[{"hash":"004rhghnh5v3utslfrl8fgg2","url":"https://cache.adverto.sale/files/images/original/00/4r/004rhghnh5v3utslfrl8fgg2.jpg","width":949,"height":569,"sort":0},{"hash":"00ew4t32w37bfnwv494z8yg5","url":"https://cache.adverto.sale/files/images/original/00/ew/00ew4t32w37bfnwv494z8yg5.jpg","width":986,"height":892,"sort":1},{"hash":"008ilhdqymzg43zx84x2bm9n","url":"https://cache.adverto.sale/files/images/original/00/8i/008ilhdqymzg43zx84x2bm9n.jpg","width":507,"height":811,"sort":2}]}],"status":200,"detail":"Adverts list","uri":"/adverts","meta":{"search_id":"ut8kegGOdGqeoTif","engine":1,"sid":"u48D0iocpdBeG7F5"}}
Use your mouse to drag and select the location where you want to find goods or services. You can then expand or contract the search radius around your selected point
Your message has been successfully sent
A message with an activation code was sent to the specified phone number
The activation code was sent to the specified email address.
Password recovery instructions were sent to your email
A message with an activation code was sent to the specified phone number
Enter the received code. If you have not received the code within 1 minute, then press the button to be send again.
The activation code was sent to the specified email address.
Enter the code from email
If you are not a store, you do not have a legal entity and you want to publish ads without quantity limits, then select this option
If you are a private entrepreneur or company and want to publish ads without quantity limits, you want to download ads from your website in one-click, and set delivery rates for different regions and countries, then select this option