[Phpgroupware-cvs] [18529] add some log, fix the SQL (at least for psql)

[Caeies]

Revision: 18529
          
http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=18529
Author:   Caeies
Date:     2008-05-14 17:33:17 +0000 (Wed, 14 May 2008)

Log Message:
-----------
add some log, fix the SQL (at least for psql)

Modified Paths:
--------------
    trunk/syncml/inc/class.sochannel.inc.php

Modified: trunk/syncml/inc/class.sochannel.inc.php
===================================================================
--- trunk/syncml/inc/class.sochannel.inc.php    2008-05-14 17:32:19 UTC (rev 
18528)
+++ trunk/syncml/inc/class.sochannel.inc.php    2008-05-14 17:33:17 UTC (rev 
18529)
@@ -14,13 +14,14 @@
        {
                function insert_channel($database_id, $device_uri)
                {
+                               
syncml_logger::get_instance()->log("insert_channel($database_id,$device_uri)");
+                               
syncml_logger::get_instance()->log("insert_channel :" .sprintf('
+                                                               INSERT INTO 
phpgw_syncml_channels(database_id, device_uri, last_merge) VALUES(\'%d\', 
\'%s\', 0)', $database_id, $device_uri));
                        $GLOBALS['phpgw']->db->query(sprintf('
-                               INSERT phpgw_syncml_channels(
-                                       database_id, device_uri)
-                               VALUES(
-                                       \'%d\', \'%s\')',
+                               INSERT INTO phpgw_syncml_channels(database_id, 
device_uri, last_merge) VALUES( \'%d\', \'%s\', 0)',
                                $database_id, $device_uri),
                                __LINE__, __FILE__);
+                               
syncml_logger::get_instance()->log('insert_channel done');
 
                        return $GLOBALS['phpgw']->db->get_last_insert_id(
                                'phpgw_syncml_channel', 'channel_id');