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

Keep getting "SQLITE_ERROR: no such table: webhooks" error. Please help? #95

Open
nothing2obvi opened this issue Oct 16, 2021 · 1 comment

Comments

@nothing2obvi
Copy link

nothing2obvi commented Oct 16, 2021

I'm not sure what I'm doing wrong...I'm able to invite @_webhook:[mydomainhere] to a room, and then the bot automatically enters the room, but whenever I type "!webhook" into the room I get the error: "There was an error processing your command." And the resulting logs for the webhook container are as such:

today at 6:54:16 AM Oct-16-2021 11:54:16.447 +00:00 warn [WebhookStore] Changing database path to be data/production.db to ensure data is persisted
today at 6:54:16 AM Oct-16-2021 11:54:16.484 +00:00 info [index] Preparing bridge...
today at 6:54:16 AM Oct-16-2021 11:54:16.485 +00:00 info [WebhookBridge] Constructing bridge
today at 6:54:16 AM Oct-16-2021 11:54:16.485 +00:00 info [WebhookBridge] Starting bridge
today at 6:54:16 AM Oct-16-2021 11:54:16.525 +00:00 info [WebhookBridge] Request to bridge room !IfXizlWcdzQphTEZSn:[mydomainhere]
today at 6:54:16 AM Oct-16-2021 11:54:16.526 +00:00 info [WebhookBridge] Request to bridge room !lLcPNetGaHkUdSoZxr:[mydomainhere]
today at 6:54:16 AM Oct-16-2021 11:54:16.527 +00:00 info [WebhookBridge] Request to bridge room !KSnBHjQxFHJPkKqeQT:[mydomainhere]
today at 6:54:16 AM Oct-16-2021 11:54:16.528 +00:00 info [WebhookBridge] Request to bridge room !sLfioKneaTQfsdUlxF:[mydomainhere]
today at 6:54:25 AM Oct-16-2021 11:54:25.177 +00:00 info [ProvisioningService] Processing create hook request for !sLfioKneaTQfsdUlxF:[mydomainhere] by @[myusername]:[mydomainhere]
today at 6:54:25 AM Oct-16-2021 11:54:25.225 +00:00 error [InteractiveProvisioner] SQLITE_ERROR: no such table: webhooks
today at 6:54:25 AM SequelizeDatabaseError: SQLITE_ERROR: no such table: webhooks
today at 6:54:25 AM     at Query.formatError (/node_modules/sequelize/lib/dialects/sqlite/query.js:431:16)
today at 6:54:25 AM     at afterExecute (/node_modules/sequelize/lib/dialects/sqlite/query.js:119:32)
today at 6:54:25 AM     at wrappedAfterExecute (/node_modules/sequelize/lib/dialects/sqlite/query.js:256:39)
today at 6:54:25 AM     at replacement (/node_modules/sqlite3/lib/trace.js:19:31)
today at 6:54:25 AM     at Statement.errBack (/node_modules/sqlite3/lib/sqlite3.js:14:21)
@ikuradon
Copy link

Are you runnning with docker?
If runnning environment is docker, edit database.json to:

{
  "defaultEnv": {
    "ENV": "NODE_ENV"
  },
  "development": {
    "driver": "sqlite3",
    "filename": "data/development.db"
  },
  "production": {
    "driver": "sqlite3",
    "filename": "data/production.db"
  }
}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants