[Bug]: Can't Create Brain

[UsmanJavaid777]

[Bug]: Can't Create Brain

[dosubot]

🤖

The error you're encountering, "Error while creating the brain" with a 'PGRST200' code indicating no relationship found between 'brains_users' and 'brains' in the schema cache, is likely due to a missing or incorrect relationship between these two entities in your database schema.

In the Quivr codebase, the create_new_brain function in brain_routes.py is responsible for creating a new brain. After creating a new brain, it also creates a new brain-user relationship using the create_brain_user function from the BrainUserService.

new_brain = brain_service.create_brain(
    brain=brain,
    user_id=current_user.id,
)
logger.info(f"Creating default brain for user {current_user.id}.")
brain_user_service.create_brain_user(
    user_id=current_user.id,
    brain_id=new_brain.brain_id,
    rights=RoleEnum.Owner,
    is_default_brain=True,
)

If the relationship between 'brains_users' and 'brains' is not properly defined in your database schema, this could lead to the error you're seeing. You should check your database schema to ensure that the relationship between these two entities is correctly defined.

Unfortunately, without the database schema or the implementation details of the BrainUserService and BrainService, I can't provide a more specific solution.

As for the structure of the 'brains_users' and 'brains' tables in the database schema, the 'brains_users' table should have the following structure:

• id (Integer, primary key)
• user_id (Integer, ForeignKey referencing "users.user_id")
• brain_id (Integer, ForeignKey referencing "brains.brain_id")
• rights (String)

And the 'brains' table should have the following structure:

• brain_id (Integer, primary key)
• name (String)

You can find these details in the supabase/seed.sql and backend/models/sqlalchemy_repository.py files in the Quivr repository.

Please verify that your database schema matches this structure and that the foreign key relationships are correctly defined. If the issue persists, please provide more details about your setup, including the version of Quivr you're using, your database setup, and any changes you've made to the codebase.

Sources

• backend/modules/brain/controller/brain_routes.py
• supabase/seed.sql
• backend/models/sqlalchemy_repository.py

---

This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.

Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

If you want to continue the conversation, start your reply with @dosu-bot.

[github-actions]

Thanks for your contributions, we'll be closing this issue as it has gone stale. Feel free to reopen if you'd like to continue the discussion.