Home Page Dashlets - Changes not Persisting?

[HollyCat]

We seem to be having a permissions problem with home page dashlets and themes.

The users are granted permission to modify their home page, to remove and re-arrange dashlets etc. This is fine until they log out. When they log back in again it's back to square one. Changes include removing dashlets such as cases/jotpad and changing meetings to show incomplete future meetings are lost. Same result whether ordinary user or an admin and it is no different whether using FF/IE 6 or 7 or Avant Browser. Same result also wether a remote user or inside the firewall. Furthermore if a user changes theme from sugar to sugar lite, the change does not persist pas their active session.

Any clues? We found one other thread from May but there was no answer.

TIA

[eggsurplus]

We had the same thing happening. Tracing through the process I found that if a database connection is lost during the page load it would reset to the default. Fixing our sugar database configuration and our db server configuration has minimized the problem now.

The problem was traced to modules/Home/index.php. If the connection failed during the getPreference for the current user then it would return nothing causing it to go into the default dashlet control block.

 $columns = $current_user->getPreference('columns', 'home'); 
$dashlets = $current_user->getPreference('dashlets', 'home');
 
// fill in with default dashlet selection
if(!isset($columns) || !isset($dashlets)) { 
  

[andydreisch]

Was there a bug created for this?

Andy

[eggsurplus]

I never created one because it wasn't Sugar bug in our case.

[andydreisch]

OK, then ... a Wiki article created?

And what was the DB config that needed changing? Inquiring minds want to know.

Thanks,

Andy

[eggsurplus]

Thanks Andy, I thought I had but guess what...

Here's the article: http://www.sugarcrm.com/wiki/index.p...lets_Disappear

[andydreisch]

And what a fine piece of prose it is.

Thanks very much for submitting the article.

Andy

[HollyCat]

Hi guys its me, back again.
My database guru confirms that there is indeed a bug and we will happily put it into the bug list for the brave person that wants to pick it up and run with it. He found duplicate rows in the user_preferences table for the affected user and for others. The theory is "that a select statement expected only one row to be returned when in fact many were found; it was simply coincidental that for one user they returned in a desirable order with the correct row first - for the user experiencing the fault they were returned in an undesirable order. The source of the duplicate/old records is not known; they have timestamps some months past. Suggested solution; put proper database constraints on this table to prevent duplicates; very probably on others too."

So we will now monitor what happens to see if this behaviour happens again. In the meantime thanks very much for your responses above . We did check those points out as part of the investigation and they were not applicable. We're surprised this hasn't been raised before??

No doubt we'll speak again soon.

[robert.blasingame]

I am having the same issue. Anytime we "reboot" our network or lose connection all of the dashlets disappear. I have looked at the config.php trick with "disable_persistent_connections" and it is set to "true". I have tried resetting the homepage and that didn't work.

We have been using Sugar for 6 months now and this has been a problem since the beginning. I was hoping the Version 5.0 would fix this problem and it hasn't.

Any ideas?

Thanks,

RB