Export not compatible with Postgresql

I have a problem with exporting gpx files with Postgresql:

  • Nextcloud: 15.0.4.0
  • Database: PostgreSQL 10.6
  • Phonetrack: v 0.4.3

Snímek_z_2019-02-23_17-58-12

Content of the files:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<gpx xmlns="http://www.topografix.com/GPX/1/1" xmlns:gpxx="http://www.garmin.com/xmlschemas/GpxExtensions/v3" xmlns:wptx1="http://www.garmin.com/xmlschemas/WaypointExtension/v1" xmlns:gpxtpx="http://www.garmin.com/xmlschemas/TrackPointExtension/v1" creator="PhoneTrack Nextcloud app 0.4.1" version="1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd http://www.garmin.com/xmlschemas/GpxExtensions/v3 http://www8.garmin.com/xmlschemas/GpxExtensionsv3.xsd http://www.garmin.com/xmlschemas/WaypointExtension/v1 http://www8.garmin.com/xmlschemas/WaypointExtensionv1.xsd http://www.garmin.com/xmlschemas/TrackPointExtension/v1 http://www.garmin.com/xmlschemas/TrackPointExtensionv1.xsd">
<metadata>
 <time>2019-01-27T20:57:09Z</time>
 <name>photo-test</name>
 <desc>1 device</desc>
</metadata>
<trk>
 <name>flachman-mobil</name>
 <trkseg>

When I do manual export it raises following notification:

Snímek_z_2019-02-23_18-00-32

Logs from console:

Deprecated include of L.Mixin.Events: this property will be removed in future releases, please inherit from L.Evented instead. y@https://example.com/apps2/phonetrack/js/leaflet.js?v=65ecc513-1:5:2081
v.extend@https://example.com/apps2/phonetrack/js/leaflet.js?v=65ecc513-1:5:14999
@https://example.com/apps2/phonetrack/js/leaflet-sidebar.min.js?v=65ecc513-1:1:19

Nextcloud logs (multiple occurences of the same errors):

[index] Error: Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing '
                    SELECT *
                    FROM oc_phonetrack_points
                    WHERE deviceid='1'  ORDER BY timestamp ASC LIMIT 0,10000 ;':

SQLSTATE[42601]: Syntax error: 7 ERROR:  LIMIT #,# syntax is not supported
LINE 4: ...       WHERE deviceid='1'  ORDER BY timestamp ASC LIMIT 0,10...
                                                             ^
HINT:  Use separate LIMIT and OFFSET clauses. at <<closure>>

 0. /nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 128
    convertException("An exception oc ... .", Doctrine\DBAL\Dr ... ]})
 1. /nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 177
    driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOPgSql\Driver {}, Doctrine\DBAL\Dr ... ]}, "\n              ... ;", [])
 2. /apps2/phonetrack/controller/pagecontroller.php line 3036
    execute()
 3. /apps2/phonetrack/controller/pagecontroller.php line 2968
    getAndWriteDeviceCoords(1, "flachman-mobil", "", null)
 4. /nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 166
    export("photo-test", "cbc6e3ede4a3395a836294505bd6b9ab", "/Documents/london/photo-test5.gpx", "", null)
 5. /nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 99
    executeController(OCA\PhoneTrack\C ... {}, "export")
 6. /nextcloud/lib/private/AppFramework/App.php line 118
    dispatch(OCA\PhoneTrack\C ... {}, "export")
 7. /nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
    main("PageController", "export", OC\AppFramework\ ... {}, {_route: "phonetrack.page.export"})
 8. <<closure>>
    __invoke({_route: "phonetrack.page.export"})
 9. /nextcloud/lib/private/Route/Router.php line 297
    call_user_func(OC\AppFramework\ ... {}, {_route: "phonetrack.page.export"})
10. /nextcloud/lib/base.php line 987
    match("/apps/phonetrack/export")
11. /nextcloud/index.php line 42
    handleRequest()

POST /apps/phonetrack/export
from 172.20.0.3 by frantisek at 2019-02-23T18:00:31+01:00
[lib] Error: ResourceLocator can not find a web root (root: /apps2/phonetrack, file: css/phonetrack/1ca4-3040-Leaflet.LinearMeasurement.css?v=9b0e5104e6a3c6a1b450df21a62de115, webRoot: , throw: true)

GET /apps/phonetrack/
from 172.20.0.3 by frantisek at 2019-02-23T17:50:12+01:00

Thank you for your time and the app!