2022-03-10 16-20-13
saif sheikh
21Views
2Comments
Solved
database OSUSR error
Question
1-Click Publish
Authentication
Best Practices
Data
Database

Hi Team,
working on a defining the database of a new application where the user can make bookings and view stats of  their scoreboard. This is my current data model but i am encountering an error when i am trying to create a user extension. can anyone help figuring what the issue is . Thanks in advance


0
0
12 Sep
Solution

Saif,

Drag User.ID into UserPlayerExtension, delete the ID from UserPlayerExtension, then go into the advanced settings for the entity and set the User.ID as the primary key.

The create error you're seeing is due to a configuration issue on the userplayer.id which isn't technically needed on a user-extension table. (And is best practice to maintain a 1:1 relationship by using the User.ID as the ID for the extension table as well.


Let us know if you need anything else!

Best,
RAD Manage

See solution in context
1
0
12 Sep
2023-10-21 19-42-11
Tousif Khan
Champion
Solution

Hello

The reason is when you had created this Unser Extension Entity, You have published it the user extension entity by its own Identifier, so if you now make changes to your table it will throw you an error because it is already been created in other systems table as well, so 

If you go to the systems table and check its name you will see,

Other than that use Db cleaner to clear the data, 

The easy way, copy the entity and then delete it, now paste it again and now change its identifier to user identifier it will work.

Hope this helps

Thanks
Tousif Khan


1
0
12 Sep
2023-10-21 19-42-11
Tousif Khan
Champion
Solution

Hello

The reason is when you had created this Unser Extension Entity, You have published it the user extension entity by its own Identifier, so if you now make changes to your table it will throw you an error because it is already been created in other systems table as well, so 

If you go to the systems table and check its name you will see,

Other than that use Db cleaner to clear the data, 

The easy way, copy the entity and then delete it, now paste it again and now change its identifier to user identifier it will work.

Hope this helps

Thanks
Tousif Khan


See solution in context
1
0
12 Sep
Solution

Saif,

Drag User.ID into UserPlayerExtension, delete the ID from UserPlayerExtension, then go into the advanced settings for the entity and set the User.ID as the primary key.

The create error you're seeing is due to a configuration issue on the userplayer.id which isn't technically needed on a user-extension table. (And is best practice to maintain a 1:1 relationship by using the User.ID as the ID for the extension table as well.


Let us know if you need anything else!

Best,
RAD Manage

1
0
12 Sep
2023-10-21 19-42-11
Tousif Khan
Champion
Solution

Hello

The reason is when you had created this Unser Extension Entity, You have published it the user extension entity by its own Identifier, so if you now make changes to your table it will throw you an error because it is already been created in other systems table as well, so 

If you go to the systems table and check its name you will see,

Other than that use Db cleaner to clear the data, 

The easy way, copy the entity and then delete it, now paste it again and now change its identifier to user identifier it will work.

Hope this helps

Thanks
Tousif Khan


1
0
12 Sep
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.