Pivot table update doesn't work

Help me!
, ,
1

Feature(s) impacted

  • relation tables
  • updated entity

Observed behavior

i have a table called giveawayTasks which is a pivot table between giveaways, and tasks tables
this table has giveaway_id, and task_id to connect the other ends, also it has another column which is called order, which allows you to change the order of tasks in a giveaway
when I try to update the order field, it says that the operation was successful, but it doesn’t save it in the database, it also shows on the collection that it is stored, but with one refresh the changes will be gone.

update message:

image
image1478×454 17.2 KB

update log:

image
image1853×70 17.4 KB

after refresh:

image
image1239×292 12 KB

Expected behavior

update the value of the field

Failure Logs

Context

  • Project name: Merit circle
  • Team name: operations
  • Environment name: all
2

Hi @Reza_Erami,

Could you please share the payload that is sent to your backend when saving :pray: ?
I will also need you agent type and version please (forest-express-sequelize@7.1.3, forest-rails@3.2.0, etc…)

3

this is what I get in browser network console
image

as you see in the attributes is empty, even I changed the value of the field

also on the server console it’s empty

image
image1133×237 13.9 KB

4

Is Order a simple number field ? It’s not a relationship right ?
Could you share a video where you edit that field and show the payload sent :pray: ? And also check if there is any error in your web console :pray:

5

yep sure
here it is

and just to let you know, it’s not read-only field

image
image1323×812 42.9 KB

6

another issue that i see is it’s not showing order field at all
as you see in the database I have these values

image
image872×193 22.8 KB

but in forest admin it’s empty

image
image1130×366 46.2 KB

and the query on the console doesn’t contain order field

image
image1858×180 39.7 KB

7

Hi @Reza_Erami ,

I do not see the order in your schema, can you double-check ?
If it is missing, you can redo the schema with forest schema:update. If it does not update correctly, try forest schema:update -o tmp which gonna create you a second folder with the schema recreated, you will be able to move the schema from giveawayTasks.

8

it’s already in the schema, otherwise, it wouldn’t show it on the collection
besides, I regenerated this model multiple times, it didn’t help

image
image639×668 38 KB

9

Hi,

  1. Can you confirm me the exact project name ?
    I can see many Merit circle, with different terminology, in kebab-case, with an uppercase, without, etc.
  2. Do you have a specific environment that has the problem and that I can take look at.
  3. In some project, you have giveaway_tasks and giveawayTasks. Which one is the collection that you use and that have the problem ?
  4. Can you send me the model file (in the folder models) of the specific collection ? You can send me privately if you don’t want to send it publicly.

Best regards,

Shohan

1 Like