Question & Answer > View Question

Error - Unknown column 'app_fd_tbl0_.c_field117' in 'field list'

Confluence User - 04 Apr, 2018

Hello,

I'm creating a new form which is rather extensive and I get this error whenever I reach a specific number of fields. That is, if I remove a field, the error is eliminated. However, if I add a new field, the error returns once again.

What is the cause of this error? Is there any method to eliminate it without compromising my needs of keeping everything in a unique form?

Thank you for your attention.

PS: I'm using the most basic version and my programming knowledge is narrow.

forms;datalists

2

Confluence User •

04 Apr, 2018 •

confluenceUser •

•

confluenceUser •

Hello, you can make a 'drop' of the table of the database and at execution time, joget reconstructs it.

Or, you can make an 'alter table' by adding the app_fd_c_field that is presenting the error. What DB are you using? can you share the project?

Confluence User •

05 Apr, 2018 •

confluenceUser •

•

confluenceUser •

Hi, I think some database has limit in the max number of columns and Joget does not delete the column in database when you delete a field in form to prevent data loss. So, you may need to clean your database to remove column you do not need. Or you break your form to several subforms to store in multiple tables.

1

CSV | Excel | XML | PDF

Your answer

Print

Error - Unknown column 'app_fd_tbl0_.c_field117' in 'field list'

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-637d565a-2051-4d95-9aec-1aec1047e066{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-dab8a785-e15c-4bab-ac06-0f9340b20855{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer