Email Folders not in view after upgrade

[kdunbar]

I just recently upgraded my SugarCRM from 5.2.0e to 5.2.0j community edition. Immediately following that, I installed the TeamSuite module so that I can control groups better.

Environment is: apache 2, mysql 5, php 5.2 (lampp) running on CentOS.

After the upgrade and module installation, I no longer have my email folders in the email view for any users.
I see the "Check Mail", "Compose Mail" and "Settings" tabs, but everything is blank under that.

I've checked the sugarcrm.log file to see if there are any errors, and there are none.

I'm looking for suggestions on where I can start trouble shooting this. Normally logs are where I start, but there's nothing. Can I turn up the logging level somewhere on SugarCRM?

All this while trying to configure SugarCRM for my company... needed to create cases from emails sent to support@company.com. Documentation is sort of good if everything works according to plan.

thanks in advance.

[kdunbar]

Update to that last post.
I've found "logger" setting in the Admin -> System Settings configuration. I've set the logging level to debug and have clicked the email tab again. This gives me the debug logs for all the selects performed for this user, but since I don't know what should be returned or searched on, I'm not sure what I should be looking for in the logs. What has been missed, what's not being returned? for the page to be blank.

[salesagility]

Is the sugar log showing any errors relating to the email module?

Run a test ... note the time .... go to your email mdoule ... then go back to sugar.log and look for errors equalling the time you accessed email ..

Otherwise ... run admin>repair>quick repair and rebuild

[kdunbar]

Moved everyone off the system so the log was pretty easy to follow.

tail -f sugarcrm.log

Got this error, which is at the end for this output... (certainly more logs than this, but this is where the error was)

Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query:SELECT category, name, value FROM config
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query Execution Time:0.000246047973633
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query Execution Time:0.000154972076416
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query:SELECT * FROM outbound_email WHERE id = '838752d5-d41b-efee-8c6e-4a1ab07524a3'
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query Execution Time:0.000164985656738
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][DEBUG] Module:Configurator using file: EditView
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query:SELECT placement,name,id,url from iframes WHERE deleted=0 AND status=1 AND (placement='tab' OR placement='all') AND (type='global' OR (type='personal' AND created_by='1')) ORDER BY iframes.name
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query Execution Time:0.000389099121094
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query:SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = '1' AND visible = 1)
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Query Execution Time:0.000319004058838
Sun 04 Oct 2009 02:02:55 PM CDT [14652][1][INFO] Tracker: retrieving 10 items
Sun 04 Oct 2009 02:03:20 PM CDT [16243][1][ERROR] MySQL error 1054: Unknown column '662a883c' in 'where clause'

[kdunbar]

Just a follow up on the emails. Didn't look like I was getting many suggestions, but for anyone that cares, the problem is with the browser. The email folders will not show up when using Safari. (on a mac. I've not tested with a windows computer).

Firefox works fine, IE works fine.

There you go. Need to open a bug for Safari on Sugar. Email does not work in Safari.