Error Error following the linking of tables (relationships)

[Carmel558]

Hi all
Please help me to resolve this problem.
I created a Product class which has several positions
final position, initial position and current position.
Now I connected the table to the product table with belong to. As in the code I defined the positions by calling the Position table at each level.

This does not generate an error that I cannot manage.

Please help me

Here is the produt level code

export default class Produit extends BaseModel {
  @column({ isPrimary: true })
  declare id: number

  @column()
  declare codeProduit: string

  @column()
  declare startPositionId: number

  @belongsTo(() => Position)
  declare startPosition: BelongsTo<typeof Position>

  @column()
  declare currentPositionId: number

  @belongsTo(() => Position)
  declare currentPosition: BelongsTo<typeof Position>

  @column()
  declare finalPositionId: number

  @belongsTo(() => Position)
  declare finalPosition: BelongsTo<typeof Position>

  @column()
  declare validationDestination: boolean | false

  @column()
  declare statut: boolean | true

  @column.dateTime({ autoCreate: true })
  declare createdAt: DateTime

  @column.dateTime({ autoCreate: true, autoUpdate: true })
  declare updatedAt: DateTime
}

Here is the error

> Exception: "Produit.currentPosition" expects "positionId" to exist on "Produit" model, but is missing
    at file:///C:/Users/Carmel%20dev/Data/Adonisjs/track-api/node_modules/@adonisjs/lucid/build/src/orm/relations/keys_extractor.js:32:23
    at Array.reduce (<anonymous>)
    at KeysExtractor.extract (file:///C:/Users/Carmel%20dev/Data/Adonisjs/track-api/node_modules/@adonisjs/lucid/build/src/orm/relations/keys_extractor.js:28:39)
    at BelongsTo.boot (file:///C:/Users/Carmel%20dev/Data/Adonisjs/track-api/node_modules/@adonisjs/lucid/build/src/orm/relations/belongs_to/index.js:84:12)
    at Preloader.load (file:///C:/Users/Carmel%20dev/Data/Adonisjs/track-api/node_modules/@adonisjs/lucid/build/src/orm/preloader/index.js:84:18)
    at Proxy.load (file:///C:/Users/Carmel%20dev/Data/Adonisjs/track-api/node_modules/@adonisjs/lucid/build/src/orm/base_model/index.js:1305:23)
    at ProduitService.findOne (C:\Users\Carmel dev\Data\Adonisjs\track-api\app\services\produit_service.ts:36:22)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at ProduitController.show (C:\Users\Carmel dev\Data\Adonisjs\track-api\app\controllers\produits_controller.ts:39:20)
    at SessionMiddleware.handle (C:\Users\Carmel dev\Data\Adonisjs\track-api\node_modules\@adonisjs\session\src\session_middleware.ts:81:22) {
  status: 500,
  code: 'E_MISSING_MODEL_ATTRIBUTE'
}

[Carmel558]

[RomainLanz]

Do you know that when you ping us like that, I just want to close and lock this discussion?

If you want fast support, feel free to reach out for our support plan. Otherwise, wait like everyone else.