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.0048 598816 getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ) .../get_location_by_gps.php:50 3 0.0048 598840 getLocationByGPS( $lat = '46.793', $lng = '24.714' ) .../lib.php:1370 4 0.0059 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.0061 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.0061 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.0061 694784 PommProject\Foundation\Session\Connection->getHandler( ) .../Connection.php:418 8 0.0061 694784 PommProject\Foundation\Session\Connection->launch( ) .../Connection.php:132 9 0.0062 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%3A1614549806%2C%22category%22%3A%22house-and-garden-furniture-and-interior-design%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.0048 598816 getCountryAndCityByGPS( $latitude = '46.793', $longitude = '24.714' ) .../get_location_by_gps.php:50 3 0.0048 598840 getLocationByGPS( $lat = '46.793', $lng = '24.714' ) .../lib.php:1370 4 0.0059 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.0061 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.0061 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.0061 694784 PommProject\Foundation\Session\Connection->getHandler( ) .../Connection.php:418 8 0.0061 694784 PommProject\Foundation\Session\Connection->launch( ) .../Connection.php:132
https://localapi.adverto.sale/v1/products.php
responce = {"data":[{"id":"tiluR6","id_lang":"el","category":69,"lang_advert":"el","price":"40","old_price":"","name_original":"ΣΕΤ ΕΠΙΠΛΩΝ ΚΗΠΟΥ: πωλειται ΣΕΤ επιπλων κηπου: 2 καρέκλες με πρασινο υ","description_original":"σετ επιπλων κηπου: πωλειται σετ επιπλων κηπου: 2 καρέκλες με πρασινο υφασμα (βλ. φωτο) κι ενα τραπέζι λευκου χρώματος, σε αριστη κατάσταση (αγοραστηκαν αλλα δεν χρησιμοποιήθηκαν, πωλούνται λογω μετακόμισης)","name":"GARDEN FURNITURE SET: garden furniture set: 2 chairs with green","description":"garden furniture sets: garden furniture sets for sale: 2 chairs with green cloth (see photo) and white table in excellent condition (purchased but not used, sold due to removal)","slug":"garden-furniture-set-garden-furniture-set-2-chairs-with-green-tiluR6","date_created":1519035200,"date_updated":1566488607,"date_published":1519035200,"url":"/GR/all/category/garden-furniture-set-garden-furniture-set-2-chairs-with-green-tiluR6","url_branch":"https://i.adverto.sale/K34a/tiluR6","short_url":"https://adverto.sale/tiluR6","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":942,"owner":{"id":"sudaMD7C"},"currency":{"code":"EUR","symbol":"€","symbol_html":"\u0026euro;"},"location":{"city":"","description":"GR","latitude":40.6423357,"longitude":22.9586878},"images":[{"hash":"00u6776tj9c5ovhiv7cunoz6","url":"https://cache.adverto.sale/files/images/original/00/u6/00u6776tj9c5ovhiv7cunoz6.jpg","width":700,"height":525,"sort":0}]},{"id":"VuoNxq","id_lang":"el","category":69,"lang_advert":"el","price":"80","old_price":"","name_original":"Γραφείο ικεα με συρτάρια και θέση για λάπτοπ. το γραφείο ειναι μεγάλο,","description_original":"γραφείο ικεα με συρτάρια και θέση για λάπτοπ. το γραφείο ειναι μεγάλο, ανετο: 1,25*0,75*0,75. υπάρχουν και οι οδηγίες για συναρμολόγηση.","name":"Office with drawers and laptop stand. the office is big,","description":"office with drawers and laptop stand. the office is large, comfortable: 1,25 * 0,75 * 0,75. there are also instructions for assembly.","slug":"office-with-drawers-and-laptop-stand-the-office-is-big-VuoNxq","date_created":1519036156,"date_updated":1538041497,"date_published":1519036156,"url":"/GR/all/category/office-with-drawers-and-laptop-stand-the-office-is-big-VuoNxq","url_branch":"https://i.adverto.sale/K34a/VuoNxq","short_url":"https://adverto.sale/VuoNxq","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":1001,"owner":{"id":"sudaMD7C"},"currency":{"code":"EUR","symbol":"€","symbol_html":"\u0026euro;"},"location":{"city":"","description":"GR","latitude":40.6423357,"longitude":22.9586878},"images":[{"hash":"00iwygm0s9d3cio2lboo0ya4","url":"https://cache.adverto.sale/files/images/original/00/iw/00iwygm0s9d3cio2lboo0ya4.jpg","width":700,"height":933,"sort":0},{"hash":"00zkvui9vfa946zpsyanlsy7","url":"https://cache.adverto.sale/files/images/original/00/zk/00zkvui9vfa946zpsyanlsy7.jpg","width":700,"height":933,"sort":1},{"hash":"001zgxqytjr2ka7r88qcqb5b","url":"https://cache.adverto.sale/files/images/original/00/1z/001zgxqytjr2ka7r88qcqb5b.jpg","width":700,"height":933,"sort":2},{"hash":"00wd0tybo6hzdaboadhiuc2n","url":"https://cache.adverto.sale/files/images/original/00/wd/00wd0tybo6hzdaboadhiuc2n.jpg","width":700,"height":933,"sort":3},{"hash":"00p9ag80yo420kv9khkudd57","url":"https://cache.adverto.sale/files/images/original/00/p9/00p9ag80yo420kv9khkudd57.jpg","width":700,"height":933,"sort":4}]}],"status":200,"detail":"Adverts list","uri":"/adverts","meta":{"search_id":"Mx4YFN7GFJtdTlZc","engine":1,"sid":"bFfUvrm4r9DxTrzW"}}
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