Hi, I just changed the time on my server (time zone). But NEW records on the amember database are still being recorded in the old time zone? I confirmed that the time has indeed changed on the sever? strange? ideas? Ronnie
solution the solution fyi was that MYSQL apparently has its own time zone. My admin changed it to relate to the time of the server and everything is working fine.
Mysql timezone changes...hmm! Yeah, I noticed during testing as well that our server is 6 hours out. I stumbled across this thread, and it seems that yeah, in answer to your post, mySQL atempts to detect the timezone off the system environment it's running in, in my case it would get it from Apache I believe. mySQL Timezone information Actually, it isn't because it's based in america, but I would like the transaction times to be GMT rather than what they are now. I came across your post whilst looking for a way to change the timezone in the admin panel (can't currently see one!) Is this something that can be done through the system? I can't change the server timezone as it's a shared server and I don't think the other people would be very happy So what I need is a way to add 6 hours to each transaction. Is there a global variable that I can change somewhere, rather than having to go through and change the display in the admin panel (each page), the emails to users (each different one) etc etc? If this isn't a feature, is it likely to be included in the future? Or could I request it to be? It seems like it would be very handy if you only had to enter it in one place, then everyone worldwise could use aMember easier! TIA Mark