How do I get "My Emails" folder back?

[dbinky]

So, we started our Sugar implementation recently and wanted to interface it with our exchange server. We set that up and it worked fine, I imported all of my mail from outlook and started playing around. Once we realized that Sugar's email client wasn't quite up to snuff, we decided we'd continue to use Outlook and maybe buy the plugin. So I removed the inbound email account I had set up.

NOW... <sigh> I don't have the root "My Emails" folder anymore, so, I can't view mails that I've sent out from Sugar! How do I get the folder (and sub folders) back so I can view them?

[rshortt]

Hi everyone, I'd just like to say that I'm having the same problem. How the heck do you get these folders back?

Still searching...

-Rob

[ArnaudKleinveld]

I unselected the My Emails folder from one of my account and then they disappeared completely. I mean the list of folders to select was empty.

To fix this I hacked into the folders_subscriptions table by hand. Got the user id from the users table and had a look at another user with the My Email folders still there.

Then I run three inserts like:
insert into folders_subscriptions values (uuid(), '225a370c-75bb-e968-8972-47c3ba0e47b0', 'cd5e0377-1aae-1da5-28b4-47c3b4dc4fe6');

[lizesc]

This worked.

Has this been checked in as a bug? I couldn't find it, but to be truthful it's a bear trying to look at the current email bugs.

All I did was click on "--None--" under "Available User Folders" and it deleted the link to my folders so that I could view them in the email client. I did it again with a test user and the same thing happened, so it is reproducible.

The fix in detail:

I checked the users tables to find the id of a specific user_name.

That gave me the assigned_user_id

Then I went to the folders table did a select * from folders where the dynamic_query="%assigned_user_id_from_above%"

That gave me the folder_id

then did the insert statement

insert into folders_subscriptions values (uuid(), 'folder_id_from_above','assigned_user_id_from_abov e');

YAY it worked.

[DragonflyMaster]

I wonder what would happen if you re-create the same email account.
Or, after selecting -none- in "available user folders" and loosing My emails, you go back in email options and select a user.
Have any of you tried one of these?

[rbrooks]

This worked.

Has this been checked in as a bug? I couldn't find it, but to be truthful it's a bear trying to look at the current email bugs.

All I did was click on "--None--" under "Available User Folders" and it deleted the link to my folders so that I could view them in the email client. I did it again with a test user and the same thing happened, so it is reproducible.

The fix in detail:

I checked the users tables to find the id of a specific user_name.

That gave me the assigned_user_id

Then I went to the folders table did a select * from folders where the dynamic_query="%assigned_user_id_from_above%"

That gave me the folder_id

then did the insert statement

insert into folders_subscriptions values (uuid(), 'folder_id_from_above','assigned_user_id_from_abov e');

YAY it worked.

uuid() is not a valid stored procedure name (or anythning else) in the MSSQL version... you're using MySQL right? Do you know how to perform this same action with MSSQL? I've got all of the folder IDs and the assigned_user_id as described above, but don't have a way to insert into the subscriptions table because I can't gen a new guid field (assuming that's what that is)...

[dbinky]

just a quick note... you don't need the UUID function, really... I was able to do the procedure described above (by lizesc, thanks!)... and though the uuid() stored procedure didn't exist... it's just a GUID field, so, I kinda just made a few GUID's up! *grin* which brought back my folders....

[cyberdude]

OK, I just lost the MY Emails folder. I'm pretty much clueless with using MySQL but the query returns no results when looking for the folder ID.

In PHPmyAdmin I've gone into the 'Users' folder found my user ID and then went to 'folders' table of the sugar db and did query

"SELECT * FROM `folders` WHERE `dynamic_query`="%xxxxxxxx-0000-xxxxxx-xxxxxxxxxxx%"". The result is MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)

If I browse the dynamic_query field I can see my user ID in there but cannot see any reference to folder ids.
Any ideas?

[Nutster]

Okay, my client nuked his folders too, so I created this insert query to rebuild it from within MySQL Query Browser. In the case of my client, he is using MySQL on a linux (Ubuntu) box with the Sugar Suite installed in 'sugarcrm'. Make adjustments as needed for your configuration. I did not feel like typing all those id codes!

INSERT INTO sugarcrm.folders_subscriptions (id, folder_id, assigned_user_id)
SELECT uuid() AS sid, f.id AS fid, u.id AS uid
FROM sugarcrm.users u, sugarcrm.folders f 
WHERE f.created_by = u.id

[harkenman]

can confirm, this solution is working.
I'd suggest to file a bug report for this problem.

This worked.

Has this been checked in as a bug? I couldn't find it, but to be truthful it's a bear trying to look at the current email bugs.

All I did was click on "--None--" under "Available User Folders" and it deleted the link to my folders so that I could view them in the email client. I did it again with a test user and the same thing happened, so it is reproducible.

The fix in detail:

I checked the users tables to find the id of a specific user_name.

That gave me the assigned_user_id

Then I went to the folders table did a select * from folders where the dynamic_query="%assigned_user_id_from_above%"

That gave me the folder_id

then did the insert statement

insert into folders_subscriptions values (uuid(), 'folder_id_from_above','assigned_user_id_from_abov e');

YAY it worked.