Error 1048: Column 'name' cannot be null

[kaihendry]

curl -X POST \
  https://unit.dev.unee-t.com/create \
  -d '[{ "id": "foobar" }]'
Error 1048: Column 'name' cannot be null

Shouldn't the error message be something along the lines of bad unit name or something?

[franck-boullier]

@kaihendry I need to better understand the test you were trying to do to answer that question...
from what I can infer it seem that you are trying to enter a unit id somewhere...
In which table, what do you use to do that is unclear at this point...

[franck-boullier]

but if this is in a table which requires the name to be provided, then this seems like a legit error message to me...

[franck-boullier]

The information that the API needs to insert in the table 'ut_data_to_create_units' BEFORE calling this SQL script are:

• mefe_unit_id
• mefe_creator_user_id (can be omitted)
• bzfe_creator_user_id
• classification_id (a valid BZ classification) . If none provided from the MEFE, then the default should be '2'.
• unit_name (VARCHAR, maximum 47 character long)
• unit_description_details ((VARCHAR, maximum 500 character long)

[kaihendry]

After our chat, my understand is that the typical error is mefe_unit_id has been not created in ut_data_to_create_units table in advance by MEFE and that's why it fails.

Furthermore unee-t/frontend#237 needs to completed so the data can be entered, so the rest of the script can work. Much like invites already works.

[franck-boullier]

After our chat, my understand is that the typical error is mefe_unit_id has been not created in ut_data_to_create_units table in advance by MEFE and that's why it fails.

That is correct!

Furthermore unee-t/frontend#237 needs to completed so the data can be entered, so the rest of the script can work. Much like invites already works.

That is correct too

[franck-boullier]

Housekeeping: this seems solved to me
@kaihendry feel free to reopen if needed