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
