Error creating task when in "related to:" I select a user

👨‍💻 Development Help
1

I Have a problem with SuiteCrm, when i create a task and in the related to field, i select a User it gives me an error, the record is saved in the database, but i can’t acces that record when i try to edit it or just show it’s details i get an error: Error filling in additional detail fields: Query Failed: SELECT first_name, last_name, assigned_user_id parent_name_owner from users where id = ‘9c9b2274-5420-531d-12ae-56bb66603053’: MySQL error 1054: Unknown column ‘assigned_user_id’ in ‘field list’

there is no field assigned_user_id in the table, should there be one??

2

Can you provide the steps to replicate and also some screen shots?

Thanks,

Will.

3

Sorry for the delay, the steps were:

as you can see i need to relate tasks to Users in this dropdown:

so i added Users in the dropdown parent_type_display in dropdown editor

Then i create a task and in the related to field i can see users so i select it:

but when i save the task i get the error:

The record is saved in the database, but i can’t acces that task when i try to edit it or just show it’s details i get an error: Error filling in additional detail fields: Query Failed: SELECT first_name, last_name, assigned_user_id parent_name_owner from users where id = ‘9c9b2274-5420-531d-12ae-56bb66603053’: MySQL error 1054: Unknown column ‘assigned_user_id’ in ‘field list’

When i create notes or calls or meetings, there is no problems only in tasks