Louise-Paisley
Established Member
Eric The Viking":vqjhaqwl said:Louise-Paisley":vqjhaqwl said:Really the only problem I have encountered from a US host is the time difference, the server and MYSQL server being set to mountain time means that orders placed in the UK have the wrong timestamp in customers order history, even this can be fixed fairly easily by changing the timezone in PHP and issuing a mysql query to change the mysql timezone into the mysql intit configuration but to be honest the benefits from doing it is not worth the hassle of actually doing it.
Surely it's using UTC and therefore the timestamp will be automatically adjusted?
Or is your PHP script converting it in situ? It's easy enough to add 7 hours...
Apparently not, the mysql server is set to mountain time, so to correct it I would have to add a line to set the mysql timezone on each init otherwise it just reverts back to mountain time - yes its a bit of a pain I guess but really not enough to need to waste time editing the code over. Besides which, much of my sales is international so fixing for UK would not fix for other countries.
I think it is a combination of the server configuration and poor support for timezones in my cart software rather than one or the other. But really, for less than £80 a year for all my websites not just one and free cart software, well I can live with a few silly niggles
Oh as for registration address details etc.. yes good advice, it is worth opting for domain privacy if you are offered it when you buy - if your phone/ email address is entered into the register you are also likely to start getting spam from it as well!