Time or Timezone CS 2.x

It looks like we are bringing the old bugs to the new version. If I can recall, I had to make the same changes in 1.3.x. Notice the id’s in cscart_settings_descriptions and cscart_setting_variants. Just a little assbackwards huh?



cscart_setting_variants





cscart_settings_descriptions

Here is an sql file that will correct the correlation between the timezones in cscart_settings_descriptions and cscart_setting_variants. The file will only update the timezone descriptions in cscart_settings_descriptions.



I would also recommend using the correct timezone format in cscart_setting_variants as described here: [url]http://us3.php.net/manual/en/timezones.php[/url] These values will automatically correct for changes in time. I can only give an example of America because it’s the only one I am familiar with.



Ect/GMT-5 → America/New_York

Ect/GMT-6 → America/Chicago

Ect/GMT-7 → America/Phoenix

Ect/GMT-8 → America/Los_Angeles

I have created an sql file that will correct the information in the table cscart_settings_descriptions for the timezone issue.

cscart_settings_descriptions_timezone.zip

[quote name=‘Tool Outfitters’]I have created an sql file that will correct the information in the table cscart_settings_descriptions for the timezone issue.[/QUOTE]





Hi sorry to appear DIM, but I just can’t think how to do this???:confused:



Do I just import it into that SQL table via PHPadmin etc???



BarryH

This was supposedly fixed in 2.07.

[quote name=‘BarryH’]Hi sorry to appear DIM, but I just can’t think how to do this???:confused:



Do I just import it into that SQL table via PHPadmin etc???



BarryH[/QUOTE]



admin.php?dispatch=database.manage



go to restore



local (select sql or compressed tgz file), upload file (file can also be uploaded via ftp to var/database…). Now when file is uploaded, checkbox it and restore.



Make a proper backup before this. Not sure but cs-cart versions may also be important (case sensitive).

[quote name=‘Darius’]admin.php?dispatch=database.manage



go to restore



local (select sql or compressed tgz file), upload file (file can also be uploaded via ftp to var/database…). Now when file is uploaded, checkbox it and restore.



Make a proper backup before this. Not sure but cs-cart versions may also be important (case sensitive).[/QUOTE]


[quote name=‘Tool Outfitters’]This was supposedly fixed in 2.07.[/QUOTE]



Thanks Darius, will try later.



Tool Outfitter, this is still the same, no matter what we do it is either an hour slow or an hour fast.



BarryH Thanks for the SQL:D

Check the tables in phpMyadmin. If they haven’t been corrected, then run the query.