Restarted SQL, Lost All User Settings! Help!

[umayxa3]

I was doing routine maintenance and restarted the MS SQL server service "SQL Server (MSSQLSERVER)" and now all users are reporting their SugarCRM configurations are lost - Home Page dashlets, timezones, etc. This is the second time this happened, the last time was when we had a routine server reboot.

How do I prevent this from happening?
I need to be able to reboot the server or restart the database services, as needed.

We are running:

• Windows Server 2003 Enterprise Edition Service Pack 2
• SQL Server 2008
• IIS 6
• PHP 5.2.6

Thanks for any feedback.

-Allen

[salesagility]

I suggest you try Repair Database in Admin -> Repair.

Hopefully that should resolve the issue.

[eggsurplus]

Allen,

We had the same issue. Here's a thread with what we did to solve it: http://www.sugarcrm.com/forums/showthread.php?t=26146

Along with the wiki article: http://www.sugarcrm.com/wiki/index.p...lets_Disappear

[umayxa3]

Well, I applied the change and thought I had a victory.. but it wasn't

Last week I made the change to the config.php file, as prescribed in the SugarWIKI page above, and tested with a power-user that helps me with testing (she was one of the individuals that experienced the loss of custom dashlets).
I had her make some changes and save.. then I restarted SQL Server services (MSSQLSERVER). She signed out and then back in.. no problems.

I was doing work yesterday on another project and I needed to restart the SQL Server service (MSSQLSERVER). About an hour later I got a phone call from a company Director saying she lost her Home Page custom dashlet configurations.

The Director wants to know why this happened.. I'm now in the hot-seat.

The SugarWIKI article talks about the variable 'disable_persistent_connections' but shouldn't these custom Home Page dashlet configurations be saved in the database?

Anyone have more insight why user's customized dashlets are reverting to the default after a SQL Server service restart?

Thanks for any help.

-Allen

[eggsurplus]

Allen,

Yes, it is saving it to the database. But I'm not so sure it's doing so correctly. What's happening is that when it loads the dashlets in this code in modules/Home/index.php:

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

it's saying that neither the columns nor dashlets have ever been defined even though they have. So once it gets to that if block it resets the user's dashlets. My guess is that the module is being saved as camel case in the user's preference so if you changed the "home" to "Home" it would work. However, sometimes it will save correctly as "home". So to solve the issue we really need it to save in lowercase.

To do this open modules\UserPreferences\UserPreference.php and add the following code to to top of each function (inside the function):

 $category = strtolower($category); 
  

This will ensure that the module name will save as lowercase ("home" instead of "Home"). Now

The solution is described fully in this post: http://www.sugarcrm.com/forums/showp...6&postcount=19

We still use this customization in our code. What is the cause to this and why does it happen only for some folks like ourselves I'm not so sure on. The only thing I can think of is that we're on a Windows server running MSSQL on the XAMPP stack. If there is any similarities here please let me know.

Best of luck!
Jason