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.0056 598816 getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ) .../get_location_by_gps.php:50 3 0.0056 598840 getLocationByGPS( $lat = '46.793', $lng = '24.714' ) .../lib.php:1370 4 0.0070 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.0072 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.0072 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.0072 694784 PommProject\Foundation\Session\Connection->getHandler( ) .../Connection.php:418 8 0.0073 694784 PommProject\Foundation\Session\Connection->launch( ) .../Connection.php:132 9 0.0073 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%3A1614551103%2C%22category%22%3A%22house-and-garden-handmade-goods%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.0056 598816 getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ) .../get_location_by_gps.php:50 3 0.0056 598840 getLocationByGPS( $lat = '46.793', $lng = '24.714' ) .../lib.php:1370 4 0.0070 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.0072 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.0072 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.0072 694784 PommProject\Foundation\Session\Connection->getHandler( ) .../Connection.php:418 8 0.0073 694784 PommProject\Foundation\Session\Connection->launch( ) .../Connection.php:132
https://localapi.adverto.sale/v1/products.php
responce = {"data":[{"id":"R4cYkt","id_lang":"el","category":1703,"lang_advert":"el","price":"7","old_price":"","name_original":"Χειροποίητη ξύλινη βάση επιτοίχια με σχήμα σταυρού","description_original":"Χειροποίητη ξύλινη βάση επιτοίχια με σχήμα σταυρού έτοιμη για κρέμασμα παρέχεται και το ρεσο! Από ξύλο ΈΛΑΤΟ φυσικό χρώμα!43*16,5 ","name":"Handmade wooden base in the shape of a cross","description":"Handmade wooden base wall-mounted in the shape of a cross, ready for hanging, is also available! Made of natural wood natural color 43 * 16,5","slug":"handmade-wooden-base-in-the-shape-of-a-cross-R4cYkt","date_created":1547288245,"date_updated":1547288245,"date_published":1547288245,"url":"/GR/all/house-and-garden/house-and-garden-handmade-goods/house-and-garden-handmade-goods-ornaments/handmade-wooden-base-in-the-shape-of-a-cross-R4cYkt","url_branch":"https://i.adverto.sale/K34a/R4cYkt","short_url":"https://adverto.sale/R4cYkt","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":722,"owner":{"id":"cOzdDkNW"},"currency":{"code":"EUR","symbol":"€","symbol_html":"\u0026euro;"},"location":{"city":"","description":"GR","latitude":37.929090656028,"longitude":23.513326831162},"images":[{"hash":"00ypulrhatf8dyyzidb4mqdy","url":"https://cache.adverto.sale/files/images/original/00/yp/00ypulrhatf8dyyzidb4mqdy.jpg","width":1500,"height":2000,"sort":0},{"hash":"00ihi26iddjg8pb92aazx2ut","url":"https://cache.adverto.sale/files/images/original/00/ih/00ihi26iddjg8pb92aazx2ut.jpg","width":1500,"height":2000,"sort":1},{"hash":"00g9yp6462cm4fxflg3gxhx9","url":"https://cache.adverto.sale/files/images/original/00/g9/00g9yp6462cm4fxflg3gxhx9.jpg","width":1500,"height":2000,"sort":2}]},{"id":"AFa9Dx","id_lang":"el","category":1703,"lang_advert":"el","price":"20","old_price":"","name_original":"Χειροποίητη ξύλινη βάση επιτοίχια ρεσο","description_original":"Χειροποίητη ξύλινη βάση ρεσου έτοιμη για κρέμασμα από ξύλο ΈΛΑΤΟ 36 εκατοστά! Τηλέφωνο επικοινωνίας 6988999297 ","name":"Handmade wooden wall mounted wall mount","description":"Handmade wooden stand ready for hanging wood 36 cm elbow! Contact number 6988999297","slug":"handmade-wooden-wall-mounted-wall-mount-AFa9Dx","date_created":1547285271,"date_updated":1547285271,"date_published":1547285271,"url":"/GR/all/house-and-garden/house-and-garden-handmade-goods/house-and-garden-handmade-goods-ornaments/handmade-wooden-wall-mounted-wall-mount-AFa9Dx","url_branch":"https://i.adverto.sale/K34a/AFa9Dx","short_url":"https://adverto.sale/AFa9Dx","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":707,"owner":{"id":"cOzdDkNW"},"currency":{"code":"EUR","symbol":"€","symbol_html":"\u0026euro;"},"location":{"city":"","description":"GR","latitude":37.929090656028,"longitude":23.513326831162},"images":[{"hash":"00sv5vxpu35djnxgs9hhy18r","url":"https://cache.adverto.sale/files/images/original/00/sv/00sv5vxpu35djnxgs9hhy18r.jpg","width":892,"height":960,"sort":0},{"hash":"001h29uwodzd7j99yozkw710","url":"https://cache.adverto.sale/files/images/original/00/1h/001h29uwodzd7j99yozkw710.jpg","width":846,"height":960,"sort":1},{"hash":"00bxjhhmh30k72cu6ssqsjdg","url":"https://cache.adverto.sale/files/images/original/00/bx/00bxjhhmh30k72cu6ssqsjdg.jpg","width":2000,"height":1500,"sort":2}]}],"status":200,"detail":"Adverts list","uri":"/adverts","meta":{"search_id":"CWbut90Yo0M05MH6","engine":1,"sid":"V0288uwc7jSlJui0"}}
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