log in | register | forums
Show:
Go:
Forums
Username:

Password:

User accounts
Register new account
Forgot password
Forum stats
List of members
Search the forums

Advanced search
Recent discussions
- Homemade 6502 computer (Gen:2)
- Wakefield 2017 Show Report (News:)
- Wakefield 2017 show in pIctures (News:)
- Wakefield Acorn & RISC OS Show, 22nd April 2017 (News:4)
- Chris Grandson tells ROUGO...er browser and other ports (News:)
- Drag'N'Drop brings you a new selection of fonts (News:)
- Acorn 80MB Conner data recovery via PI? (Gen:4)
- South West Show in Pictures (News:1)
- Little Yellow Moon (Site:5)
- RISC OS Interviews - Anthony Vaughan Bartram (News:)
Latest postings RSS Feeds
RSS 2.0 | 1.0 | 0.9
Atom 0.3
Misc RDF | CDF
Site Search
 
Article archives
Acorn Arcade forums: Site Comments: Don't forget to change your clocks...
 
  Don't forget to change your clocks...
  rich (14:02 15/3/2010)
  nunfetishist (14:20 15/3/2010)
    rich (10:47 12/4/2010)
  filecore (15:02 15/3/2010)
  VincceH (18:25 15/3/2010)
    Phlamethrower (19:20 15/3/2010)
      VincceH (23:01 15/3/2010)
    monkeyson2 (19:24 15/3/2010)
      rich (21:20 15/3/2010)
      filecore (21:22 15/3/2010)
 
Richard Goodwin Message #113705, posted by rich at 14:02, 15/3/2010
Rich
Webmaster
The Icon Bar

Posts: 6765
I just had to restart the database. All the events on another website were screwed - instead of (e.g.)
* Wednesday, 7th April
they read
* Tuesday, 6th April to Wednesday, 7th April 10:59

Took me a few minute to realise - daylight savings time. They're stored as DATETIME in the DB, so they look fine checking manually (7th April 00:00 to 23:59), but the UNIXTIME call was returning GMT for events in the BST window, even though the MySQL website says it returns localtime. Adding one line of mysqld_safe configuration fixed it.

Doesn't help that I test the code on a Windows box (still with Apache/MySQL/PHP), which was working correctly.
________
RichGCheers,
Rich.
  ^[ Log in to reply ]
 
Rob Kendrick Message #113706, posted by nunfetishist at 14:20, 15/3/2010, in reply to message #113705
nunfetishist
Exposing morons since 1981

Posts: 481
Oh, how we love MySQL.
  ^[ Log in to reply ]
 
Jason Togneri Message #113712, posted by filecore at 15:02, 15/3/2010, in reply to message #113705

Posts: 3867
a Windows box [...] which was working correctly.
shock
  ^[ Log in to reply ]
 
VinceH Message #113721, posted by VincceH at 18:25, 15/3/2010, in reply to message #113705
VincceH
Lowering the tone since the dawn of time

Posts: 1577
I had actually completely failed to notice that it was that time of year again - but on Sunday morning when I picked up my phone it informed me that the clock had been updated. Prompted by this, I then checked the one item I thought I'd need to update: my watch, but even that had updated itself.

Funny - I don't remember it being one of those watches that pick up a time signal, and nor do I remember it having some kind of built in function to automatically change to and from daylight savings time when necessary; neither of these things were listed as selling points when I bought it.

I also don't remember it changing automatically six months ago, or twelve months ago, or eighteen months ago (and so on), but then again, nor do I remember actually changing it myself.

This, of course, is not a site comment. Ho hum.
  ^[ Log in to reply ]
 
Jeffrey Lee Message #113722, posted by Phlamethrower at 19:20, 15/3/2010, in reply to message #113721
PhlamethrowerHot Hot Hot Hot Hot Hot Hot Hot Hot Hot Hot Hot Hot stuff

Posts: 15054
(Psst - Your watch probably hasn't updated itself because BST doesn't start for another couple of weeks. And probably because it doesn't update itself automatically. No idea what's wrong with your phone though! tongue)
  ^[ Log in to reply ]
 
Phil Mellor Message #113723, posted by monkeyson2 at 19:24, 15/3/2010, in reply to message #113721
monkeyson2Please don't let them make me be a monkey butler

Posts: 12380
Huh? It hasn't happened yet, surely?

http://www.direct.gov.uk/en/Governmentcitizensandrights/LivingintheUK/DG_073741

What time is it supposed to be now? I am confusored.
  ^[ Log in to reply ]
 
Richard Goodwin Message #113724, posted by rich at 21:20, 15/3/2010, in reply to message #113723
Rich
Webmaster
The Icon Bar

Posts: 6765
Last Sunday in March IIRC
________
RichGCheers,
Rich.
  ^[ Log in to reply ]
 
Jason Togneri Message #113725, posted by filecore at 21:22, 15/3/2010, in reply to message #113723

Posts: 3867
EDIT: snip stupidity

[Edited by filecore at 21:24, 15/3/2010]
  ^[ Log in to reply ]
 
VinceH Message #113728, posted by VincceH at 23:01, 15/3/2010, in reply to message #113722
VincceH
Lowering the tone since the dawn of time

Posts: 1577
(Psst - Your watch probably hasn't updated itself because BST doesn't start for another couple of weeks. And probably because it doesn't update itself automatically. No idea what's wrong with your phone though! tongue)
Ah, I see - so what actually happened was that my phone strangely told me it had updated when it in fact hadn't. It lied to me.

I knew the change happens sometime in March, so I just accepted what it had said, and noting the time was right on the things that also update automatically, I assumed they had, well, updated. Automatically.

It was only the watch that threw me. (It's a very strong watch.)
  ^[ Log in to reply ]
 
Richard Goodwin Message #113951, posted by rich at 10:47, 12/4/2010, in reply to message #113706
Rich
Webmaster
The Icon Bar

Posts: 6765
Oh, how we love MySQL.
OFC, I just had to change it back, presumably because someone fixed the initial problem.
________
RichGCheers,
Rich.
  ^[ Log in to reply ]
 

Acorn Arcade forums: Site Comments: Don't forget to change your clocks...