Delete Softr users when stored in mysql

Data Sources
1

Hi,
I am having the Softr Users linked to my MySQL DB.
User creation is working great in both ways.
I have a questions about “deleting a users”. When I delete a user using Softr UI, is it supposed to be deleted from the MySQL DB as well?

In my case,

  • When I delete a user using Softr UI, it is not deleted from MySQL DB. In fact, it is recreated in Softr during the next sync.
  • When I delete a user from the MySQL DB, it is not deleted from the Softr UI. In fact, it is recreated in mysql during the next sync.

So it seems that the only way to delete a user is to delete it from both (UI and MySQL) at the same time.

Is this normal?

1 Like
2

Hey @afeno, thanks a lot for reaching out, yes whenever you delete a user from the Softr UI they must be deleted from the data source as well, is that not happening in your case?

best,

3

No @Andranik . It is not happening. The user remains in the MySQL DB Table.

And as it is still in the MySQL Table, it is recreated again in Softr during the next sync.

4

Got it, thanks a lot for confirming, we will indeed investigate this, would you mind DM me a screenshot of how the table looks like on MySql where the column types appear?
Also feel free to add Support@softr.io as a collaborator to your app.

Best regards,

5

Done.
I sent you the screenshot of table structure.
I added Support@softr.io as collaborator
I sent you the App url.

You can add/delete users. It is a dummy App.

6

Thanks a lot @afeno ! we will keep you posted!

7

@afeno will be fixed in 30 mins we had a bug causing this issue

2 Likes