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
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:
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!