ok I've got a problem with my forum and can't figure out exactly what the trouble is. At present we have 2 sets of web servers, some in the UK and some in the US. The DB server is also in the US, containing the relevant tables.
The forums seem to work ok, apart from a singular problem which is the time stamping of posts. I've set the time adjustment to +5 so that the time stamping is GMT (US cluster is -5 GMT). We seem to have a strange spread of timing ...
Assuming current GMT is 12:00:00 (24hr clock). UK/Euro users posts are commonly marked as 17:00:00 or 12:00:00 US/RoW users are marked as 12:00:00 or 07:00:00 or on occassion 02:00:00
Anyone got any ideas of what may be an obvious mistake on my part? I am working to ensure we only use the US cluster of web servers, hopefully that may cure the problem.
You didn't mention on which server your forum is located? Since the time formating also depends on the server the forum is on. The time in the database is not stored as "Time" data, so the database doesn't format it at all. The formating is done in the code.
Topic Locked
Posted - 29 July 2004 : 09:54:49
