Good morning,

last week I had the problem committing a new folder in "branches" in
one of my working copies which I had to resolve by deactivating
SCMBug. Else the commit didn't went through and it seem that there
never came an error message, even after waiting several minutes. This
was just related to folders, files could be committed quiet well.

I took Kristis mail yesterday as a reason to do have a closer look on this
and it pointed out that it was my fault because I specified a wrong
product name in glue.conf.

SCMBug logged the following message:

DBD::mysql::st execute failed: 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 ')' at line 1 [for Statement "INSERT INTO versions(value,product_id) 
VALUES('test', )"] at Bugzilla/DB.pm line 84
        Bugzilla::DB::SendSQL('INSERT INTO versions(value,product_id) 
VALUES(\'test\', )') called at 
D:/Programme/Scmbug/share/scmbug/lib/Scmbug/Daemon/Bugzilla.pm line 550
        
Scmbug::Daemon::Bugzilla::integration_add_tag('Scmbug::Daemon::Bugzilla=HASH(0x548ea68)',
 'gbk.elrev.net', 'test', 'SCMBug-Test, weil es mit der alten Konfiguration 
Probleme gab...') called at 
D:/Programme/Scmbug/share/scmbug/lib/Scmbug/Daemon/Integration.pm line 183
        
Scmbug::Daemon::Integration::process_activity_tag('Scmbug::Daemon::Integration=HASH(0x596fc78)',
 'Scmbug::Daemon::Request=HASH(0x59552c8)') called at 
D:/Programme/Scmbug/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 1045
        Scmbug::Daemon::Daemon::process_activity_tag() called at 
D:/Programme/Scmbug/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 943
        Scmbug::Daemon::Daemon::process_activity() called at 
D:/Programme/Scmbug/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 472
        Scmbug::Daemon::Daemon::process_connection() called at 
D:/Programme/Scmbug/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 374
        Scmbug::Daemon::Daemon::spawn_child('Datenserver', 127.0.0.1, 2153) 
called at D:/Programme/Scmbug/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 276
        Scmbug::Daemon::Daemon::start_daemon() called at 
D:\\Programme\\Scmbug\\sbin\\scmbug_daemon.pl line 39
        main::main('D:\\Programme\\Scmbug\\etc\\scmbug\\daemon.conf') called at 
D:\\Programme\\Scmbug\\sbin\\scmbug_daemon.pl line 28

This is the code in Bugzilla.pm:
        
        my $product_id;
        $sql = "SELECT id FROM products WHERE name = " . SqlQuote( 
$product_name );

        PushGlobalSQLState();
        SendSQL( $sql );
        $product_id = FetchOneColumn();
        PopGlobalSQLState();
        
        $sql = "INSERT INTO versions(value,product_id) VALUES(" .
            SqlQuote( $tag_name ) . ", " . $product_id . ")";
        PushGlobalSQLState();
        SendSQL( $sql );
        PopGlobalSQLState();

Looks like there's no error handling when no product_id is found
because no product of the given name is returned by the former
sql-request, regarding to what is logged as the sent SQL-statement.
Maybe you could provide some error messages appear in TortoiseSVN as
you do with other errors?
        
Mit freundlichen Grüßen,

Thorsten Schöning

-- 
Thorsten Schöning
AM-SoFT IT-Systeme - Hameln | Potsdam | Leipzig
 
eMail [EMAIL PROTECTED]
 
Telefon Potsdam...0331-743881-0
Telefon Mobil.....0178-8 9468-04

_______________________________________________
scmbug-users mailing list
[email protected]
http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users

Reply via email to