• Jobs
  • About Us
  • Jobs
    • Home
    • Jobs
    • Courses and challenges
  • Businesses
    • Home
    • Post vacancy
    • Our process
    • Pricing
    • Assessments
    • Payroll
    • Blog
    • Sales
    • Salary Calculator

0

157
Views
Error when inserting into relational table many to many

I'm trying to persist relational data in myql database with typeORM and nestjs but it's showing an error apparently in the database

Entity:

  @ManyToMany(()=> Stock, stock => stock.seals)
  @JoinTable()
  stock: Stock[];

Service:

var c = getConnection().getRepository(Seals).save(createSealDto)
     return c 

Error:

ERROR [ExceptionsHandler] Cannot add or update a child row: a foreign key constraint fails (stocksystem.stock_seals_seals, CONSTRAINT FK_70140d58e95fbceed988b224e64 FOREIGN KEY (stockId) REFERENCES stock (id) ON DELETE CASCADE ON UPDATE CASCADE)

Payload:

{"client":{"id":1},"stock":[{"id":1},{"id":1}],"price":398}

over 3 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Our process Sales
Legal
Terms and conditions Privacy policy
© 2025 PeakU Inc. All Rights Reserved.

Andres GPT

Show me some job opportunities
There's an error!