Google Checkout integration problem

[shohrukh]

I am trying to integrate official Google checkout payment module and facing some problems with it.

 

The cart is sent to Google and Google processes it fine and sends it back. responsehandler.php also processes it, creates a user, creates an order, but doesn't create a record in orders_total table. Therefore, Google Checkout orders don't show up on orders page and on reports, because the query used to select the orders involves the "ot_total" in orders_total.class which is not there. If I type in the order ID in the URL, it shows it and the rest works just fine. The version of GC module I use is SVN rev 111, I guess it is the same as 1.4.5a.

 

Anybody had the same problem?

[shohrukh]

Here is the portion of responsehandler.php that should create records in orders_total table but somehow doesn't:

 

(line 526)

	  for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) {
	$sql_data_array = array('orders_id' => $insert_id,
							'title' => $order_totals[$i]['title'],
							'text' => $order_totals[$i]['text'],
							'value' => $order_totals[$i]['value'], 
							'class' => $order_totals[$i]['code'], 
							'sort_order' => $order_totals[$i]['sort_order']);
	tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);
  }

[shohrukh]

Another finding, the sizeof($orders_total) in the code below returns 0. This loop is never run, therefore there are no records in the orders_total table.

	  for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) {
	$sql_data_array = array('orders_id' => $insert_id,
							'title' => $order_totals[$i]['title'],
							'text' => $order_totals[$i]['text'],
							'value' => $order_totals[$i]['value'], 
							'class' => $order_totals[$i]['code'], 
							'sort_order' => $order_totals[$i]['sort_order']);
	tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);
  }

Anyone had anything similar?