Results 1 to 7 of 7

Thread: Time Zone on user login

  1. #1
    Pdor is offline Sugar Community Member
    Join Date
    May 2008
    Location
    Treviso, IT
    Posts
    41

    Default Time Zone on user login

    Hi

    I've a problem with one user (only one) that answer me the time zone every time i login on Sugar. Try to reset to default the user preferences and login to several pc, but nothing return good...

    Any idea?

    Thanks in advance.

  2. #2
    Pdor is offline Sugar Community Member
    Join Date
    May 2008
    Location
    Treviso, IT
    Posts
    41

    Default Re: Time Zone on user login

    I forget... my configuration is

    SugarCRM 5.0.0d (Build 3235)
    Windows XP SP2

  3. #3
    SugarDev.net is offline Sugar Community Member
    Join Date
    Feb 2008
    Posts
    1,401

    Default Re: Time Zone on user login

    would it cause very much trouble if you would try to delete the user and create a new one? I would first create a new user and let him/her play around a bit, see whether it happens.
    Developers go here
    Businesses go there (Dutch)

    Modules:
    SugarDev.net Developer Tools | Config | Dutch Language Pack
    "Nothing gets fixed unless there is a bug"

  4. #4
    Pdor is offline Sugar Community Member
    Join Date
    May 2008
    Location
    Treviso, IT
    Posts
    41

    Default Re: Time Zone on user login

    I've just create a new user, with standard configuration and the problem not happen with his user.

    Other things?

  5. #5
    SugarDev.net is offline Sugar Community Member
    Join Date
    Feb 2008
    Posts
    1,401

    Default Re: Time Zone on user login

    It is strange. What I would do (you'll need some database skills)

    1. Deactivate the user in SugarCRM
    2. Create a new user
    3. Switch UUIDs between the records

    This way, all ownership stays where it should be.

    The problem lies in user_preferences. This table may be messed up, I don't know. It's hard to debug since it's encoded data, and a whole bunch of it.
    Developers go here
    Businesses go there (Dutch)

    Modules:
    SugarDev.net Developer Tools | Config | Dutch Language Pack
    "Nothing gets fixed unless there is a bug"

  6. #6
    Pdor is offline Sugar Community Member
    Join Date
    May 2008
    Location
    Treviso, IT
    Posts
    41

    Default Re: Time Zone on user login

    Quote Originally Posted by SugarDev.net
    It is strange. What I would do (you'll need some database skills)

    1. Deactivate the user in SugarCRM
    2. Create a new user
    3. Switch UUIDs between the records

    This way, all ownership stays where it should be.

    The problem lies in user_preferences. This table may be messed up, I don't know. It's hard to debug since it's encoded data, and a whole bunch of it.
    Thanks SugarDev.net, i follow your instruction and probabily found the problem. On PhpMyAdmin, the user_preference table give me the error:

    "#1194 - Table 'user_preferences' is marked as crashed and should be repaired".

    Try to repair with Sugar function "Repair" and selecting "user", but the problem remain. Do you know what is the way to repair a table inside PhpMyAdmin?

    Thank for help

  7. #7
    Pdor is offline Sugar Community Member
    Join Date
    May 2008
    Location
    Treviso, IT
    Posts
    41

    Default Re: Time Zone on user login

    Ok folks, the problem is close...

    I find the repair options on user_preference table on PhpMyAdmin, and after the repair the user go straight without any problem

    Thanks

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. sth. for the future: Time Zone for Account/Contact
    By tvancura in forum Feature Requests
    Replies: 2
    Last Post: 2012-02-03, 06:41 AM
  2. Time out for login
    By gkeyes in forum Help
    Replies: 6
    Last Post: 2008-05-30, 02:07 PM
  3. Response time varies by User ??
    By frankt in forum Help
    Replies: 0
    Last Post: 2006-03-22, 03:20 PM
  4. Time Zone and email alerts -- Sugar 3.0c
    By dsga1 in forum General Discussion
    Replies: 7
    Last Post: 2005-07-27, 02:23 PM
  5. Cannot Login
    By Dillon in forum Help
    Replies: 16
    Last Post: 2004-10-13, 02:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •