cannot delete row

[fzhnf]

repo: https://github.com/fzhnf/api-endpoint-adonis

i don't know what's the problem, i can update the row but i can't delete it, i keep configuring the migration and model of thread but still, can only change it, and deletion still not happening, it stressing me out that i tried to get the solution and can't get the solution 😢

request

DELETE /api/threads/1 HTTP/1.1
Authorization : Bearer oat_Mw.OVVnODRUZnBNVG9QZkp5dkZtMlpPbmpLbkd6WEp3MVNnZ2dfV0w1VzQyMTgzNDQ5MjU
Host : localhost:3333
User-Agent : HTTPie

response

HTTP/1.1 404 Not Found
Connection: keep-alive
Date: Wed, 17 Jul 2024 12:27:01 GMT
Keep-Alive: timeout=5
content-length: 1578
content-type: application/json; charset=utf-8

{
    "frames": [
        {
            "callee": "Runner.<anonymous>",
            "calleeShort": "<anonymous>",
            "column": 27,
            "context": {},
            "file": "node_modules/@adonisjs/http-server/src/server/factories/final_handler.ts",
            "filePath": "/home/fzhnf/Public/forum-api/node_modules/@adonisjs/http-server/src/server/factories/final_handler.ts",
            "isApp": false,
            "isModule": true,
            "isNative": false,
            "line": 42
        },
        {
            "callee": "#invokeWithErrorManagement",
            "calleeShort": "#invokeWithErrorManagement",
            "column": 19,
            "context": {},
            "file": "node_modules/@poppinss/middleware/src/runner.ts",
            "filePath": "/home/fzhnf/Public/forum-api/node_modules/@poppinss/middleware/src/runner.ts",
            "isApp": false,
            "isModule": true,
            "isNative": false,
            "line": 109
        },
        {
            "callee": "next",
            "calleeShort": "next",
            "column": 12,
            "context": {},
            "file": "node_modules/@poppinss/middleware/src/runner.ts",
            "filePath": "/home/fzhnf/Public/forum-api/node_modules/@poppinss/middleware/src/runner.ts",
            "isApp": false,
            "isModule": true,
            "isNative": false,
            "line": 26
        },
        {
            "callee": "CorsMiddleware.handle",
            "calleeShort": "handle",
            "column": 14,
            "context": {},
            "file": "node_modules/@adonisjs/cors/src/cors_middleware.ts",
            "filePath": "/home/fzhnf/Public/forum-api/node_modules/@adonisjs/cors/src/cors_middleware.ts",
            "isApp": false,
            "isModule": true,
            "isNative": false,
            "line": 260
        },
        {
            "callee": "ContainerResolver.call",
            "calleeShort": "call",
            "column": 18,
            "context": {},
            "file": "node_modules/@adonisjs/fold/src/resolver.ts",
            "filePath": "/home/fzhnf/Public/forum-api/node_modules/@adonisjs/fold/src/resolver.ts",
            "isApp": false,
            "isModule": true,
            "isNative": false,
            "line": 491
        }
    ],
    "message": "Cannot DELETE:/api/threads/1",
    "name": "Exception",
    "status": 404
}

routes.ts

router
  .group(() => {
    ...
    router
      .put('/threads/:id', [ThreadController, 'update'])
      .as('threads.update')
      .use(middleware.auth())
    router
      .delete('/treads/:id', [ThreadController, 'destroy'])
      .as('threads.destroy')
      .use(middleware.auth())
    ...
  })
  .prefix('/api')

Thread table

export default class extends BaseSchema {
  protected tableName = 'threads'

  async up() {
    this.schema.createTable(this.tableName, (table) => {
      table.increments('id')
      table
        .integer('user_id')
        .unsigned()
        .references('id')
        .inTable('users')
        .notNullable()
        .onDelete('CASCADE')
      table
        .integer('category_id')
        .unsigned()
        .references('id')
        .inTable('categories')
        .onDelete('SET NULL')
      table.string('title').notNullable()
      table.text('content').notNullable()

      table.timestamp('created_at')
      table.timestamp('updated_at')
    })
  }
  async down() {
    this.schema.dropTable(this.tableName)
  }
}

Thread controller

export default class ThreadController {
  ...
  async update({ params, auth, request, response }: HttpContext) {
    try {
      const thread = await Thread.findOrFail(params.id)

      if (auth.user?.id !== thread.userId) {
        return response.status(401).json({
          message: 'Unauthorized to update this thread',
        })
      }

      const validateData = await request.validateUsing(updateThreadValidator)
      await thread.merge(validateData).save()

      await thread?.load('category')
      await thread?.load('user')

      return response.status(200).json({
        message: 'Thread updated successfully',
        data: thread,
      })
    } catch (error) {
      return response.status(400).json({
        message: error.message,
      })
    }
  }
  async destroy({ params, auth, response }: HttpContext) {
    try {
      const thread = await Thread.findOrFail(params.id)

      if (auth.user?.id !== thread.userId) {
        return response.status(401).json({
          message: 'Unauthorized to update this thread',
        })
      }

      await thread.delete()
      return response.status(200).json({
        message: 'Thread deleted successfully',
      })
    } catch (error) {
      return response.status(500).json({
        error: error,
      })
    }
  ...
  }
}

response:

even though i configuring route and controller mostly the same, somehow i can update the data but can't delete it

[fzhnf]

branch: https://github.com/fzhnf/api-endpoint-adonis/tree/feature/delete-tread
i make a branch for this problem with the latest commit where i can reproduce the problem, here is the step :
2. run node ace migration:refresh
3. create at least two user using http method, don't directly seed or create it into db because it cannot be use for register and login (that's my problem for another day)
4. run node ace db:seed
5. run http method to delete the thread using auth token for the user that has the id equal to thread's `user_id

[fzhnf]

no way, it just a typo guys, lol

i can't see it for a whole day because there is no linting error or hint what so ever, because the routes is defined with string, now i can delete from database

-       .delete('/treads/:id', [ThreadController, 'destroy'])
+      .delete('/threads/:id', [ThreadController, 'destroy'])