search

pimcore / pimcore

Core Framework for the Open Source Data & Experience Management Platform (PIM, MDM, CDP, DAM, DXP/CMS & Digital Commerce)
http://www.pimcore.com
Other
3.39k stars 1.43k forks source link

[Bug]: Relation Visible in Pimcore UI but Missing in Database Table object_relation_<class_id> #17576

Open abdelrhmanyosry opened 1 month ago

abdelrhmanyosry commented 1 month ago

Pimcore version

11

Steps to reproduce

There appears to be a discrepancy between the relations shown in the Pimcore UI and the actual records in the database. Specifically, a relation between objects is visible in the Pimcore backend, but upon checking the corresponding database table (objectrelation), the relation does not exist.

image image image

Actual Behavior

There is a wrong value in this attribute.

Expected Behavior

the value for this attribute should be empty

Cruiser13 commented 1 month ago

+1 with this issue in pimcore v11.3.1 Object showed an existing many-to-many object relation but database row has been null. Object List condition 'activeChannels IS NOT NULL' did not include the object therefor.

Deleting the relation via pimcore admin and re-assigning the related object fixed the issue, database showed ,57, correctly afterwards.

We have ~20.000 objects of the same type and only ~10 showed this error.

abdelrhmanyosry commented 1 month ago

@Cruiser13 i found the issue in my project that was the children inherit relations from parents.

github-actions[bot] commented 2 weeks ago

Thanks a lot for reporting the issue. We did not consider the issue as "Pimcore:Priority", "Pimcore:ToDo" or "Pimcore:Backlog", so we're not going to work on that anytime soon. Please create a pull request to fix the issue if this is a bug report. We'll then review it as quickly as possible. If you're interested in contributing a feature, please contact us first here before creating a pull request. We'll then decide whether we'd accept it or not. Thanks for your understanding.