Skip to content

Unable to query RSS feed #65

@BugZappa

Description

@BugZappa

Just added the plugin to my Maubot instance, only change i specified was the admin user.

When attempting to add a RSS feed i run into this error.

17:22:35DEBUGclient/@bot:matrix.my.domainStarting syncing
17:22:35DEBUGclient/@bot:matrix.my.domainreq #146 (/v3/profile/%40bot%3Amatrix.my.domain) completed in 27.1ms with status 200
17:22:35INFOclient/@bot:matrix.my.domainClient started, starting plugin instances...
17:22:35DEBUGinstance/community bot/dbConnecting to sqlite:/data/dbs/community%20bot.db
17:22:35DEBUGinstance/community bot/dbDatabase connection init commands: ['PRAGMA foreign_keys = ON', 'PRAGMA journal_mode = WAL', 'PRAGMA synchronous = NORMAL', 'PRAGMA busy_timeout = 5000']
17:22:35DEBUGmau.db.upgradeDatabase at v3, not upgrading
17:22:35INFOinstance/community botStarted instance of xyz.maubot.rss v0.4.1 with user @bot:matrix.my.domain
17:22:35DEBUGinstance/community botPolling started
17:22:35ERRORinstance/community botError while polling feeds
17:22:35ERRORinstance/community botTraceback (most recent call last):
  File "/data/plugins/xyz.maubot.rss-v0.4.1.mbp/rss/bot.py", line 185, in _poll_feeds
    await self._poll_once()
  File "/data/plugins/xyz.maubot.rss-v0.4.1.mbp/rss/bot.py", line 141, in _poll_once
    subs = await self.dbm.get_feeds()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/plugins/xyz.maubot.rss-v0.4.1.mbp/rss/db.py", line 127, in get_feeds
    rows = await self.db.fetch(q)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/database.py", line 165, in fetch
    return await conn.fetch(query, *args, timeout=timeout)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/connection.py", line 38, in wrapper
    ret = await func(self, arg, *args, **kwargs)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/connection.py", line 101, in fetch
    return await self.wrapped.fetch(query, *args, timeout=timeout)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/aiosqlite.py", line 75, in fetch
    async with self.__execute(query, *args) as cursor:
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/aiosqlite/context.py", line 41, in __aenter__
    self._obj = await self._coro
                ^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/aiosqlite/core.py", line 183, in execute
    cursor = await self._execute(self._conn.execute, sql, parameters)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/aiosqlite/core.py", line 122, in _execute
    return await future
           ^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/aiosqlite/core.py", line 105, in run
    result = function()
             ^^^^^^^^^^
sqlite3.OperationalError: no such table: feed
17:22:35INFOaiohttp.access192.168.1.14 "PUT /_matrix/maubot/v1/client/@bot:matrix.my.domain 200 2243 in 0.1363s"
17:22:47ERRORclient/@bot:matrix.my.domainFailed to run handler
17:22:47ERRORclient/@bot:matrix.my.domainTraceback (most recent call last):
  File "/usr/lib/python3.12/site-packages/mautrix/client/syncer.py", line 241, in _catch_errors
    await handler(data)
  File "/opt/maubot/maubot/handlers/command.py", line 142, in __call__
    ok, res = await self.__call_subcommand__(evt, call_args, remaining_val)
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/maubot/maubot/handlers/command.py", line 163, in __call_subcommand__
    return True, await subcommand(
                 ^^^^^^^^^^^^^^^^^
  File "/opt/maubot/maubot/handlers/command.py", line 154, in __call__
    return await self.__mb_func__(self.__bound_instance__, evt, **call_args)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/plugins/xyz.maubot.rss-v0.4.1.mbp/rss/bot.py", line 345, in subscribe
    feed = await self.dbm.get_feed_by_url(url)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/plugins/xyz.maubot.rss-v0.4.1.mbp/rss/db.py", line 169, in get_feed_by_url
    return Feed.from_row(await self.db.fetchrow(q, url))
                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/database.py", line 177, in fetchrow
    return await conn.fetchrow(query, *args, timeout=timeout)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/connection.py", line 38, in wrapper
    ret = await func(self, arg, *args, **kwargs)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/connection.py", line 121, in fetchrow
    return await self.wrapped.fetchrow(query, *args, timeout=timeout)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/aiosqlite.py", line 81, in fetchrow
    async with self.__execute(query, *args) as cursor:
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/aiosqlite/context.py", line 41, in __aenter__
    self._obj = await self._coro
                ^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/aiosqlite/core.py", line 183, in execute
    cursor = await self._execute(self._conn.execute, sql, parameters)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/aiosqlite/core.py", line 122, in _execute
    return await future
           ^^^^^^^^^^^^
  File "/usr/lib/python3.12/site-packages/aiosqlite/core.py", line 105, in run
    result = function()
             ^^^^^^^^^^
sqlite3.OperationalError: no such table: feed

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions