Column "jobs" doesn't exist

English Forum
1

I have an issue when try to select field value.
“Column jobs does not exist”

How to debug/fix it?

Thanks!

2

Check based on the error message. Has the Jobs field been deleted?

3

So it’s not a system field?

5

First of all, please provide your NocoBase version, and did you upgrade recently?

Then you can check the “fields” table in your database, to find if a field named “jobs” exists for “users” collection. Here is the SQL:

select * from fields where name='jobs' and collection_name='users';

If it exist, you can delete it and another field as the SQL below:

DELETE from fields where name='jobs' and collection_name='users';
DELETE from fields where name='users' and collection_name='jobs';
6

Thanks. Yes, I upgraded recently.
Current version is v1.6.5.
I don’t have any fields with name=‘jobs’. And jobs with collectionName=‘users’.

Here is my db structure: noco.sql · GitHub

7

Could you help to provider more informations, like the error logs of server when you meet it in browser?

8
9

Any request logs? I may need to know which resource (collection) you are accessing? Or you can pasts the request information from network panel of browser develop tool.

10

As I understand, the issue was related to permissions. It works now. Thanks