The data is mixed up

[S0meone78]

Hi,

Sometimes when I go through my day to day tasks, the email field is showing the entry from another account. The same behavior occured with the phone number. I can easily detect it because the domain name doesnt match the client account but when its related to the phone number, it becomes kinda hard to track.

Is it related to the database or have anyone seen this before ?

Any tips on solving this situation ?

Running : Version 4.5.0c (Build 1155)

Thanks for the help.

^Someone

[Angel]

Have you confirmed whether or not the records have the correct data within the database itself?

Meaning, if you stumble upon a record that is not displaying the correct value while working with Sugar, does it display the same incorrect value for the same field if you were to look at the MySQL database using phpMyAdmin or other MySQL admin tool.

If not, then it sounds like you may have a corrupt index. You could try re-index and hopefully that will correct it.

If it does show the same erroneous info, then you have to do some more investigation to determine how it got in there. It is possible that someone made a mistake, in which case, there is nothing wrong with the system. It is also possible that there is some corruption within your database and some data got shifted around as a result.

Have you had any problems with your server crashing recently?

[S0meone78]

Not really, the data I see is from another record. I mostly see this kind of issue when I have nothing in the field. The server is brand new so it may be a problem with the database. How do I make sure the index is ok ? Is there any command line I can run to fix it ?

Thanks.

Have you confirmed whether or not the records have the correct data within the database itself?

Meaning, if you stumble upon a record that is not displaying the correct value while working with Sugar, does it display the same incorrect value for the same field if you were to look at the MySQL database using phpMyAdmin or other MySQL admin tool.

If not, then it sounds like you may have a corrupt index. You could try re-index and hopefully that will correct it.

If it does show the same erroneous info, then you have to do some more investigation to determine how it got in there. It is possible that someone made a mistake, in which case, there is nothing wrong with the system. It is also possible that there is some corruption within your database and some data got shifted around as a result.

Have you had any problems with your server crashing recently?

[andydreisch]

Hi S0meone78, this is very odd. Please confirm that the screen in which you're seeing this issue is the Contact ListView screen (something like the picture below).

Was there a data import or did you create these records yourself? How many Contacts exhibit this behavior? For a Contact that does exhibit the behavior, can you ensure that the Contact belongs to just one Account?

Andy

[S0meone78]

Not really, we usually see this issue in the Tasks section. When we open the tasks sometimes the phone and email field is not showing the correct account.

All the contacts belong to only one account.

The database has been used locally and then transfered on the server using the SQL engine. I think the import may have caused some problems during the process.

What is the best way to export the data, then use a clean database and re-import my data ?

The admin used a database dump and reimported the data .

Thanks for the help.

[Angel]

It is possible to do an export/import to move the data over, but unless you do it through Sugar, you'll create more work for yourself as you'll need to then link data to the accounts manually.

Doing it through phpMyAdmin or other MySQL admin tool would save you that trouble. The general principle being, export the data from all the tables on the source system, move the export files to a location accessible by the new server, then simply do an import of those files on the new server.

Although, it is a bit disturbing that an sql dump didn't work for you. I'd investigate that a bit further. You don't want to find out that a restore of a backup corrupts your data after you've entered 6 months worth of data.

[S0meone78]

I just found out where I get this issue. Usually I use the Tasks Dashlet on the Home page and I click on a specific task. When I get into the task, I see the number of tasks I created from 1 to XX. If the tasks is #2 in the list and I dont have any information in the email or phone number section, Sugar automaticaly use the data from my Client Account #2.

That's why Im getting wrong data.. But if I go directly into my account then I select my task, everything is OK.

Why does Sugar behaves that way ? When I'm in the tasks section, if I go back to the previous task then come back, I dont get the same tasks I had 1st when I used the link from my Home Page..

Any ideas ?

Thanks.

It is possible to do an export/import to move the data over, but unless you do it through Sugar, you'll create more work for yourself as you'll need to then link data to the accounts manually.

Doing it through phpMyAdmin or other MySQL admin tool would save you that trouble. The general principle being, export the data from all the tables on the source system, move the export files to a location accessible by the new server, then simply do an import of those files on the new server.

Although, it is a bit disturbing that an sql dump didn't work for you. I'd investigate that a bit further. You don't want to find out that a restore of a backup corrupts your data after you've entered 6 months worth of data.

[Vetal]

I've got the same problem. Version 4.5.1 (Build 1197)
I beleive this is a bug.
Now I'm going through the code to find out the bug..