No announcement yet.

Calendar Start of Day / Auto-Detect Daylight Savings Issue

  • Filter
  • Time
  • Show
Clear All
new posts

  • Calendar Start of Day / Auto-Detect Daylight Savings Issue


    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:	40
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:	27
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

    Attached Files

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

    UPDATE user SET startofweek=1 WHERE startofweek=-1;

    For DST:

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

    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 customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.


    Related Topics