Odd data showing up in Opportunities

[etabs]

I have noticed something odd with our install of Sugar Professional (still on 4.5.0h (Build 1239)) when looking at opportunities. On the main screen of the opportunities there is a field called "Modified By" and on the overview page that field shows as something like 1b5745f0-d7ce-8ac0-e2df-458728e28b7a. I am presuming that it should be either the username but it is giving me this string of numbers and letters instead.

Any idea how this happened and what can be done to correct the problem?

Thanks in advance,
Aaron

[roblaus]

Hi,

What you are seeing is an UID, the unique identifier of a record. Without knowing more that leads to two assumptions:

1. Somebody messed with your code and got it all wrong or
2. Your database is partially screwed up

Neither case looks very promising I am afraid.

rgds
rl

[etabs]

Thanks for the reply. Do you think that attempting to repair the Sugar install via the repair tool in the admin section would help?

Aaron

[roblaus]

I don't think so but it won't do any harm if you try it (backup as always recommended!).

If this problem occurs only with opportunities (and you don't have thousands of them) it probably makes sense to have somebody looking directly into the database and get it fixed manually. It's not a big deal because the DB structure is pretty transparent.

rgds
rl

[etabs]

As you suspected Robert, the repair didn't do the trick. I think that since it is only 13 opportunities that are effected, that we can do repair manually. Where and what files should we look at and what data should we put in when manually fixing this issue?

Thanks,
Aaron

[roblaus]

Hi,

I'll give you the relevant fields of the opportunity table. Assuming you have access to phpmyadmin or MYSQLAdministrator.

opportunities:
id (must be unique, do not touch)
date_entered
date_modified
modified_user_id (also an uid, check with user table -> select user_name from users where id = 'the long number you see')
assigned_user_id (same here)
created_by (same here)

If you don't find the user in the users table then somebody deleted the user but did not re-asssign his or her opportunities. In this case either copy the uid of the new user into the respective field (with any SQL tool) or change the user directly on the screen.
Again: If this doesn't help you must have somebody looking into your code or do a fresh install and copy the db over

NEVER FORGET TO BACK UP YOUR DATA BEFORE YOU USE ANY TOOL!!!

rgds
rl