Account "Assigned to" field cannot be read back

[laurentzed]

Hello,

I modified multiple times to set the "Assigned to:" from Account record but after saving it, the field remains blank in view mode and getting back in edit mode.
I looked at the records in MySQL and noticed that the "Assigned to" field from the modified account record has been updated accordingly with the user Id I entered.

I am using SugarCRM 5.5.0. It seems the user ID assigned to the account os notr read back.
Please advise.

Thanks

Laurent

[dhaivatnaik]

Hello,

I modified multiple times to set the "Assigned to:" from Account record but after saving it, the field remains blank in view mode and getting back in edit mode.
I looked at the records in MySQL and noticed that the "Assigned to" field from the modified account record has been updated accordingly with the user Id I entered.

I am using SugarCRM 5.5.0. It seems the user ID assigned to the account os notr read back.
Please advise.

Thanks

Laurent

Hi, Laurent

try to repair cache from admin.
Check error logs or sugarcrm.log you might get some hint there is something is wrong.

if it doesnot works then send me the detailviewdefs.php from custom folder if exists, else from main module.

[laurentzed]

I tried repair the Metadata not knowing which repair/rebuild cache you meant.
I have not noticed any change. Account detailed view and edit remain with no "Assigned User" name even if I setup one before saving the account.

I searched through sugarcrm.log but I have not spotted any relevant message.
I have not found any error.log file. Could clarify what folder shoud have contained such a file?

I attached here the Account module from custom folder the detailviewdefs.php and editviewdefs.php as I do not see teh assigned user name either from Detail View or from Edit View.

Do you have an idea of what goes wrong?

Thanks and regards

Laurent

[laurentzed]

Hello,

I give a little more time to it.
I asigned a specific user to an account and save the modified account.
I checked with phpMyAdmion and confirm the assigned userId has been updated in MySql database.
However, neitehr detail view or edit view show it. Only a blank field for "Assigned User" is displayed.

Any idea?

Thanks

Laurent

[leowolff]

Do you have oqc installed? This is a known issue. There is a solution on its forum.

http://www.sugarforge.org/forum/foru...&forum_id=2788

[laurentzed]

Indeed I have the oqc module installed.
Just follw the link you provided and have been able to fix it.
Thank you very much.

Laurent

[getoliverleon]

The solution is in the thread linked above.

I am also posting (Marco's) solution here, to make it easier to find:



I had exactly the same problem of the assigned-to field not showing its content on Detail & Listviews. It "felt" as if it was not saved.

Marco's solution is perfect. Grab the accounts_cstm table and simply kill the column "assigned_user_id". It's empty anyway, not needed and deleting has no negative results.

After that it works just fine. Thanks Marco!