Associations not saving?

Need Help
1

Hii there,

I’m trying to fix a bug where associations are not saving.
In the regular controller, I’m using this piece of code to create the entity and an associated entity:

$entity = $this->Projects->newEntity([
            'name' => $this->request->getData('name'),
            'source' => '#',
            'thumbnail' => '#',
            'license' => '',
            'projects_descriptions' => [
              ['description' => $this->request->getData('description')]
            ]
]);

If I save that, it works fine but now in another class (for my GraphQL API), I use the following code:

  class ProjectDataSource {
    private static $_projectsTable;
    private static $_projectsReleasesTable;

    public function __construct() {
      self::$_projectsTable = TableRegistry::get('Projects');
      self::$_projectsReleasesTable = TableRegistry::get('ProjectsReleases'); 
    }

    public function updateProject($id, array $data = []) {
        // Get the project by the requested it
        $project = self::$_projectsTable
          ->findById($id)
          ->contain([
            'ProjectsDescriptions'
          ])
          ->first();

        // do some checks here...

        // Update the entity
        $project->projects_descriptions[0]->description = $data['description'];

        self::$_projectsTable->save($project)
    }
}

Now the problem is that my $project object looks like this (take note of the description object being marked as dirty!):

image
image.png405×550 27 KB

But saving it doesn’t change it in the database, and the entity is still marked as dirty.

When I also change the $project->name and then save, the name updates but the description still doesn’t.

2

what about accessible ?

3

It’s in there.

image
image.png426×637 30.7 KB

4

in ProjectsDescriptions since you have problem with it

5

There’s nothing really in there :\

image
image.png400×704 33.5 KB

6

try to add id => true, there

7

Added it, tried saving again but nothing :\

image
image.png362×739 34.7 KB

8

Trying to use the “regular” way in the normal controller yields the same issue :\

9

hmm in app.php enable query log check generated query, inspect it and if it looks ok copy it into your manager and check if there are errors

10

I enabled the log and searched for the query… but there is no query that has to do with updating the entity…
I see some SELECT statements that I expect to be there but no UPDATE statements…
When I change the $project->name, I get the following query:

2019-08-26 15:24:43 Debug: duration=0 rows=0 BEGIN
2019-08-26 15:24:43 Debug: duration=13 rows=1 UPDATE projects SET name = '9AnimeDl1' WHERE id = 1
2019-08-26 15:24:43 Debug: duration=0 rows=0 COMMIT

As you can see, it doesn’t update the description even though it’s dirty…

11

ah try setting projects_descriptions in $project as dirty

12

That worked :slight_smile:
Do you by any chance have an idea on why this doesn’t go automatically?
I expected to automatically mark it after I changed the entity…

13

i dont think it ever worked automatically thats why we have $entity->set and $table->patchEntity

1 Like
14

Well… this is awkward… I completely forgot the existence of patchEntity()…

15

Well that same issue occurred with my project. I would find out the issue. Actual problem is if the any of the database column has error or different datatype then data doesn’t not save by entity. if you check each field datatype and database table then you will get. if you don’t mind you can check.:grinning:

16

Well… considering the datatypes for the entity stay the same, no error is being returned and the query just doesn’t even try to update the column in the first place, we could rule out a wrong data type.

17

You’re updating a project_description object directly, the $project variable is merely something that you traverse in read-only fashion to get to it. So there’s no way that $project->dirty will be updated by your change, and hence when you save $project it doesn’t think there’s anything to be done.