Open Closed

Error while migrating DB after change the table prefixes #3972


User avatar
0
catalin.cernat@relevance.ro created
  • ABP Framework version: v6.0.1
  • UI type: Blazor
  • DB provider: EF Core /
  • Tiered (MVC) or Identity Server Separated (Angular): no
  • Exception message and stack trace:
  • System.InvalidOperationException: Cannot use table 'MHUUsers' for entity type 'ChatUser' since it is being used for entity type 'IdentityUser' and potentially other entity types, but there is no linking relationship. Add a foreign key to 'ChatUser' on the primary key properties and pointing to the primary key on another entity type mapped to 'MHUUsers'.
  • Steps to reproduce the issue: Create a new solution with ABP Suite, install chat module, add table prefixes for identity / chat etc, add migration.

This question counts towards the assigned total questions per license? Because it seems like a bug, and not a support question.

Tks.


1 Answer(s)
  • User Avatar
    0
    catalin.cernat@relevance.ro created

    Well, it seems that setting the DbTablePrefix for Chat module will actually create a conflict with Users tables, as both will have the same names.

    I think it should behave in some other ways, maybe add DbTablePrefix + ChatUsers to avoid conflict.

    Anyway, I got rid of the table prefixing of chat module and it works. Will wait for a fix and try again.

Boost Your Development
ABP Live Training
Packages
See Trainings
Mastering ABP Framework Book
The Official Guide
Mastering
ABP Framework
Learn More
Mastering ABP Framework Book
Made with ❤️ on ABP v10.0.0-preview. Updated on June 20, 2025, 11:20