Successfully Imported 3813 Accounts; 0 Appear

[machineghost]

So after much massaging of SalesForce export data I finally managed to get all of my company's accounts in to Sugar. Or at least I thought I did; the import tool said everything was successful, and my database is full of records in the accounts table.

However, when I actually go to the accounts tab, not a single account appears. I've tried searching for accounts that I know exist, clearing the form to make sure I didn't have some non-matching criteria, etc. but with no luck.

Can anyone help? This is really putting a crimp in our Sugar plans

[kinshibuya]

Hi!
how did you do this import? by the import tool?
we also had this problem some time ago.
On the data base there were a field missing!!
have you repaird you database after the import?
What does your apache and mysql logs says?

[machineghost]

how did you do this import? by the import tool?

Yes

have you repaird you database after the import?

Yes; it didn't help

What does your apache and mysql logs says?

Lots of things

Seriously, there's a lot in the logs, but no obvious giant error messages, so I'm not quite sure what I should be looking for. Moreover, I wouldn't really expect to find anything abnormal in the mysql logs, because as I said all of the records from my import are there in the accounts table of the DB.

Thank you for the suggestions though.

[machineghost]

By the way, I probably should have mentioned that this was a "Create and Update" import; I had already done an initial "Create" import with some of the columns missing, and this import was supposed to fix all of the records to have the missing columns (also I think some records got left out of the initial import, so those were supposed to be added in this import as well).

[machineghost]

Alternatively, if anyone can just explain to me how I can safely wipe all of our accounts out of the DB, that would be awesome, as I could simply wipe the existing accounts then do a create-only import from scratch.

I would just run this SQL:
delete from accounts;
but I'm not sure what other tables I need to clean up, and I don't want to leave a bunch of junk in my DB that will later come back to haunt us..

[Danielg42]

As long as nothing has been related to the accounts, there will only be entries in the accounts table.
If you assigned opportunities or cases to the accounts, then there will be entries in their respective accounts_modulename table, which you can also delete.

[machineghost]

Unfortunately I also imported opportunities and contacts, and they seem to have connected themselves to accounts. However, I can always wipe them too, and start all over from scratch; since Sugar support hasn't gotten back to me yet, I might as well try that ...

Thanks for the info.

[machineghost]

So I tried wiping everything and re-importing, and ... nothing. So then I wiped again, and this time tried creating an account by hand, and ... nothing. Well, it worked, and if I click "Back" I can get to the account, but if I click on the Accounts tab it's nowhere to be seen (or searched for).

So I guess my problem is just that my accounts page won't show any of my accounts ... how the heck does that even happen? *sigh*

And it's not like my database isn't working or something; all of the other modules seem fine.

[machineghost]

BTW, I have not messed with the PHP files or anything like that. The only things I've done that I can think of which might somehow be responsible are:

1) I created and deployed (then deleted, re-created, etc. several times until I got it right) a custom module, which had a relationship to accounts.

2) I added 9 custom fields to accounts (all using the studio tool in the admin).

However, I've done every repair option in the admin, and besides both of these are built-in features which shouldn't cause damage that requires repairing anyway ... right?