Lost all my Accounts (sort of)

[pierreavista]

Hi all,
In 4.5.1 I was working in Studio (in the Accounts module) today to clean up, add and delete some custom fields.
I was struggling to get new fields to display in list view and old ones to disappear and I decided to go and delete a custom field I no longer needed. It was deleted fine...

But now I have a big problem...
When I go back to the Accounts module, the list comes up empty !!! All gone !!!
When I search on a specific account name, I get no results at all...

When I go to Contacts, I click on one of them and in the view window I can click on an Account name and it is displayed there perfectly.

But, I still cannot get them to show up in the Accounts list.

I did most repair functions. When I di a repair DB I get hundreds (if not more) errors like this :

* Table : relationships */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - id - ROW [Field] => 'id' [Type] => 'varchar(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
/* VARDEF - id - ROW[Field] => 'id' [Type] => 'char(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
alter table relationships modify column id char(36) NOT NULL
/*INDEXES/*
/* Table : acl_roles */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - id - ROW [Field] => 'id' [Type] => 'varchar(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
/* VARDEF - id - ROW[Field] => 'id' [Type] => 'char(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
alter table acl_roles modify column id char(36) NOT NULL

If anybody has an idea on how to fix this, you help would be greatly appreciated.

Thanks

[M1000S]

I'm in a similar situarion - not with accounts, but with restoring lost fields. I'm afraid to execute the repair function because there are so many entries.

I'd just like to locate the "Description" field from the lead panel and restore it to the edit view. Up till yesterday, it was there and working fine. Now it's gone with no changes that I'm aware of.

....................

So I'm in the repair module as well.............. wondering what it actually will do and afraid that it might destroy what is already working.

Another possibility for "lost" things are traps - like having assigned a user that isn't on the team, or a team that doesn't include a user. If you do that, only the admin list with no search exclusions will turn up the lost accounts, leads, or whatever. There is no warning in sugar when you are about to disassociate user and team for an item - so they can be gone in an eyeblink if you aren't cautious.

Good luck, If I learn anything, I'll let you know.

Mike