no userfiled in notes after mysql upgrade

[honky]

Hello Sugar-Community,

we are using Sugar CE 6.1.4 (Build 5822) and upgraded MySQL 5.1.30 --> 5.5.14.

After that the upgrade, notes of customers, leads... shows a blank assigned user field. i looked in the table "notes" but the fields modified_user_id and created_by are correct.

We are use user rolles very often so we have a big problem. User who can only show/edit their own notes now can't handle with their own notes.

Apache log show that:

[Wed Aug 03 11:55:01 2011] [error] [client 1.1.1.1 PHP Notice: Undefined index: user_id in E:\\WebServer\\Apache\\Apache2.2\\htdocs\\sugar\\m odules\\Calls\\CallFormBase.php on line 363, referer: http://1.1.1.1:2222/index.php?module...tionship=calls

Yours Sincerly

Honky

/EDIT Upgrading to the latest Sugar-crm version didn't solve the problem

[rafael.q.g@hotmail.com]

Do you still have a backup of your database before run this update?
I think you could try add the column related to the assigned user id in your new table, and then fill it based in your backup.

If there is no backup you could set this column value based on the created_by or modified_user_id by columns.

[honky]

hi, thanks, but it looks like the tables are correct. Same content bevor and after mysql upgrade.

[honky]

hi, i testet the problem with an recoverd mysql installation incl. the old db and the assigned userfield notes in the webinterface is empty.