Error in user table. How to remove a custom column?

User Service
1

I have added a new Column named “TamanID” to the system users table. I want to remove it now. But the system always throws an error - " Unknown column ‘udt.Users.TamanID’ in ‘field-list’ "
Not able to use data browser to add users to this table too.
My appID is “189D40FE-BD8B-28F3-FFE9-5F33C51B1100”
This custom column data type is ‘string_id’. Not sure how I ended up in this mess!
Please help. I have purchased a shortcut to the Springboard plan for this app.

Is it okay to add custom columns to the system user table?

Screenshot 2021-07-08 at 9.35.06 AM
Screenshot 2021-07-08 at 9.35.06 AM339×544 27.2 KB

Screenshot 2021-07-08 at 9.43.03 AM
Screenshot 2021-07-08 at 9.43.03 AM1119×191 20.5 KB

Screenshot 2021-07-08 at 9.43.11 AM
Screenshot 2021-07-08 at 9.43.11 AM929×215 16 KB

2

Hello @cyber_sight_digital

Welcome to our community and thank you for trying out Backendless.

Removed.

Yes, it is ok.

I do not yet know what led to this situation.
If you have a similar problem again, please describe, if possible, more detailed steps to reproduce.

It should work fine now, please check.

1 Like
3

Hi I have the same issue here. I want to remove/update/use the ‘firstname’ column I’ve added to the user table. but I get the same error : “java.sql.SQLSyntaxErrorException: Unknown column ‘udt.Users.firstName’ in ‘field list’”

my ID is F5C774D6-4034-0B28-FF26-25C18656D400

4

please remove the column if possible.

5

Hi Noah,

I cannot find an application with the following ID:

Please double-check and let us know the correct app id.

Regards,
Mark

6

Apologies. That was the error case ID or something like that. the project ID is:

DD9FC30D-3A6F-AB4C-FF9C-24DC92E73100

7

Thank you for your response.

8

Thank you. I created an internal ticket BKNDLSS-30059 for the devops team to delete the column.

Regards,
Mark

9

Awesome. I really appreciate your timely response.

10

Hello @Noah_Caldwell, we have removed the column, please check you application

11

Yes it is gone. Thanks for the resolution.

12

I have a similar problem.

I can not delete a column. I can not modify the column.

I have recorded a video to show you the issue.

Video of issue
https://www.awesomescreenshot.com/video/17198872?key=a77a42b1f5468028cf7abf4e9764c459

13

Hello @Jim_Spark

This topic has already been resolved and closed. Please create a new topic and specify your APP ID.

Regards,
Inna