# Ticket #10206 (assigned defect)

Opened 10 months ago

## Duplicate column name "comment"

Reported by: Assigned to: roberts.noah@gmail.com rjollos (accepted) normal WorkLogPlugin normal 0.12

After I installed your plugin at the system level, and enabled it for one of my projects, I get an error from trac upon looking at any trac page linked to that project:

Error

TracError: OperationalError: duplicate column name: comment


Editing trac.ini to remove the worklog plugin enable statements fixes the project. Other enabled plugins are:

autoupgrade.autoupgrade.autoupgrade = enabled
batchmod.web_ui.batchmodifymodule = enabled
childtickets.childtickets.tracchildticketsmodule = enabled
coderev.api.codereviewersystem = enabled
coderev.web_ui.changesetticketmapper = enabled
coderev.web_ui.codereviewermodule = enabled
coderev.web_ui.committicketreferencemacro = enabled
mastertickets.api.masterticketssystem = enabled
mastertickets.web_ui.masterticketsmodule = enabled
simplemultiproject.environmentsetup.smpenvironmentsetupparticipant = enabled
simplemultiproject.milestone.smpmilestoneproject = enabled
simplemultiproject.model.smpmodel = enabled
simplemultiproject.ticket.smpticketproject = enabled
simplemultiproject.timeline.smptimelineprojectfilter = enabled
simplemultiproject.version.smpversionproject = enabled
tracbzr.backend.bzrconnector = enabled
tracbzr.backend.bzrpropertyrenderer = enabled
tracbzr.backend.bzrwikimacros = enabled
tracopt.ticket.deleter.ticketdeleter = enabled
tracrpc.api.xmlrpcsystem = enabled
tracrpc.json_rpc.jsonrpcprotocol = enabled
tracrpc.search.searchrpc = enabled
tracrpc.ticket.componentrpc = enabled
tracrpc.ticket.milestonerpc = enabled
tracrpc.ticket.priorityrpc = enabled
tracrpc.ticket.resolutionrpc = enabled
tracrpc.ticket.severityrpc = enabled
tracrpc.ticket.statusrpc = enabled
tracrpc.ticket.ticketrpc = enabled
tracrpc.ticket.typerpc = enabled
tracrpc.ticket.versionrpc = enabled
tracrpc.web_ui.rpcweb = enabled
tracrpc.wiki.wikirpc = enabled
tracrpc.xml_rpc.xmlrpcprotocol = enabled
whiteboard.web_ui.whiteboardmodule = enabled


## Change History

### 07/30/12 03:12:20 changed by rjollos

• description changed.

### (follow-up: ↓ 3 ) 07/30/12 04:31:03 changed by rjollos

I can reproduce. The plugin looks like it needs a bit of work to make it compatible with Trac 0.12.

### (in reply to: ↑ 2 ) 10/01/12 23:09:34 changed by anonymous

I can reproduce. The plugin looks like it needs a bit of work to make it compatible with Trac 0.12.

me too

### 10/02/12 03:17:57 changed by rjollos

• status changed from new to assigned.
• owner changed from coling to rjollos.

I posted an explanation in comment:3:ticket:10251 of some recent errors on my part. Please test the latest check-in and report back, if you can.

The upgrade was failing without being entirely rolled back, and I'm not sure I know how to fix this issue. If you continue to have trouble, and you have not used the plugin yet and therefore don't have any data in your tables, I suggest just dropping the table.

DROP TABLE "main"."work_log"


### 10/02/12 03:23:28 changed by rjollos

(In [12089]) Refs #10206, #10251:

• Made the trunk compatible with Trac 0.11, by rolling out changes introduced in [9480] and later. There is nothing forcing us to adapt to the new Trac DB API at the moment, and it is easier to maintain a single code-base that is compatible back to Trac 0.11. The Trac DB API changed again in 1.0, so we are better off waiting and adapting to that API down the road anyway.
• Attempted to cleanup the mess of import statements in every module. Modified the entry_points to adapt to these changes.
• Made the XmlRpc lib an optional component. There is more work to do here still.

### 10/02/12 03:33:18 changed by rjollos

(In [12090]) Refs #10206, #10251:

• Renamed timeline_hook.py to timeline.py, with the goal of making the source code layout match the standard for Trac plugins.
• Fixed an error introduced in [12089] due to a missing import.

As in [12088], if your trac.ini file specifies the individual components to enable, you'll have to make the following change:

worklog.timeline_hook.worklogtimelineaddon = enabled


->

worklog.timeline.worklogtimelineeventprovider = enabled


### Add/Change #10206 (Duplicate column name "comment")

Change Properties