[Bug]: Missing Table in DB
Open
Nobody has claimed this yet.
0. Needs triage
bug
needs info
- Dominant language
- JavaScript
- Stars
- 598
- Forks
- 113
- PR merge metrics
- No merged PRs in 30d
Description
⚠️ This issue respects the following points: ⚠️
- This is a bug, not a question or a configuration/webserver/proxy issue.
- This issue is not already reported on Github (I've searched it).
- Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
- Maps app is up to date. See Maintenance and Release Schedule for supported versions.
- I agree to follow Nextcloud's Code of Conduct.
Bug description
I get errors in the journal (see below) for missing table oc_map_photos.
Photos are not present on map (but they are in the memories app).
PS: could not subit bug first time for toolong body so I trim things
OS is FreeBSD 13, DB is Postgresql 15, PHP 8.3.7
Steps to reproduce
Install maps
Expected behavior
photos on map, no exception
Installation method
Manual installation
Operating system
Other
PHP engine version
None
Web server
None
Database engine version
None
Is this bug present after an update or on a fresh install of the server?
None
Is this bug present after an update or on a fresh install of the app?
Fresh Nextcloud Maps install (never installed before)
Are you using the Nextcloud Server Encryption module?
None
What user-backends are you using?
- Default user-backend (database)
- LDAP/ Active Directory
- SSO - SAML
- Other
Configuration report
{
"system": {
"updatechecker": true,
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"vapeur.rail.eu.org"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"overwrite.cli.url": "https:\/\/vapeur.rail.eu.org",
"dbtype": "pgsql",
"version": "29.0.1.1",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbtableprefix": "oc_",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"logfile": "\/var\/log\/nextcloud\/nextcloud.log",
"logtimezone": "UTC",
"installed": true,
"instanceid": "***REMOVED SENSITIVE VALUE***",
"memcache.local": "\\OC\\Memcache\\APCu",
"mail_smtpmode": "smtp",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "465",
"log_rotate_size": 10485760,
"theme": "",
"loglevel": 2,
"maintenance": false,
"htaccess.RewriteBase": "\/",
"appstore.experimental.enabled": true,
"mail_smtpauthtype": "PLAIN",
"mail_smtpauth": 1,
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"mail_smtpsecure": "ssl",
"updater.release.channel": "stable",
"has_rebuilt_cache": true,
"default_phone_region": "fr",
"app_install_overwrite": [
"extract",
"sharerenamer",
"dashboard",
"twofactor_admin",
"breezedark",
"camerarawpreviews",
"carnet",
"apporder",
"files_markdown",
"groupfolders"
],
"versions_retention_obligation": "auto,15",
"maintenance_window_start": 0,
"memories.db.triggers.fcu": true,
"memories.exiftool_no_local": true,
"memories.vod.path": "\/usr\/local\/nextcloud\/apps\/memories\/bin-ext\/go-vod-amd64",
"memories.vod.ffmpeg": "\/usr\/local\/bin\/ffmpeg",
"memories.vod.ffprobe": "\/usr\/local\/bin\/ffprobe",
"enabledPreviewProviders": [
"OC\\Preview\\Image",
"OC\\Preview\\HEIC",
"OC\\Preview\\TIFF",
"OC\\Preview\\Movie"
],
"preview_max_x": 2048,
"preview_max_y": 2048
}
}
List of activated Apps
Enabled:
- activity: 2.21.1
- apporder: 0.15.0
- audioplayer: 3.4.1
- bookmarks: 14.1.1
- breezedark: 28.0.0
- calendar: 4.7.4
- camerarawpreviews: 0.8.5
- circles: 29.0.0-dev
- cloud_federation_api: 1.12.0
- comments: 1.19.0
- contacts: 6.0.0
- dav: 1.30.1
- extract: 1.3.6
- federatedfilesharing: 1.19.0
- files: 2.1.0
- files_downloadlimit: 2.0.0
- files_external: 1.21.0
- files_markdown: 2.4.1
- files_pdfviewer: 2.10.0
- files_reminders: 1.2.0
- files_sharing: 1.21.0
- files_trashbin: 1.19.0
- firstrunwizard: 2.18.0
- gpxpod: 5.0.18
- groupfolders: 17.0.0
- logreader: 2.14.0
- lookup_server_connector: 1.17.0
- maps: 1.4.0
- memories: 7.3.1
- music: 1.11.0
- nextcloud_announcements: 1.18.0
- notes: 4.10.0
- notifications: 2.17.0
- oauth2: 1.17.0
- password_policy: 1.19.0
- photos: 2.5.0
- privacy: 1.13.0
- provisioning_api: 1.19.0
- related_resources: 1.4.0
- serverinfo: 1.19.0
- settings: 1.12.0
- sharebymail: 1.19.0
- sharerenamer: 3.4.0
- suspicious_login: 7.0.0
- tasks: 0.16.0
- text: 3.10.0
- theming: 2.4.0
- twofactor_backupcodes: 1.18.0
- twofactor_totp: 11.0.0-dev
- updatenotification: 1.19.1
- user_status: 1.9.0
- viewer: 2.3.0
- weather_status: 1.9.0
- workflowengine: 2.11.0
Nextcloud Signing status
No errors have been found.
Nextcloud Logs
{"reqId":"EtI07BzDimaBTTr0LErB","level":3,"time":"2024-06-04T06:32:04+00:00","remoteAddr":"80.74.64.33","user":"erwan","app":"index","method":"GET","url":"/apps/maps/tracks","message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_tracks\" does not exist\nLINE 1: ...\"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_t...\n ^","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","exception":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_tracks\" does not exist\nLINE 1: ...\"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_t...\n ^","Code":7,"Trace":[{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1943,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1885,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1106,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"SELECT \"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_tracks\" \"t\" WHERE \"user_id\" = ?",["erwan"],[2]]},{"file":"/usr/local/nextcloud/lib/private/DB/Connection.php","line":313,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_tracks\" \"t\" WHERE \"user_id\" = ?",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_tracks\" \"t\" WHERE \"user_id\" = :dcValue1",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/TracksService.php","line":263,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/TracksController.php","line":95,"function":"getTracksFromDB","class":"OCA\\Maps\\Service\\TracksService","type":"->","args":["erwan",["OC\\Files\\Node\\LazyUserFolder"],true,false,true]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getTracks","class":"OCA\\Maps\\Controller\\TracksController","type":"->","args":[null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\TracksController"],"getTracks"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\TracksController"],"getTracks"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\TracksController","getTracks",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.tracks.gettracks"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/tracks"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_tracks\" does not exist\nLINE 1: ...\"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_t...\n ^","Code":7,"Trace":[{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[["PDOException",["42P01",7,"ERROR: relation \"oc_maps_tracks\" does not exist\nLINE 1: ...\"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_t...\n ^"]]]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/Connection.php","line":313,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_tracks\" \"t\" WHERE \"user_id\" = ?",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_tracks\" \"t\" WHERE \"user_id\" = :dcValue1",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/TracksService.php","line":263,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/TracksController.php","line":95,"function":"getTracksFromDB","class":"OCA\\Maps\\Service\\TracksService","type":"->","args":["erwan",["OC\\Files\\Node\\LazyUserFolder"],true,false,true]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getTracks","class":"OCA\\Maps\\Controller\\TracksController","type":"->","args":[null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\TracksController"],"getTracks"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\TracksController"],"getTracks"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\TracksController","getTracks",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.tracks.gettracks"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/tracks"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_tracks\" does not exist\nLINE 1: ...\"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_t...\n ^","Code":"42P01","Trace":[{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/Connection.php","line":313,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_tracks\" \"t\" WHERE \"user_id\" = ?",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_tracks\" \"t\" WHERE \"user_id\" = :dcValue1",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/TracksService.php","line":263,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/TracksController.php","line":95,"function":"getTracksFromDB","class":"OCA\\Maps\\Service\\TracksService","type":"->","args":["erwan",["OC\\Files\\Node\\LazyUserFolder"],true,false,true]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getTracks","class":"OCA\\Maps\\Controller\\TracksController","type":"->","args":[null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\TracksController"],"getTracks"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\TracksController"],"getTracks"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\TracksController","getTracks",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.tracks.gettracks"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/tracks"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_tracks\" does not exist\nLINE 1: ...\"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_t...\n ^","exception":{},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_tracks\" does not exist\nLINE 1: ...\"id\", \"file_id\", \"color\", \"metadata\", \"etag\" FROM \"oc_maps_t...\n ^"}}
{"reqId":"CBgIlUAfAkslbDF6iEOJ","level":3,"time":"2024-06-04T06:32:04+00:00","remoteAddr":"80.74.64.33","user":"erwan","app":"index","method":"GET","url":"/apps/maps/devices","message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_devices\" does not exist\nLINE 1: SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d...\n ^","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","exception":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_devices\" does not exist\nLINE 1: SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d...\n ^","Code":7,"Trace":[{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1943,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1885,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1106,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d\" WHERE \"user_id\" = ?",["erwan"],[2]]},{"file":"/usr/local/nextcloud/lib/private/DB/Connection.php","line":313,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d\" WHERE \"user_id\" = ?",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d\" WHERE \"user_id\" = :dcValue1",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/DevicesService.php","line":62,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/DevicesController.php","line":117,"function":"getDevicesFromDB","class":"OCA\\Maps\\Service\\DevicesService","type":"->","args":["erwan"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getDevices","class":"OCA\\Maps\\Controller\\DevicesController","type":"->","args":[[],null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\DevicesController"],"getDevices"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\DevicesController"],"getDevices"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\DevicesController","getDevices",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.devices.getdevices"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/devices"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_devices\" does not exist\nLINE 1: SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d...\n ^","Code":7,"Trace":[{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[["PDOException",["42P01",7,"ERROR: relation \"oc_maps_devices\" does not exist\nLINE 1: SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d...\n ^"]]]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/Connection.php","line":313,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d\" WHERE \"user_id\" = ?",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d\" WHERE \"user_id\" = :dcValue1",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/DevicesService.php","line":62,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/DevicesController.php","line":117,"function":"getDevicesFromDB","class":"OCA\\Maps\\Service\\DevicesService","type":"->","args":["erwan"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getDevices","class":"OCA\\Maps\\Controller\\DevicesController","type":"->","args":[[],null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\DevicesController"],"getDevices"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\DevicesController"],"getDevices"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\DevicesController","getDevices",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.devices.getdevices"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/devices"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_devices\" does not exist\nLINE 1: SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d...\n ^","Code":"42P01","Trace":[{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/Connection.php","line":313,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d\" WHERE \"user_id\" = ?",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d\" WHERE \"user_id\" = :dcValue1",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/DevicesService.php","line":62,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/DevicesController.php","line":117,"function":"getDevicesFromDB","class":"OCA\\Maps\\Service\\DevicesService","type":"->","args":["erwan"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getDevices","class":"OCA\\Maps\\Controller\\DevicesController","type":"->","args":[[],null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\DevicesController"],"getDevices"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\DevicesController"],"getDevices"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\DevicesController","getDevices",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.devices.getdevices"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/devices"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_devices\" does not exist\nLINE 1: SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d...\n ^","exception":{},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_devices\" does not exist\nLINE 1: SELECT \"id\", \"user_agent\", \"color\" FROM \"oc_maps_devices\" \"d...\n ^"}}
{"reqId":"QG0VXgPD5JwrOp88XrHd","level":3,"time":"2024-06-04T06:32:10+00:00","remoteAddr":"80.74.64.33","user":"erwan","app":"index","method":"GET","url":"/apps/maps/photos","message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_photos\" does not exist\nLINE 1: SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = $1) AND (\"...\n ^","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:126.0) Gecko/20100101 Firefox/126.0","version":"29.0.1.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_photos\" does not exist\nLINE 1: SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = $1) AND (\"...\n ^","Code":7,"Trace":[{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":295,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[["Doctrine\\DBAL\\Exception\\TableNotFoundException"]]},{"file":"/usr/local/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/DB/GeophotoMapper.php","line":112,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"]]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/GeophotoService.php","line":116,"function":"findAll","class":"OCA\\Maps\\DB\\GeophotoMapper","type":"->","args":["erwan"]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/PhotosController.php","line":68,"function":"getAll","class":"OCA\\Maps\\Service\\GeophotoService","type":"->","args":["erwan",["OC\\Files\\Node\\LazyUserFolder"],true,false,true]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getPhotos","class":"OCA\\Maps\\Controller\\PhotosController","type":"->","args":[null,null,null,null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\PhotosController"],"getPhotos"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\PhotosController"],"getPhotos"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\PhotosController","getPhotos",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.photos.getphotos"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/photos"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/lib/private/DB/Exceptions/DbalException.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_photos\" does not exist\nLINE 1: SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = $1) AND (\"...\n ^","Code":7,"Trace":[{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1943,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1885,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1106,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = ?) AND (\"lat\" IS NOT NULL) AND (\"lng\" IS NOT NULL) ORDER BY \"date_taken\" ASC",["erwan"],[2]]},{"file":"/usr/local/nextcloud/lib/private/DB/Connection.php","line":313,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = ?) AND (\"lat\" IS NOT NULL) AND (\"lng\" IS NOT NULL) ORDER BY \"date_taken\" ASC",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = :dcValue1) AND (\"lat\" IS NOT NULL) AND (\"lng\" IS NOT NULL) ORDER BY \"date_taken\" ASC",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/DB/GeophotoMapper.php","line":112,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"]]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/GeophotoService.php","line":116,"function":"findAll","class":"OCA\\Maps\\DB\\GeophotoMapper","type":"->","args":["erwan"]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/PhotosController.php","line":68,"function":"getAll","class":"OCA\\Maps\\Service\\GeophotoService","type":"->","args":["erwan",["OC\\Files\\Node\\LazyUserFolder"],true,false,true]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getPhotos","class":"OCA\\Maps\\Controller\\PhotosController","type":"->","args":[null,null,null,null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\PhotosController"],"getPhotos"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\PhotosController"],"getPhotos"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\PhotosController","getPhotos",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.photos.getphotos"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/photos"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_photos\" does not exist\nLINE 1: SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = $1) AND (\"...\n ^","Code":7,"Trace":[{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[["PDOException",["42P01",7,"ERROR: relation \"oc_maps_photos\" does not exist\nLINE 1: SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = $1) AND (\"...\n ^"]]]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/Connection.php","line":313,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = ?) AND (\"lat\" IS NOT NULL) AND (\"lng\" IS NOT NULL) ORDER BY \"date_taken\" ASC",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = :dcValue1) AND (\"lat\" IS NOT NULL) AND (\"lng\" IS NOT NULL) ORDER BY \"date_taken\" ASC",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/DB/GeophotoMapper.php","line":112,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"]]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/GeophotoService.php","line":116,"function":"findAll","class":"OCA\\Maps\\DB\\GeophotoMapper","type":"->","args":["erwan"]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/PhotosController.php","line":68,"function":"getAll","class":"OCA\\Maps\\Service\\GeophotoService","type":"->","args":["erwan",["OC\\Files\\Node\\LazyUserFolder"],true,false,true]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getPhotos","class":"OCA\\Maps\\Controller\\PhotosController","type":"->","args":[null,null,null,null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\PhotosController"],"getPhotos"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\PhotosController"],"getPhotos"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\PhotosController","getPhotos",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.photos.getphotos"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/photos"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_photos\" does not exist\nLINE 1: SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = $1) AND (\"...\n ^","Code":"42P01","Trace":[{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/Connection.php","line":313,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = ?) AND (\"lat\" IS NOT NULL) AND (\"lng\" IS NOT NULL) ORDER BY \"date_taken\" ASC",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = :dcValue1) AND (\"lat\" IS NOT NULL) AND (\"lng\" IS NOT NULL) ORDER BY \"date_taken\" ASC",["erwan"],[2],null]},{"file":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/usr/local/nextcloud/apps/maps/lib/DB/GeophotoMapper.php","line":112,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OC\\DB\\QueryBuilder\\QueryBuilder"]]},{"file":"/usr/local/nextcloud/apps/maps/lib/Service/GeophotoService.php","line":116,"function":"findAll","class":"OCA\\Maps\\DB\\GeophotoMapper","type":"->","args":["erwan"]},{"file":"/usr/local/nextcloud/apps/maps/lib/Controller/PhotosController.php","line":68,"function":"getAll","class":"OCA\\Maps\\Service\\GeophotoService","type":"->","args":["erwan",["OC\\Files\\Node\\LazyUserFolder"],true,false,true]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"getPhotos","class":"OCA\\Maps\\Controller\\PhotosController","type":"->","args":[null,null,null,null]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\PhotosController"],"getPhotos"]},{"file":"/usr/local/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Maps\\Controller\\PhotosController"],"getPhotos"]},{"file":"/usr/local/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Maps\\Controller\\PhotosController","getPhotos",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["maps.photos.getphotos"]]},{"file":"/usr/local/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/photos"]},{"file":"/usr/local/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/usr/local/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_photos\" does not exist\nLINE 1: SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = $1) AND (\"...\n ^","exception":{},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"oc_maps_photos\" does not exist\nLINE 1: SELECT * FROM \"oc_maps_photos\" WHERE (\"user_id\" = $1) AND (\"...\n ^"}}
Browser Console
No response
Additional info
I found https://github.com/nextcloud/maps/issues/547 but
- bug is old and closed
- I did not understand what had to be done (sorry I do not know anything about php, dev etc)
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the fresh Maps installation and the /apps/maps/tracks request, then trace the failure from apps/maps/lib/Service/TracksService.php:263 through TracksController.php:95. Check why the oc_maps_tracks table is absent in the reported PostgreSQL setup; done means the table exists after installation, photos appear on the map, and the exception no longer occurs.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, php, postgresql
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100