Hi Krisits, I understand your confusion. What I meant to say is that there are several products in the Bugzilla database, not just one. However, the error I encountered is not typical for my situation. It was triggered because a product name that is non-existent in the Bugzilla database was passed to Scmbug.
In our glue.conf file, I have set the product_name_definition type to 'manual' and have set the value to 'LOFAR'. In the Bugzilla database, there are many products, each being a part of this "global" LOFAR product. There is, however, no product 'LOFAR' defined in the Bugzilla database. When you create a tag or branch, Scmbug queries the database for the product-id of LOFAR (since that's the product name in the glue.conf file). The SQL select query returns zero rows, because there is not product LOFAR in the Bugzilla database. The return value is not checked though! The empty product_id variable is passed to an SQL insert query which expects two values (the latter being the product_id), but receives only one. Bingo! See sub integration_add_tag in /usr/share/scmbug/lib/Scmbug/Daemon/Bugzilla.pm I tried setting product_name_definition to 'auto', but I couldn't get this to work. But, even if I had succeeded in this, it would still not have solved our problem, since there's no one-to-one match between the names of the (sub)directories in our software tree and the product names in our Bugzilla database. Regards, Marcel Loose >>> Kristis Makris <[EMAIL PROTECTED]> 29-08-07 19:04 >>> On Wed, 2007-08-29 at 11:20 +0200, Marcel Loose wrote: > Yesterday, I stumbled upon a nasty problem/error. Since our project is > pretty big, we decided (years ago) to define within Bugzilla several > products, each of these consisting of several components. Hence, our > Bugzilla database is the single bug-tracker for our big project, which > (seen through Bugzilla's eyes) consists of several products. This > caused some problems with the installed Scmbug glue, because there's > not a single product within the Bugzilla database. Although Also, the above statement confused me. It seemed incomplete. Are there NO products in your Bugzilla database ? You just said that you defined multiple products, with multiple components. I understand that you are getting an SQL error somewhere due to a product_id not being matched, but I don't understand WHY ? WHAT did you do that caused this ? _______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
