Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Setting order time to NZ time zone


Guest

Recommended Posts

within the admin area, the order time are displayed as the server local time *server locates in USA*

 

is there anyway to modify this to display the time in New Zealand? which is GMT+12

 

really struggling with this -_-

Link to comment
Share on other sites

Hi,

 

You need to modify that mysql boot up file /etc/rc.d/init.d/mysqld

 

$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file &

change to

$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --timezone=GMT+12 &

 

Regards,

Bn

Link to comment
Share on other sites

didnt really understand that, nor am i sure i can get access to that?

 

i have SSH shell login access, but i cannot modify the date using date -s blahblah

 

 

can you explain it further? sorry i am new to all these

Link to comment
Share on other sites

Hi,

 

You need to modify mysql boot up file /etc/rc.d/init.d/mysqld

 

$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file &

change to

$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --timezone=GMT+12 &

 

By adding --timezone=GMT+12 , mysql database will change the time to your local time. After you modify that file, restart mysql and date and timestamp fields will refect this change or you can run a query "select now();" to see its change.

 

To restart mysql database:

/etc/rc.d/init.d/mysqld restart

 

Regards,

Bn

Link to comment
Share on other sites

You need to modify that mysql boot up file /etc/rc.d/init.d/mysqld

Most probably iijan has a shared server, meaning that s/he won't be able to modify anything outside of the assigned webroot. I know that is the case with one of the hosting accounts that I possess where the server is hosted in america. Therefore, modifying *any* configuration files is not going to happen. A change of this nature (changing MySQL's timezone) would affect all of the users of the server, and I would presume that most of them wouldn't be in NZ.

 

in all reality, the timezone is probably set to UTC/GMT. This makes calculations a little easier. Maybe a modification to one of the tep_date_* functions would make this possible!!

Link to comment
Share on other sites

  • 8 years later...

problem fixed with a temporary solution, pm me if you are also struggling with the order time

 

i be more than happy to help out

 

 

 

Hey, Im in NZ and also having problems changing the time zone from the US. PLEASE HELP!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...