Dynamic relations failing

Using the module Advanced Data Types, I’m trying to build a dynamic relation.
Documentation says to “go to Administration / Entity and press Relationships.” There is no such thing in my setup, but there is Administration / Dynamic Relations. When trying to create one of these relations, it fails with these log entries:

[2025-09-04T08:22:12.913016+00:00] Log.ERROR: Fault to rebuild database schema. Details: There is no column with name 'product_id_left' on table 'dynamic_relation_a01k49x3ag7e8ja9jqp9vqvbxd9'.
[2025-09-04T08:22:12.915586+00:00] Log.ERROR: Display Error: Error while rebuilding database. See log file for details., Code: 500 URL: /api/v1/DynamicRelation

In the underlying PostgreSQL db, there is a relation with id a01k49x3ag7e8ja9jqp9vqvbxd9 in table dynamic_relation, but there is no table called dynamic_relation_a01k49x3ag7e8ja9jqp9vqvbxd9.
I am trying to build a many-to-many relation between products in two classifications. (both source and target being product)

Hello SoerenBech!

  1. Error 500 occurs due to a metadata issue when applying dynamic relations to the same source and target entity. This will be fixed in version 1.2.6 of the Advanced Data Types module.
  2. If you want a static list of products related to a product, you can use links and multiple links. To do so, go to Administration > Entity and select the required entity. In the Fields section, press + and add a field of type ‘link’ or ‘multiple link’.
  3. The Advanced Data Types module documentation is not currently up to date. We are working on updating it.

Thank you for your answer.
I would not prefer a static link, but I might move one of the classifications to a separate entity, if that would solve the issue (different source and target).

@alex.sapko I have now moved the products belonging to a specific classification to their own entity. This enables me to create a classification attribute (different classification) as a Link, that points to this new entity. Still there is no option to select a multilink (many-to-many) classification attribute?

@SoerenBech You have to enable attributes and classifications for the new entity, and then link the ones you need to it.