AttributeError when using TicketImportPlugin in Trac 1.2

[Jacob]

When I try importing a file in Trac 1.2, I get:

Trac detected an internal error:

AttributeError: 'Environment' object has no attribute 'get_db_cnx'

[François Granade]

hi, we haven't updated this plugin to work with the latest versions of Trac; in fact it hasn't been maintained for a few years... If there is still some interest to it, I could work at upgrading it, I don't think it should be too difficult. Please tell me how important it is to you. In particular: are there other, more recent, better maintained, plugins that would do the job ? if yes, please use them; if not, tell me and I'll try to work on it. Thank !

[Jun Omae]

Hi farialima,

I worked to make compatible with Trac 1.1.2+ two years ago. I resume it. Thanks.

[Jacob]

The plugin is important enough for me that I've decided to not upgrade to 1.2 until I can get it and a few other business-critical plugins working.

I should have mentioned that it was version 0.8.3 of TicketImport 0.8.3 that was causing the error, I couldn't find a more recent version.

Batch Modify does some of what I need, but not everything. I actually don't understand why Trac would have a built-in export function (i.e. ability to download results as CSV) without also having a built-in import function...

The only other plugin I could find that does something similar is ExportImportXlsPlugin. I tried it but that didn't work either (although it broke differently), and I prefer TicketImportPlugin's simplicity.

Thanks to both you! Looking forward to the update, and I can help test it for you.

[Jun Omae]

I just create proposed patch, ​https://github.com/jun66j5/ticketimportplugin/compare/master...t12931.diff.

[Jacob]

How do I install it? I'm used to using easy_install or Python eggs

[Jun Omae]

You could download patched source via ​https://github.com/jun66j5/ticketimportplugin/archive/t12931.zip.

[Jacob]

I tried installing the patch:

easy_install ticketimportplugin-t12931/

Processing
Writing /tmp/ticketimportplugin-t12931/setup.cfg
Running setup.py -q bdist_egg --dist-dir /tmp/ticketimportplugin-t12931/egg-dist-tmp-04tNho
TicketImport 0.8.3 is already the active version in easy-install.pth

Installed /usr/local/lib/python2.7/dist-packages/TicketImport-0.8.3-py2.7.egg
Processing dependencies for TicketImport==0.8.3
Finished processing dependencies for TicketImport==0.8.3

And when I try an import, Internal Error is still happening.

[Jun Omae]

And when I try an import, Internal Error is still happening.

Please post the errors with stacktrace after enabling TracLogging.

[Jun Omae]

Replying to jun66j5:

And when I try an import, Internal Error is still happening.

Please post the errors with stacktrace after enabling TracLogging.

Works for me. Confirmed with Trac 1.2 and the t12931.zip.

[Jacob]

Did I install the patch properly?

Is it normal that it says 0.8.3 is already the active version?

Could this be a conflict with a different plugin?

[Jun Omae]

Please post the errors with stacktrace after enabling TracLogging.

Also,

1. You should uninstall un-patched TicketImportPlugin first.
2. Confirm missing Import tab in navigation menu after the plugin is uninstalled
3. Install t12931.zip

[Jacob]

Ok. Followed your steps outlined above.

There is progress. I am now able to preview the import file, and cancel the import without errors, but if I instead choose to go ahead and Execute Import, I get the same AttributeError.

I've attached the stacktrace, the error is at the end.

[Jacob]

stacktrace of AttributeError on Execute Import with patch t12931

[Jun Omae]

That's a MasterTicketsPlugin issue. Retry after uninstalling MasterTicketsPlugin.

  File "/usr/local/lib/python2.7/dist-packages/Trac-1.2-py2.7.egg/trac/ticket/model.py", line 397, in save_changes
    listener.ticket_changed(self, comment, author, old_values)
  File "/usr/local/lib/python2.7/dist-packages/TracMasterTickets-3.0.5dev_r12950-py2.7.egg/mastertickets/api.py", line 117, in ticket_changed
    db = self.env.get_db_cnx()
AttributeError: 'Environment' object has no attribute 'get_db_cnx'

[Jun Omae]

  File "/usr/local/lib/python2.7/dist-packages/Trac-1.2-py2.7.egg/trac/ticket/model.py", line 397, in save_changes
    listener.ticket_changed(self, comment, author, old_values)
  File "/usr/local/lib/python2.7/dist-packages/TracMasterTickets-3.0.5dev_r12950-py2.7.egg/mastertickets/api.py", line 117, in ticket_changed
    db = self.env.get_db_cnx()
AttributeError: 'Environment' object has no attribute 'get_db_cnx'

See #12193.

[Jacob]

You're right. If I disable MasterTicketsPlugin, I can now import successfully. Yes!

[Jun Omae]

In 15948:

ticketimportplugin: add support of Trac 1.1.2+ (closes #12931)

[Jun Omae]

In 15949:

ticketimportplugin: add missing file (refs #12931)