I have attached a patch to the issue #601, that should fix the issue. Can you give it a try?
https://issues.apache.org/bloodhound/attachment/ticket/601/t601_r1505871_do_not_add_product_column_if_already_exists_in_insert.diff On Tue, Jul 23, 2013 at 9:52 AM, Ruggero Marchei <[email protected]> wrote: > It happens on both but I noticed it happens only when I select the new > product as "default". > > To reproduce the problem: create a new product, select it as default and > then apply changes. > New ticket creation then fails with the error mentioned before. > > > On 23 July 2013 08:30, Anze Staric <[email protected]> wrote: > >> After adding a new product, did you try to add a ticket using a quick >> ticket dialog or /newticket page? >> >> On Tue, Jul 23, 2013 at 12:55 AM, Ruggero Marchei >> <[email protected]> wrote: >> > After some tests I noticed that if I add a new product and then try to >> > create a new ticket it fails with the error I was getting before, so that >> > patch resolves the issue only partially. >> > >> > Ruggero >> > >> > >> > On 22 July 2013 22:43, Ruggero Marchei <[email protected]> >> wrote: >> > >> >> Thanks for the suggestion Matevz, >> >> >> >> I tried version 0.7.0dev-r1505666 (svn revision 1505794) and it fixed >> the >> >> issue! >> >> >> >> Ruggero >> >> >> >> >> >> On 22 July 2013 21:35, Matevž Bradač <[email protected]> wrote: >> >> >> >>> >> >>> On 22. Jul, 2013, at 21:22, Ruggero Marchei wrote: >> >>> >> >>> > Hi all, >> >>> > >> >>> > I'm trying Bloodhound 0.6.0 on a CentOS 6.4 x86_64 (python 2.6.6) >> using >> >>> > Mysql as a backend database. I followed the detailed installation >> guide >> >>> and >> >>> > the installation completes without any error but is impossible to >> >>> create a >> >>> > new ticket. I can change preferences or create a new "product" >> without >> >>> any >> >>> > problem. The error found in the log file is: >> >>> > >> >>> > 2013-07-22 21:00:04,633 Trac[env] WARNING: product_base_url option >> not >> >>> set >> >>> > in configuration, generated links may be incorrect >> >>> > 2013-07-22 21:00:04,634 Trac[main] DEBUG: Dispatching >> >>> > <ProductRequestWithSession "POST '/qct'"> >> >>> > 2013-07-22 21:00:04,653 Trac[session] DEBUG: Retrieving session for >> ID >> >>> > u'admin' >> >>> > 2013-07-22 21:00:04,661 Trac[main] DEBUG: Negotiated locale: None -> >> >>> en_US >> >>> > 2013-07-22 21:00:04,683 Trac[api] WARNING: Unable to find repository >> >>> > '(default)' for synchronization >> >>> > 2013-07-22 21:00:04,743 Trac[theme] ERROR: BH: Quick create ticket >> >>> failed >> >>> > (1110, "Column 'product' specified twice") >> >>> > Traceback (most recent call last): >> >>> > File >> >>> > >> "/srv/bloodhound/virtenv/lib/python2.6/site-packages/bhtheme/theme.py", >> >>> > line 519, in process_request >> >>> > product, tid = self.create(req, summary, desc, attrs, True) >> >>> > File >> >>> > >> "/srv/bloodhound/virtenv/lib/python2.6/site-packages/bhtheme/theme.py", >> >>> > line 552, in create >> >>> > t.insert() >> >>> > File >> >>> > >> >>> >> "/srv/bloodhound/virtenv/lib/python2.6/site-packages/trac/ticket/model.py", >> >>> > line 241, in insert >> >>> > [values[name] for name in std_fields]) >> >>> > File >> >>> > >> >>> >> "/srv/bloodhound/virtenv/lib/python2.6/site-packages/multiproduct/dbcursor.py", >> >>> > line 143, in execute >> >>> > return self.cursor.execute(sql, args=args) >> >>> > File >> >>> > >> >>> >> "/srv/bloodhound/virtenv/lib/python2.6/site-packages/multiproduct/dbcursor.py", >> >>> > line 83, in execute >> >>> > return super(BloodhoundIterableCursor, >> >>> > self).execute(translate_sql(self.env, sql), args=args) >> >>> > File >> >>> > >> "/srv/bloodhound/virtenv/lib/python2.6/site-packages/trac/db/util.py", >> >>> line >> >>> > 65, in execute >> >>> > return self.cursor.execute(sql_escape_percent(sql), args) >> >>> > File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line >> 173, >> >>> > in execute >> >>> > self.errorhandler(self, exc, value) >> >>> > File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", >> line >> >>> > 36, in defaulterrorhandler >> >>> > raise errorclass, errorvalue >> >>> > ProgrammingError: (1110, "Column 'product' specified twice") >> >>> > >> >>> > >> >>> > It is possible to reproduce the issue installing a CentOS 6.4 minimal >> >>> then >> >>> > running the commands listed here: http://fpaste.org/27062/52016013/ >> >>> > Then login as admin/password and try to create a new ticket. The GUI >> >>> raises >> >>> > the error "Could not create ticket . Error : Internal Server Error" >> >>> > >> >>> > Is there something wrong with my setup? Could it be a bug? >> >>> > >> >>> > Thanks in advance, >> >>> > Ruggero >> >>> >> >>> Hi Ruggero, >> >>> >> >>> This seems to be related to the issue reported for Postgres[1]. >> >>> Could you please try installing Bloodhound from the subversion >> repository >> >>> (trunk), Anze implemented a fix in r1505666 which may help. >> >>> >> >>> [1] - https://issues.apache.org/bloodhound/ticket/601 >> >>> >> >>> -- >> >>> matevz >> >>> >> >>> >> >> >>
