time offset 1.2.7d order.php error

[emtecmedia]

Hi,

I have just installed the time offset module deisgned for 1.2.3. I am running ver.1.2.7d so instead of just copying function_general.php and orders.php i used winmerge to add the new time offset code into the files.

This seem to of worked fine for functions_general.php but orders.php throws up this error when trying to purchase through the site:
Fatal error: Call to a member function on a non-object in /var/www/vhosts/ry.com.au/httpdocs/store/includes/classes/order.php on line 827

Here is the section of code at line 827:
// lets start with the email confirmation
// make an array to store the html version
$html_msg=array();
// get the order date corrected for time zone offset
$date_query = "select date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$zf_insert_id . "'";
"Line 827" $offsetdate = $db->Execute($date_query);
$orderdate = $offsetdate->fields['date_purchased'];

Can someone please give me an idea on where this went wrong? The sql file loaded into the database no problem.

Thanks,
Brad.

[DrByte]

One of your updates has busted the connection to the database for that section of code.

Did you change any lines talking about something like: global $db;

The error is occurring while the $db->execute is trying to run because $db isn't a known object at this point in the code. This suggests an error earlier in the file...

[emtecmedia]

Hi,

Here is the complete file - orders.php

[gilby]

The most recent 1.2.7 version is available here http://www.nevj.com/time_zone_offset.zip

courtesy of Bunyip & WigWil

[emtecmedia]

Hi,

Great stuff!! Just installed it and it works without errors, thanks heaps.

Although 1 problem: when the order email goes out it says it was ordered in 1969...

Brad.

[gilby]

Hi,

Great stuff!! Just installed it and it works without errors, thanks heaps.

Although 1 problem: when the order email goes out it says it was ordered in 1969...

Brad.

Yes... I do remember that little bug (1.2.7d seems so... long ago )
I'll check for the fix for that tonight.

[gilby]

Yes... I do remember that little bug (1.2.7d seems so... long ago )
I'll check for the fix for that tonight.

Sorry it is too long ago. I seem to have deleted that 127d fix from my computer as I don't use it anymore.