Calendar Start of Day / Auto-Detect Daylight Savings Issue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Gene THF
    New Member
    • Jan 2019
    • 27
    • 5.3.x

    Calendar Start of Day / Auto-Detect Daylight Savings Issue

    Hello,

    Currently, we're noticing that even though "Sunday" is the default day for the Start of the Day settings, the Calendar starts on Friday for new users.

    Click image for larger version

Name:	Screen Shot 2019-04-15 at 12.39.34 PM.jpeg
Views:	164
Size:	138.0 KB
ID:	4413205




    If a user who's experiencing this just goes to their Edit Settings / Account and clicks the save button, then the Calendar will start showing the start of the day as Sunday again - even though nothing was changed and the only action performed was just "Saving".


    Click image for larger version

Name:	Screen Shot 2019-04-15 at 12.39.49 PM.jpeg
Views:	141
Size:	38.9 KB
ID:	4413206

    Also, we noticed that for many the Auto-Detect Daylight Savings options is defaulted to off, and we'd like that to be on by default.


    I need a way to:

    a) Set everyone's account to have Enabled Auto Detect Daylight Savings ON by default
    b) Ensure everyone's default Start of the Week is set to "Sunday" and have that setting actually be persisted without having to have them hit "Save" on their account settings.

    I looked in the Settings / Options, and didn't see anything anywhere under Date and Time settings or User Registration or User Profile settings so I'm guessing these will be MYSQL commands?


    -------------------------------------

    Gene M.
    Tiny House Forum
    Design & Development
    [email protected]






    Attached Files
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74078

    #2
    To fix the start of the week issue for existing users run this query:

    UPDATE user SET startofweek=1 WHERE startofweek=-1;
    See: https://tracker.vbulletin.com/vbulle...sues/VBV-19129

    For DST:

    First make sure the setting under Settings -> Options -> Date / Time Options are configured correctly. Then run this query for your existing users:

    Code:
    UPDATE user SET options=options + 64 WHERE NOT(options & 64)
    If you use a table prefix, you will need to change the user table name to reflect this.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Related Topics

    Collapse

    Working...