Timezone Offset updated 1.3.0 error

[jetx]

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.

[Kim]

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.

[jetx]

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.

[gilby]

Try this one

Time Zone Offset v1.3.0.1

[jetx]

Thanks for that! Works just fine now.

[gilby]

Thanks for that! Works just fine now.

Happy to help ...and good to know it works

[oavs]

Happy to help ...and good to know it works

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.
-----------------------------------------------------------------

[gilby]

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.