While using those files from v1.5.4 can help, since the site is using v1.5.1 from 2012 it doesn't have the necessary code in the database query-factory to also set the timezone in the database. The query_factory code from 1.5.4 is not compatible with 1.5.1 because they use different parts of PHP. The v1.5.1 code uses the obsolete no-longer-supported mysql_ functions, and the v1.5.4 code uses the modern supported mysqli_ functions.
THE BEST SOLUTION IS TO UPGRADE, not just throw patches at it.
Results 1 to 10 of 11
Threaded View
-
2 Feb 2015, 06:25 PM #5
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: Server/database time zone correct in admin wrong in database
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Reply With QuoteSimilar Threads
-
Correct time in ADMIN area, WRONG time on ORDER CONFIRMATION
By Yoshi-M in forum General QuestionsReplies: 1Last Post: 16 Apr 2013, 07:44 PM -
Urgent:0 db_error_not_connected admin after changing database password on server
By RobertG in forum General QuestionsReplies: 18Last Post: 8 Feb 2010, 08:23 PM -
Importing a database - Max Execution Time Exceeded - on my fasthosts server
By tomtailford in forum General QuestionsReplies: 2Last Post: 10 May 2009, 09:56 PM -
moving server minimal down time w/ consistent database
By sanguisdesign in forum Installing on a Linux/Unix ServerReplies: 2Last Post: 21 Mar 2007, 12:50 AM
