Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Missing Table in DB #1275

Open
6 of 9 tasks
erwdavid opened this issue Jun 4, 2024 · 0 comments
Open
6 of 9 tasks

[Bug]: Missing Table in DB #1275

erwdavid opened this issue Jun 4, 2024 · 0 comments

Comments

@erwdavid
Copy link

erwdavid commented Jun 4, 2024

⚠️ This issue respects the following points: ⚠️

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 #547 but

  1. bug is old and closed
  2. I did not understand what had to be done (sorry I do not know anything about php, dev etc)
@erwdavid erwdavid changed the title [Bug]: Missing DB [Bug]: Missing Table in DB Jun 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant