Duplicate Account Entries That Don't Actually Exist

💬 General Discussion
1

Hello All,

First time poster here, I’ve tried to research this problem but came up empty so I am hoping to find some help here. I am running SuiteCRM version 7.11.13 on an Ubuntu Apache server running php 7.2 . Well within the system requirements of SuiteCRM.

The problem I am having is that I am seeing duplicate entries in the accounts module for accounts that I have imported. The csv file that I used to import had no duplicates, duplicate checkers aren’t finding any duplicates, and when I click on duplicates and go to merge them the system returns an error saying that I need to select two different accounts.

Weirder still is that when I log a call, meeting or whatever, in one of the duplicates; it shows up in the other. Whenever I delete one of the duplicates, they both get deleted.

So basically the system is showing duplicate accounts but treating them all like one. And when I go to assign calls/meetings to accounts I don’t see any duplicates in the pop-up window when choosing the account to assign to the call/meeting.

The issue only exists on the view accounts page.

I’m hoping anyone here knows what to do in this situation.

Thank you all for you time.

2

I’d say the problem is in the relationship tables, are you technical enough to go look in the database with phpMyAdmin?

I think you’ll find that you don’t have duplicate Accounts, but you do have two relationships to each.

This is anomalous and I’ve never heard of such a bug in the Importer…

Try a few repairs from Admin / Repairs. The QR&R and relationships repair.

3

Thanks for the direction on where to look. I’ll check phpmyadmin and run the quick repair and rebuild. I’ll let you know what happens.

1 Like
4

Update: It was my fault. I tried uploading manually in phpmyadmin and got a ton of errors from duplicate IDs. The database csv I was trying to import was trash. I give credit to the SuiteCRM importer. It was a trooper and really tried to get everything working and organized as best it could. I just spent the last two days cleaning everything up and now its working perfectly. Just to be safe I still imported all the accounts through phpmyadmin (after deleting all the old data from the tables).

1 Like