1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Locale imported as - (UTC) Monrovia, Reykjavik

Discussion in 'Installation, Upgrade, and Import Support' started by CyclingTribe, Dec 5, 2011.

  1. CyclingTribe

    CyclingTribe Well-Known Member

    I've just noticed that after importing from IP.Board 3.1.4 most members time zone is set to (UTC) Monrovia, Reykjavik when ideally, as a mainly UK forum, it should be (UTC) Dublin, Edinburgh, Lisbon, London.

    Is there a query I can run to change everyone who is on (UTC) Monrovia, Reykjavik to (UTC) Dublin, Edinburgh, Lisbon, London?

    NB: I don't want to change ALL members as we do have some overseas visitors.

    Thanks,
    Shaun :D
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Code:
    UPDATE xf_user SET timezone = 'Europe/London' WHERE timezone = 'Atlantic/Reykjavik'
     
    GeeksChat likes this.
  3. CyclingTribe

    CyclingTribe Well-Known Member

    Thanks Paul - or should that be Flash, ahhhaaaaaaaa!!!

    Edit: Affected rows: 15045 (Query took 0.6222 sec)
     

Share This Page