Timezone Offset updated 1.3.0 error
There is a closed thread on this in archieves, but unresolved prior to forum upgrade.
I'm having the same problem, this is following installation of the updated timezone offset. Note: this is a fresh install, no upgrades.
error is generated only on checkout:
Fatal error: Call to a member function on a non-object in /../../../../includes/classes/order.php on line 854
The original files (including order.php) were replaced as per timezone offset instructions. the configuration table appears ok.
Only way to not get this error is to go back to using the original order.php, thus not able to employ the correct time zone.
Re: Timezone Offset updated 1.3.0 error
There were many changes made to the orders.php for the change from 1.2.7 to 1.3.0 and the additions for the time zone offset will need to be merged into your 1.3.0 files.
Re: Timezone Offset updated 1.3.0 error
Not at all. As I said "this is a fresh install, no upgrades."
The only change was the uploading of the Timezone offset files ..includes/classes/order.php, ..includes/functions/functions_general.php, ..admin/orders.php.
This specifically relates to starting at line 852 in includes/classes/order.php:
// get the order date corrected for time zone offset
$date_query = "select date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$zf_insert_id . "'";
$offsetdate = $db->Execute($date_query);
$orderdate = $offsetdate->fields['date_purchased'];
bein the only change to the original version 1.3 order.php.
Re: Timezone Offset updated 1.3.0 error
Re: Timezone Offset updated 1.3.0 error
Thanks for that! Works just fine now.
Re: Timezone Offset updated 1.3.0 error
Quote:
Originally Posted by jetx
Thanks for that! Works just fine now.
Happy to help ...and good to know it works :smile:
Re: Timezone Offset updated 1.3.0 error
Quote:
Originally Posted by gilby
Happy to help ...and good to know it works :smile:
and it doesn't work :-(
I have installed it then I typed +10:00 in the config/my store and now I can not see my store at all.
It says following. How do I fix this. Can not even see the field in the table Configuration 'Time Zone Offset' in the mysql as I wanted to corrected there.
Can you please help. Its rather urgent. Thanks
-------------------------------------------------------------
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':00 HOUR), '1', 'configuration.php', 'gID=1&', '59.167.109.97')' at line 1
in:
[insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (date_add(now(), INTERVAL +10:00 HOUR), '1', 'configuration.php', 'gID=1&', '59.167.109.97')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
-----------------------------------------------------------------
Re: Timezone Offset updated 1.3.0 error
Quote:
Originally Posted by oavs
and it doesn't work :-(
I have installed it then I typed +10:00 in the config/my store and now I can not see my store at all.
It says following. How do I fix this. Can not even see the field in the table Configuration 'Time Zone Offset' in the mysql as I wanted to corrected there.
Can you please help. Its rather urgent. Thanks
-------------------------------------------------------------
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':00 HOUR), '1', 'configuration.php', 'gID=1&', '59.167.109.97')' at line 1
in:
[insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (date_add(now(), INTERVAL +10:00 HOUR), '1', 'configuration.php', 'gID=1&', '59.167.109.97')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
-----------------------------------------------------------------
I think you are supposed to put +10 not +10:00
look in zen_configuration (if you use a zen_ prefix) and try to fix it there.