Feature(s) impacted CRUD operation on a collection Observed behavior When I click on my Workspace collection I get the following error. [Capture d’écran 2022-09-04 à 21.50.40] Note: It seem to be caused by a self reference relationship: a workspace can have a template (which is also a workspa…

We just triggered a release Hopefully the following versions should get rid of the issue @forestadmin/datasource-sql@1.0.0-beta.48 @forestadmin/agent@1.0.0-beta.55

Hey @anon75040465 :wave: I’m not able to start a project as well using the CREATE TABLE you provided with a datasource-sql, so I’ll file a ticket on our end. Be sure we will ping you here once fixed :+1:

@anon39848301 Thank you for your quick response ! Do you have an ETA for the resolution? Is it possible to get the link to the bug report? While you fix the problem, is there any way to fix this on my side? Removing the constraint is not really an option because it’s need by my ORM (prisma) to cr…

Sadly, the issue happens at the introspection level - before the agent even start. AFAIK (I wait for the tech-team to check whether or not that’s true), there are no obvious way to workaround this issue at the moment. We usually don’t give ETA on bug fixes, but be sure that it is already dispatched…

[image] anon39848301: introspection The same issue here: [image] Unexpected error on opening a collection record Help me! @anon34731316 It seems so, Leonard! We also have a self-relation in this entity. Have you found any solution for that?

refactor: clean up datasource-sql code ForestAdmin:beta ← ForestAdmin:fix/datasource-sql opened 02:27PM - 06 Sep 22 UTC (UTC) [romain-gilliotte] romain-gilliotte …

Hi @anon39940173 , Thank you for your work ! :pray: I saw that this PR was released as @forestadmin/agent@1.0.0-beta.54 and @forestadmin/datasource-sql@1.0.0-beta.47. Unfortunately, I still get the same error: table name "Workspace" specified more than once Error: at Query.run (/Users/leon…

Seriously? :sob::sob: Can you send me information about the structure of the tables involved in the failing request? A couple of create table statements that I can run on a local database would be best, but I would settle with anything that enables me to replicate the issue.

Wait no, there is still hope! I just checked and the fix was NOT released. I tagged my commit as “refactoring” so the build-bot did not release a new version the fix should be live the next time we commit anything else

It’s working :tada: Thank you @anon39940173 !!

Self relation is breaking the collection

Help me!

bond September 5, 2022, 4:41pm 6

The same issue here:

Topic		Replies	Views
Unexpected error on opening a collection record Help me! typescript	8	580	September 8, 2022
How to relate and see data in "Related Data" tab in forest admin Help me!	23	607	March 6, 2023
Failing: reading 'foreignCollection' Help me!	34	698	October 14, 2024
External relation with reference on a collection Help me!	7	515	February 2, 2023
Forest new agent - relationship error between my tables after a forest schema:apply Help me! howtos , setup	20	409	February 29, 2024

Self relation is breaking the collection

Related topics