Cannot add or update a child row: a foreign key constraint fails

Help me!
6

Hi @Cyril_Limam,

I pushed your issue to our product team but unfortunately, I cannot commit on any potential release date for now.

As for the workaround, here are the 7 steps to follow:

Disclaimer: For this example I used countries and addresses as the table and model names you defined and country_iso as the field name in DB. Feel free to replace those with the one you are using if needed.This workaround is crafted to allow creation and edition of the countryIso field on addresses table. However the country iso field won’t be displayed as link anymore on the addresses collection.

1 - Manually add field

2 - Remove belongsTo association from the models/addresses file and the hasMany association from the models/countries.js file

3 - Add the following get route on the routes/countries.js file:

router.get('/countries-iso', permissionMiddlewareCreator.list(), async (request, response, next) => {
  const allCountries = await countries.findAll({ attributes: ['iso'], order: [['iso', 'ASC']], });
  const data = allCountries.map(country => country.iso);
  response.send({ data });
});

3b - Restart your server

4 - Go to the isoCountry field settings

5 - Define the edit widget to Dropdown then click dynamic and add /forest/countries-iso as Dataset URL

6 - Hitting the verify button should display a list of iso looking like this:

{
  "data": [
    "FR",
    "IT",
    "UK",
    "US"
  ]
}

7 - You can now close the panel and hit the save button on the right

Feel free to come back on this post if you have any questions or issue with the workaround.

Best regards

2 Likes