You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jun 14, 2024. It is now read-only.
Expected to be able to click on my table in Forest Admin and see the contents of the table.
Actual behavior
Having the message "Oops, something went wrong".
Failure Logs
[forest] 🌳🌳🌳 Unexpected error: column ratings.criteria0_grade does not exist
SequelizeDatabaseError: column ratings.criteria0_grade does not exist
Context
I have a table named ratings having several columns named like this: criteria_0_grade, criteria_1_grade, etc... For an unknown reason, Lumber seems to map these columns to criteria0_grade triggering a column ratings.criteria0_grade does not exist error. The problem seems to exist only with the two columns name criteria_0_*.
In models/ratings.js, only the columns with a 0 does not have a field field:
The text was updated successfully, but these errors were encountered:
DeadEye0112
changed the title
Column name with a number generate an invalid column name in query
Column name with a 0 generate an invalid column name in query
Dec 30, 2019
Hi @DeadEye0112,
Thanks for your feedback.
It definitely looks like a bug.
As a workaround could you edit your criteria0Grade and criteria0Comment fields, like this:
criteria0Grade: {type: DataTypes.INTEGER,field: 'criteria_0_grade'// define the name of your table column},criteria0Comment: {type: DataTypes.STRING,field: 'criteria_0_comment'// define the name of your table column},
Expected behavior
Expected to be able to click on my table in Forest Admin and see the contents of the table.
Actual behavior
Having the message "Oops, something went wrong".
Failure Logs
Context
I have a table named
ratings
having several columns named like this:criteria_0_grade
,criteria_1_grade
, etc... For an unknown reason, Lumber seems to map these columns tocriteria0_grade
triggering acolumn ratings.criteria0_grade does not exist
error. The problem seems to exist only with the two columns namecriteria_0_*
.In
models/ratings.js
, only the columns with a 0 does not have afield
field:Thanks for you help!
The text was updated successfully, but these errors were encountered: