[p4] Duplicate column issue while integrating P4DTI

[Shambhu Sharma]

Hi,

     I am getting following error while integrating P4DTI with
Bugzilla-3.0.2. I don't have any idea about database. Please help me out.

2007-11-15 11:02:12 UTC  (P4DTI-1193)  Old P4DTI/Bugzilla schema version 4
detected; altering tables to upgrade to schema version 5.
Traceback (most recent call last):
 File "check.py", line 22, in ?
   from init import r
 File "/usr/share/p4dti-bugzilla-2.4.2/init.py", line 135, in ?
   config = configure_module.configuration(config)
 File "/usr/share/p4dti-bugzilla-2.4.2/configure_bugzilla.py", line 578, in
configuration
   config.bugzilla = bugzilla.bugzilla(db, config)
 File "/usr/share/p4dti-bugzilla-2.4.2/bugzilla.py", line 57, in __init__
   self.update_p4dti_schema()
 File "/usr/share/p4dti-bugzilla-2.4.2/bugzilla.py", line 1039, in
update_p4dti_schema
   self.execute(sql)
 File "/usr/share/p4dti-bugzilla-2.4.2/bugzilla.py", line 102, in execute
   self.cursor.execute(sql)
 File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 137, in
execute
   self.errorhandler(self, exc, value)
 File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 33,
in defaulterrorhandler
   raise errorclass, errorvalue
**_mysql_exceptions.OperationalError: (1060, "Duplicate column name
'completed'")**

-- 
If linux doesn't have a solution, then u have a wrong problem.

Shambhu Kumar Sharma
Arada Systems
91-98864 91913