Edgewall Software

{10} Assigned, Active Tickets by Owner (Full Description) (72 matches)

anonymous (3 matches)

Ticket Summary Component Milestone Type Severity Created
Description
#7391 renamed plugin disable commands in trac.ini [components] silently fail, a security issue admin/web 0.11.2 defect critical 06/30/2008

On upgrading to trac 0.11, I found I had to rename:

   webadmin.plugin.pluginadminpage=disabled

to

trac.admin.web_ui.PluginAdminPanel=disabled

The problem here is that I found this by noticing that trac 0.11 was allowing uploads.

There was no complaint about the old disabled line not being relevant any more, and no upgrade documentation to warn that if we locked things down in webadmin we now need to rename the lines in the config file.

I think the lack of warning (in code or in documentation) is a security risk to people upgrading.


#5718 Add a direct "raw" download link to the attachments section of a ticket view. general 0.13 enhancement minor 07/17/2007

When creating a bug ticket, our customers oftentimes attach project files that illustrate the problems. It would save our developers time to be able to download these attachments with one click (instead of a click, a scroll down, another click, and a back-button press).


#7499 Notification mail header "Precedence" should be configurable notification defect normal 08/04/2008

I want to use Trac to notify a mailing list of ticket change.

Every time when Trac send email I got this error/success in the mail log:

delivery 1118: success: Precedence:_junk_-_message_ignored/did_0+0+1/

To bypass this we have to comment in notification.py

headersPrecedence? = 'bulk'

It should be great if you can include this as a config option in feature version.

Thanks


athomas (3 matches)

Ticket Summary Component Milestone Type Severity Created
Description
#710 Add basic time tracking ticket system 0.13 enhancement normal 08/23/2004

I would like trac to have basic time reporting as a module.

The (logged in) user should be able to add that he/she worked for X hrs with something and add a short description of what. This time report could refer to a ticket and/or a changeset.

I am not familiar with the internals of trac, but I think that this could just be a new table in the DB and some basic templates/function to add and view data.


#925 [PATCH] Allow wiki syntax in labels for custom fields ticket system 0.13 enhancement normal 11/13/2004

The proposal is to add a possibility to use Wiki syntax in labels for custom fields.

Example 1: We need to put emphasis on Platform field

[ticket-custom]
platform         = select
platform.order   = 1
platform.label   = '''Platform'''
platform.options = |Intel P4|Intel XEON|AMD Athlon 64|Other

Example 2: We need to define a link to help screen for Platform field

[ticket-custom]
platform         = select
platform.order   = 1
platform.label   = [wiki:HelpPlatform Platform]
platform.options = |Intel P4|Intel XEON|AMD Athlon 64|Other

Attached patch contains an implementation for the proposal.


#6680 The authz_policy.py sample is only a *sample* admin/console 0.11.2 defect normal 01/20/2008

I had some trouble with setting up a policy where the anonymous user could see only the front page of the wiki (wiki/WikiStart), but not the rest of the wiki without further authorisation through logging in. I used the authz_policy.py and had the following in the associated authz file:

[groups]
superdevs = me

[wiki:WikiStart]
anonymous = WIKI_VIEW

[wiki:*]
anonymous =

[*]
@superdevs = TRAC_ADMIN
anonymous = MILESTONE_VIEW, ROADMAP_VIEW, TIMELINE_VIEW

According to the docs in the authz_policy.py file, order of the directives mattered. The first directive should have allowed anonymous visitors access to the front page, while the second directive dissallowed anonymous browsing of the rest of the wiki. Instead, this resulted in an error:

No handler matched request to /wiki/WikiStart

I talked to "aat" on the IRC channel and he came up with the following:

the issue is that trac checks for access to AT LEAST ONE resource
in a realm by just checking if the user has the permission on <realm>

"aat" also provided a patch and stated that he would try and come up with something better soon.

Everyone seems to agree that someone should create a trac hack out of this. Anyone out there have copious amounts of free time for that?


cboos (17 matches)

Ticket Summary Component Milestone Type Severity Created
Description
#7316 Timeline RSS entries truncated timeline 0.11.3 task critical 06/09/2008

In all previous versions of Trac, you could have the entries in the HTML timeline be truncated so that the timeline remains compact and readable, but still get the full entry text in the RSS feed. That behavior makes a lot of sense because you normally consume RSS feeds by reading one item a time, so you can afford to have the full text displayed. The new behavior requires one to visit the corresponding page to read the full text for the vast majority of check-ins, tickets, etc.

It should be possible to configure the timeline to show truncated entries in the HTML version and non-truncated entries in the RSS version. And this should be the default, as it has been in the past.

Personally, I think this is a fairly serious bug that severely limits the usefulness of the timeline RSS feed in 0.11.


#4431 wiki_to_wikidom wiki system 0.13 enhancement major 12/20/2006

It would be good for plugins if parsing of wiki text will be broken to two stages. first take the text and convert to some data object tree (ala DOM, but with wiki orientation, so nodes are 'text', 'macro', 'link' etc.), then different formatters can go over the tree and format it, and plugins can search it.


#3332 Mimeview API v2 general 0.13 enhancement critical 06/27/2006

We recently introduced the IContentConverter interface, and there are some issues remaining with this:

  • the methods for that interface are quite complex, not really extensible
  • the usage of strings for model objects should be replace by using the corresponding classes
  • artificial differences from the IHTMLPreviewRenderer, and duplicated code (mainly between Mimeview.render and Mimeview.convert_content)

Besides, there are other issues with the Mimetype API:

  • content_to_unicode needs to be deprecated/simplified as well
  • simplify the handling of mimetypes strings (the fact that they sometimes have the charset info, sometimes not)
  • in general, aim to simplify the code that uses the mimeview API

Work in progress. A patch will be attached today or tomorrow for review.


#3446 Rate of `database is locked` errors is too high general not applicable defect major 07/21/2006

I still get way too many database is locked errors. This morning, I simply tried to log in and the server was not loaded (approx. half of the threads were "_" Waiting for connection).

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 314, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 186, in dispatch
    req.session = Session(self.env, req)
  File "/usr/lib/python2.3/site-packages/trac/web/session.py", line 52, in __init__
    self.promote_session(sid)
  File "/usr/lib/python2.3/site-packages/trac/web/session.py", line 125, in promote_session
    "AND authenticated=0", (sid,))
  File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/trac/db/sqlite_backend.py", line 44, in execute
    args or [])
  File "/usr/lib/python2.3/site-packages/trac/db/sqlite_backend.py", line 36, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: database is locked

Jonas/Christopher, can one of you attach a recent gzipped dump of the t.e.o Trac log here? I'd like to make some stats about the locks frequency. Ideally I'd like to understand why this still happens so frequently and find ways to improve the situation...

Beside locks, I'm also frequently seeing blank pages when going on the Markup Trac. But probably that's a different issue.


#425 Wiki page name need to support digits and periods wiki system 1.0 enhancement normal 05/19/2004

Restricting Wiki page names to only alphabetic chars makes it very have to create pages that discuss MilestoneV1.0 etc

Is there any problem with allowing digits and period?


#1024 Each section should have a edit button wiki system 0.13 enhancement normal 12/08/2004

ie http://www.splitbrain.org/dokuwiki/wiki:dokuwiki


#5516 Improve semi-automatic bug reporting general 0.11.2 enhancement normal 06/14/2007

... before releasing 0.11.

The improved error report generates wikified data that users are not able to report properly on trac.edgewall.org.
This new report leads to badly formatted bug reports, which requires manual fix (time consuming, error prone).

I'm not sure how to fix this problem, but 0.11 should not be released before the error report is improved.


#7173 spam-filter-captcha should not require reentering a ticket after resolving an equation plugin/spamfilter not applicable enhancement normal 04/29/2008

I am now able to use the non-image spam-filter-captcha handler. However, after resolving the equation, I have to start over with a new ticket. Assuming that the person spent a long time submitting the ticket, it would probably be preferable to submit the ticket that they were trying to fill out the first time.

This is a follow up to #7148


#2086 better support for multiple repositories version control/browser 0.13 enhancement major 09/19/2005

Trac does not support multiple source repositories in a single Trac instance; this is limiting for some projects that have different branches is separate repositories.

Also, other version control systems has a notion of branch == repo == working directory, resulting in that Trac will only be able to follow a single branch.

To solve this probably a repo member has to be added to the revision and node_change tables. The Repository class also has to know about the repository name, so it can query the tables correctly.


#7076 [patch] Treat RTF files with .doc extension as binary attachment 0.11.3 defect minor 04/03/2008

Some .doc files have an application/rdf mime type, e.g. Abiword export-as-doc actually saves a RTF file with a .doc filename. These files are not handled correctly by the Trac MIME viewer, since those RTF files are incorrectly shown as text. The special handling code for RTF (and PostScript and PDF) does not catch this case.

The fix is quite simple:

  • Detect .doc and .dot files as application/msword
  • Add application/msword to the TREAT_AS_BINARY list

Trivial patch below:

--- trac/mimeview/api.py.orig	2008-04-03 23:24:33.000000000 +0200
+++ trac/mimeview/api.py	2008-04-03 23:24:40.000000000 +0200
@@ -76,6 +76,7 @@
     'application/pdf':        ['pdf'],
     'application/postscript': ['ps'],
     'application/rtf':        ['rtf'],
+    'application/msword':     ['doc', 'dot'],
     'application/x-sh':       ['sh'],
     'application/x-csh':      ['csh'],
     'application/x-troff':    ['nroff', 'roff', 'troff'],
@@ -674,7 +675,8 @@
     TREAT_AS_BINARY = [
         'application/pdf',
         'application/postscript',
-        'application/rtf'
+        'application/rtf',
+        'application/msword',
     ]
 
     def get_quality_ratio(self, mimetype):

Please include this in your upcoming releases.

Sincerely,

Wouter Bolsterlee <uws@…>


#508 'Related checkins' feature ticket system 1.0 enhancement normal 06/03/2004

In CVSTrac, a ticket has a field called "Related Checkins" which shows a list of checkins (they would be changsets in trac) and their comments.

You can add and remove from this list by editing a comma-seperated list of related checkins.

However, the most useful part, is that by putting a ticket number into your checkin message, it automatically adds that checkin to the "Related Checkins" of the ticket.

Eg. svn commit -m 'Added the ability to edit existing tickets. This fixes ticket #411'

Then when you view the ticket #411 you can see that checkin there without doing any more work.

This feature made CVSTrac sooo useful, because it was very easy to make this connection from the ticket to the checkins that attempted to fix it.

bonus marks:

The whole idea of two-way linking useful in general -- once you had this feature you might also show wiki pages linking to a ticket, or tickets linking to a wiki page. Often with information given by people, the incoming links are as relevant as the outgoing ones.

BUT the automatic pingback from the checkins to the tickets is by far the most useful!


#1242 [ER] Generalized automatic cross-references in Trac general experimental enhancement normal 03/03/2005

Problem

Trac provides a fast, easy and flexible way to relate Trac objects together, by the use of TracLinks in the WikiFormatting.

However, there's no automatic support for back-linking. This lack has been noticed in several circumstances:

  • BackLinks for Wiki pages (tickets #611 and #646, the latter containing a [http:/trac/ticket/646#change_4 note] which also highlights the genericity of the problem)
  • Related Changesets for a given Ticket (ticket #508)
  • Ticket dependencies and other relationships (tickets #31 and #226)

Instead, the backlinking is done manually. For example, when closing a ticket with a resolution of duplicate, the convention is to comment the closing of the ticket by saying this is a duplicate of #xyz and to mention the existence of the duplicate ticket on the original #xyz ticket. With a generalized backlinking facility, this would cease to be necessary.

Solution

What I would propose is that every relationship that gets detected while parsing new wiki content is recorded. Then, each wiki, changeset and ticket page could contain a See also: section at the end, listing the other objects that contain TracLinks targeting it, along with a bit of context, to catch the semantic of the link as well.


Example given:

Consider the following wiki OutstandingPatches page:

= Outstanding Patches page = 

I think that the patches #187, #909, #919, #944 and #948 are great!

Then, each time this page is edited, the content of an XREF (source, target, context table would be cleared for this page:

delete from XREF where source = 'wiki:OutstandingPatches'

and when the content is processed, each time a TracLink is detected, the table would be filled:

insert into XREF values ('wiki:OutstandingPatches',
                         'ticket:187',
                         'I think that the patches #187, #909, #919, #944 and #948 are great!')

Then, while browsing #187, one could easily get the backlinks:

select source, context from XREF where target='ticket:187'

in order to create the following output at the end of the ticket page:

Backlinks: OutstandingPatches

Of course, I'm willing to provide a patch for that, but I would like to get some feedback before.

-- Christian


#5246 [PATCH] Use permission system to store groups for authz access control version control/browser 0.13 enhancement normal 05/02/2007

We're currently using LDAP to store our users and groups. Our problem with using Subversion-style authz files for restricting access in Trac is that we'd have to define group memberships again in the authz file itself - thus we'd have to manage group memberships twice: Once in LDAP, once in the authz file (we're currently NOT using an authz file for Subversion itself for exactly this reason - we're doing it the "hard way" via Apache configuration instead). Basically, this issue is #4224 the other way 'round.

In this context, it would be great if the authz module could simply use the built-in permission system of Trac to retrieve the groups a user belongs to - and not the authz file.

I've written a patch that adds a configuration option authz_use_perm_groups that's false by default, resulting in the current behaviour. If set to true, Trac will not care about the groups section of the authz file and use the PermissionSystem? to retrieve the group names instead (currently by fetching all lower-case permissions for the current user and stripping an eventual @ in front of the group name). I don't know much about the internal design of Trac so my code is probably quite ugly - but at least it works. Feel free to find a nicer solution. :-)

Please note that this patch would interfere with #4997 since Subversion itself does not implement any of this.


#108 OrphanedPages wiki system 1.0 enhancement normal 03/02/2004

It would be good to have a list of pages that aren't linked to from anywhere.

Example: http://moinmoin.wikiwikiweb.de/OrphanedPages


#109 MissingLinks, an index over missing wiki pages wiki system 1.0 enhancement normal 03/02/2004

It would be good to be able to list all links that lead to non-existing pages.

Also true for tickets and changesets of course.

Example: http://moinmoin.wikiwikiweb.de/WantedPages


#7055 Add "toggle line numbers" JavaScript to source browser general 0.12 enhancement normal 03/27/2008

At the moment when you copy-n-paste code snippets from Trac's source browser (I often do) it also copies the line numbers, which is almost never what you want. To get code without the line numbers, you have to scroll down and click the "Plain Text" version, find your place again, and then do the copy and paste.

It'd be nice if the Trac source file browser had a little JavaScript link, called "Toggle line numbers", that toggled the line numbers on and off, making copy-n-paste really clean and simple. (The toggle link could be placed in the table cell to the right of the "Line" heading cell at the top-left of the table.)

See the further discussion (agreement?) on the trac-users group: http://groups.google.com/group/trac-users/browse_frm/thread/71da6e9b5554b89c

It shouldn't be much code, especially with jQuery -- Ted Gifford posted one possible solution: http://groups.google.com/group/trac-users/msg/846b21eb4e550e0a?dmode=source

Also see a somewhat related discussion on ticket:5779 about a "toggle line numbers" link in the diff viewer. They decided against it there, as normally you shouldn't need to copy-n-paste just a few lines of a diff or patch. (I find it's much more common with full source files, so believe the arguments against it for the diff viewer don't hold for the source viewer.)

BTW, not that I'd use it much, but I really like the operation of the "Tabular/Unified" button for the diff viewer in the new version of Trac. See an example of it at changeset:6599.

---Ben Hoyt (benhoyt.com)


#5710 add link to last change to browse version control/browser 0.13 enhancement minor 07/14/2007

when browsing the source, the comment of the last change is displayed for every folder, and the revision. it would be nice if one could get to the last change set with one click, e.g. clicking on the changesets comment.


cmlenz (2 matches)

Ticket Summary Component Milestone Type Severity Created
Description
#2581 Add Paste Deploy support to the WSGI branch general 0.11.3 enhancement normal 01/10/2006

Attached is a patch (against the sandbox/wsgi branch) that implements a Paste Deploy entry point for trac. Using the sample deployment file (in the patch in docs/sample_deploy.ini) you can do:

paster serve docs/sample_deploy.ini

To get a working server. The configuration in that file just points to the Trac project directory, it doesn't put any of Trac's configuration in that file. The server in the sample is WSGIUtils, but any server can be used (e.g., flup's FastCGI or SCGI servers). The sample file also wraps the app in paste.lint, which checks for WSGI compliance (you wouldn't use this normally, but for testing and development it is useful).

This also changes setup.py to use setuptools, because that is needed for entry points. Strictly speaking this would not be necessary (you can just put paste.app_factory = trac.web.main:paste_app_factory in the deployment configuration instead of use = egg:Trac). But, eh. I'm a little surprised Trac isn't using setuptools already. Just changing the import from distutils.core to setuptools seems to work well enough for me.

Also two bugs are fixed; one when subdirectories of parent_dir are not loadable, and one for parent_dirs itself.

I haven't implemented env_paths in this patch -- it would probably mean collecting all the configuration variables and parsing them a bit (but would certainly be doable). I'm not sure what the threadsafety of Trac is, but if dispatch_request could be entered from multiple threads with different trac.env_path values and work that way, other dispatchers (like Paste#urlmap) could be used in addition to env_paths. It looks like Trac is probably already ready to be used like this (if it doesn't use globals to communicate configuration).


#3754 retarget open tickets to other milestone of choice - Webadmin admin/web 0.11.3 enhancement normal 09/20/2006

This would be the same functionality as #2743 for the main trac (r3372 & r3732). I prefer to work with the webadmin and I would like to see this feature also in the webadmin.

Closing a milestone manually should retarget open tickets to other milestone of choice. This should be very similar to deleting a milestone.


eblot (3 matches)

Ticket Summary Component Milestone Type Severity Created
Description
#1359 Add ticket change email headers to allow more intelligent filtering of ticket notification emails notification 0.13 enhancement normal 03/26/2005

Basically, Trac sends (if configured properly) emails to the users each time a ticket is modified. In my case, I wanted to filter the tickets a bit, to identify tikets being closed or assigned to me.

Unfortunately, if your mail goes to an IMAP server without server filters, most email clients can't filter on the contents of the body, where the specific field changes are enumerated. Plus that would be, well, ugly.

This change adds additional X-Trac email headers each time a ticket is changed.

These headers are of the format:

X-Trac-Ticket-Change-<field>

with the new value of the field as the header value.

This allows for easy client side filtering, nd handles the case when multiple changes are made in one submission (you get multiple headers in the email, 1 per field)

Thanks for watching!


#3162 LDAP support for e-mail notification notification 0.13 enhancement normal 05/17/2006

When using trac with LDAP authorization it would be nice if LDAP is also used for getting the e-mail address of logged in users (this feature should probably be settable using some trac.ini parameters).

I do not know howto read trac.ini parameters so I added a few lines to Notify.py Maybe somebody can use this.


#6556 RSS feed is not valid report system 0.11.2 defect normal 12/26/2007

I have an Trac 0.11b1 installation and want to subscribe to RSS feed for tickets i need to monitor. But RSS feed is not visible within NetNewsWire? Lite (v3.1b4). But its visible in Vienna (v.2.2.2.2212)... So i make a decicion that RSS feed have some "not-fatal" error within ('cause NNW is know as strict RSS reader) while Vienna allow and display this feed. I can't check feed with online validator - i have intraweb Trac so can't say exactly where is error is. Feed from this site is displayed well in NNW (i try this link http://trac.edgewall.org/report/20?format=rss&USER=anonymous)


ecarter (1 match)

Ticket Summary Component Milestone Type Severity Created
Description
#1333 New tickets should have a default owner ticket system 0.11.3 defect minor 03/22/2005

I think that when a ticket is raised it should be assigned to someone by default, as external bug reporters are not likely to know the names of developers on the project (and hence may leave new tickets unassigned). For example, I would not know who this ticket should be assigned to, and as such I haven't assigned it to anyone when raising it.

If a team is using email notification as their primary process for discovering new tickets, an unassigned ticket will not be discovered.

I think this could be solved in a number of ways, one is to notify one user delegated as the project manager.

Another solution may be related to #870.

Yet another might just be to document this and recommend users set up reports to deal with this problem.


jhampton (2 matches)

Ticket Summary Component Milestone Type Severity Created
Description
#6811 Plugin TimingAndEstimation not shown when installed under non standard location web frontend/mod_python not applicable defect normal 02/11/2008

I have trac 0.11b1 running with mod_python on Apache 2.2. I have installed trac to a different location than default, since in our /usr/lib/python2.4/site-packages is another trac installation present.

Now a problem arises when using the plugin TimingAndEstimation?. The plugins version is 0.6.2.

It seems it cannot be installed under the location which differs from the default python site-packages dir. We have put it into /usr/local/trac/trac-0.11b1/lib/python2.4/site-packages where also the desired trac installation resides. But then the plugin won't be shown up in the admin/plugins page on trac webui.

We can't put the plugin up to /usr/lib/python2.4/site-packages due to some interference with the other installation of trac on that system, though everything works fine then.

So have you got ideas how we could tell our mod_python/Apache to have a look into /usr/local/trac/trac-0.11b1/lib/python2.4/site-packages to recognize the plugin?


#7326 post-commit-hook doesn't fire if command and ticket number on different lines version control defect normal 06/11/2008

We were having intermittent mysterious failures of post-commit-hook, where the commit succeeded and seemed correctly worded but the changeset wasn't reflected in the ticket. We finally noticed that in the cases where it wasn't working, something had introduced a line break between the "fixes" or "closes" or "refs" and the ticket number.

The obvious workaround is not to break the command and ticket number across lines, but we don't do it intentionally; svn or something is wrapping things at 80 columns for us, thereby introducing line breaks at arbitrary spots.

In consultation on #trac, we came up with the fix of replacing the .? (any single character) at the end of the action with \s* (any whitespace, including newline), which makes a little more sense to me anyway. But that breaks the "fixes:1234" syntax for some reason. This is at the end of this line.

I don't have time to test more permutations, alas. But hopefully this will get someone started on handling multiline commit messages in trac-post-commit-hook.


jruigrok (36 matches)

Ticket Summary Component Milestone Type Severity Created
Description
#1513 Multi-language support in the wiki wiki system 2.0 enhancement normal 05/06/2005

Let trac be the first-ever multi-lingual wiki on the market! Have the ability to translate wiki articles into different languages. A user can select their language when they view the wiki. We have looked around and there isnt a wiki out there that handles this. And if you dont have time to do it, do you mind having some volunteers help you out? :)


#280 Add support for internationalization of templates general 0.12 enhancement major 04/22/2004

Add support for multilingual templates


#2709 bugzilla2trac should convert descriptions LF->CRLF general not applicable defect minor 02/01/2006

The first time any of my bugzilla2trac-ed tickets was changed in any way, the description showed as spuriously changed - this was because all the LFs were translated to CRLFs somewhere in doing the round-trip between the web-browser and server.

To prevent this, bugzilla2trac should convert descriptions (and probably comments too) from LF line endings to CRLF line endings before storing them in the trac database.


#5278 ValueError: empty string for float() after migrating tickets from Bugzilla To Trac ticket system defect normal 05/08/2007

I have run Bugzilla2Trac and after an issue eventually got the Bugzilla tickets migrated. The first issue was

Traceback (most recent call last):
  File "C:\Python24\Scripts\bugzilla2trac.py", line 887, in ?
    main()
  File "C:\Python24\Scripts\bugzilla2trac.py", line 884, in main
    convert(BZ_DB, BZ_HOST, BZ_USER, BZ_PASSWORD, TRAC_ENV, TRAC_CLEAN)
  File "C:\Python24\Scripts\bugzilla2trac.py", line 780, in convert
    trac.addTicketChange (**ticketChange)
  File "C:\Python24\Scripts\bugzilla2trac.py", line 394, in addTicketChange
    (ticket, time.strftime('%s'), author, field,
  File "C:\Python24\Lib\site-packages\trac\db\util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "C:\Python24\Lib\site-packages\trac\db\sqlite_backend.py", line 56, in ex
ecute
    args or [])
  File "C:\Python24\Lib\site-packages\trac\db\sqlite_backend.py", line 48, in n_error
    return function(self, *args, **kwargs)
pysqlite2.dbapi2.IntegrityError: columns ticket, time, field are not unique

I got around this by introducing OR IGNORE in the INSERT INTO ticket & INSERT INTO ticket_changes clause. This migrated the changes

However when I go to Trac and click on "View Tickets" and select "All Tickets By Milestone (Including closed)" I get the following error

Traceback (most recent call last):
  File "C:\Python24\Lib\site-packages\trac\web\main.py", line 387, in dispatch_request
    dispatcher.dispatch(req)
  File "C:\Python24\Lib\site-packages\trac\web\main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "C:\Python24\Lib\site-packages\trac\ticket\report.py", line 88, in process_request
    resp = self._render_view(req, db, id)
  File "C:\Python24\Lib\site-packages\trac\ticket\report.py", line 346, in _render_view
    value['date'] = format_date(cell)
  File "C:\Python24\lib\site-packages\trac\util\datefmt.py", line 68, in format_date
    return format_datetime(t, format, gmt)
  File "C:\Python24\lib\site-packages\trac\util\datefmt.py", line 58, in format_datetime
    t = time.localtime(float(t))
ValueError: empty string for float()

#5469 Translation of Trac to Spanish/Español [es_ES] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Spanish.


#5470 Translation of Trac to Portuguese/Português [pt_PT] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Portuguese.


#5471 Translation of Trac to Japanese/日本語 [ja_JP] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Japanese/日本語.


#5472 Translation of Trac to Chinese/中文 [zh_CN] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Chinese.


#5473 Translation of Trac to Dutch/Nederlands [nl_NL] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Dutch.


#5474 Translation of Trac to French/Français [fr_FR] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to French.


#5475 Translation of Trac to German/Deutsch [de_DE] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to German.


#5477 Translation of Trac to Korean/한국어 [ko_KR] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Korean/한국어. See also TracTermsKo.


#5478 Translation of Trac to Russian/Русский [ru_RU] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Russian/Русский. See also TracTermsRu.


#5479 Translation of Trac to Latvian/Latviešu [lv_LV] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Latvian. See also TracTermsLv.


#5480 Translation of Trac to Polish/Polski [pl_PL] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Polish. See also TracTermsPl.


#5481 Translation of Trac to Greek/Ελληνικά [el_GR] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Greek/Ελληνικά. See also TracTermsEl.


#5482 Translation of Trac to Traditional Chinese/正體中文 [zh_TW] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Traditional Chinese/正體中文. See also TracTermsZhTw.


#5486 Translation of Trac to Hungarian/Magyar [hu_HU] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Hungarian/Magyar. See also TracTermsHu.


#5487 Translation of Trac to Swedish/Svenska [sv_SE] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Swedish/Svenska. See also TracTermsSv.


#5488 Translation of Trac to Turkish/Türkçe [tr_TR] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Turkish/Türkçe. See also TracTermTr.


#5489 Translation of Trac to Italian/Italiano [it_IT] i18n 0.12 task normal 06/11/2007

This ticket should be used to coordinate the translation to Italian. See also TracTermsIt.


#5585 bugzilla2trac does not work with bugzilla 3.0 ticket system 0.13 defect normal 06/23/2007

The bugzilla2trac.py script does nto seem to work with bugzilla 3.0. Using the default version number nor a version of '3' will function. However, it should be noted that using the default bugzilla version in the script, actually gets farther along in the import before failing.

Using Bugzilla v3 schema.
Bugzilla MySQL('*':'*':'*':'*******'): connecting...
Trac SQLite('/home/trac/projects/signin'): connecting...

Cleaning all tickets...
All tickets cleaned...

0. Filtering products...
Traceback (most recent call last):
  File "bugzilla2trac.py", line 894, in <module>
    main()
  File "bugzilla2trac.py", line 891, in main
    convert(BZ_DB, BZ_HOST, BZ_USER, BZ_PASSWORD, TRAC_ENV, TRAC_CLEAN)
  File "bugzilla2trac.py", line 505, in convert
    mysql_cur.execute("SELECT product AS name FROM products")
  File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 164, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.5/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'product' in 'field list'")
Using Bugzilla v2180 schema.
Bugzilla MySQL('*':'*':'*':'*******'): connecting...
Trac SQLite('/home/trac/projects/signin'): connecting...

Cleaning all tickets...
All tickets cleaned...

0. Filtering products...
  Using products Signin

1. Import severities...
  inserting severity 'blocker' - '1'
  inserting severity 'critical' - '2'
  inserting severity 'major' - '3'
  inserting severity 'normal' - '4'
  inserting severity 'minor' - '5'
  inserting severity 'trivial' - '6'

2. Import components...
  inserting component 'General', owner 'bellaire'
  inserting component 'Scheduling, Preference Forms', owner 'bellaire'
  inserting component 'Sign-in, Timesheets', owner 'bellaire'

3. Import priorities...
  inserting priority 'highest' - '1'
  inserting priority 'high' - '2'
  inserting priority 'normal' - '3'
  inserting priority 'low' - '4'
  inserting priority 'lowest' - '5'

4. Import versions...
  inserting version '.Production'
  inserting version 'Development'
  inserting version 'Release'
  inserting version '2.0'
  inserting version 'unspecified'

5. Import milestones...

6. Retrieving bugs...

7. Import bugs and bug activity...
Traceback (most recent call last):
  File "bugzilla2trac.py", line 894, in <module>
    main()
  File "bugzilla2trac.py", line 891, in main
    convert(BZ_DB, BZ_HOST, BZ_USER, BZ_PASSWORD, TRAC_ENV, TRAC_CLEAN)
  File "bugzilla2trac.py", line 681, in convert
    field_name = trac.getFieldName(mysql_cur, activity['fieldid']).lower()
  File "bugzilla2trac.py", line 431, in getFieldName
    (fieldid))
  File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 164, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.5/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'fieldid' in 'where clause'")


#5592 Translation of Trac to Czech/Česky [cs_CZ] i18n 0.12 task normal 06/24/2007

This ticket should be used to coordinate the translation to Czech.


#6382 Translation of Trac to Farsi/پارسی [fa_IR] i18n 0.12 task normal 11/20/2007

This ticket should be used to coordinate the translation to Farsi.

See also TracTermsFa.


#6385 Translation of Trac to Welsh/Cymraeg [cy_GB] i18n 0.12 task normal 11/21/2007

This ticket should be used to coordinate the translation to Welsh/Cymraeg. See also TracTermsCy.


#6387 docs about translation i18n 0.12 task normal 11/21/2007

would be nice to have a wiki article which describes, how/where to add translation files (e.g. de_DE) for interface translation


#6430 Translation of Trac to Thai/ไทย [th_TH] i18n 0.12 task normal 12/03/2007

This ticket should be used to coordinate the translation to Thai/ไทย.


#6629 Translation of Trac to Vietnamese/Tiếng Việt [vi_VN] i18n 0.12 task normal 01/10/2008

This ticket should be used to coordinate the translation to Vietnamese/Tiếng Việt.

See source:sandbox/i18n/trac/locale/vi_VN/LC_MESSAGES/messages.po


#6753 bugzilla2trac.py: attachment.isobsolete has to be ignored general 0.11.3 defect normal 02/01/2008

This property is per-attachment in bugzilla, but the script imports it per-ticket. A change of the isobsolete field of two attachments at the same time in bugzilla will lead to a unique constraint violation on the trac side, causing the import to fail.

Adding the field to IGNORED_ACTIVITY_FIELDS solves the problem and allows the import to continue.


#6792 bugzilla2trac.py: attachments not imported correctly from bugzilla 2.32.2 general 0.11.3 defect normal 02/08/2008

Attachments look like this:

$ cat 1345/blank.gif
array('c', 'GIF89a\x01\x00\x01\x00\x80\x00\x00\xff\xff\xff\x00\x00\x00!\xf9\x04\x01\x00\x00\x00\x00,\x00\x00\x00\x00\x01\x00\x01\x00\x00\x02\x02D\x01\x00;')

#7020 New schema.py with Elixir defined model (sqlalchemy-ng branch) general not applicable enhancement normal 03/19/2008

Since I am more familiar with Elixir (and thus the new SQLAlchemy declarative language as well) I have produced an Elixir declared model for Trac with minimal relations. I assumed a 'User' class and table as well for some of the relations to demonstrate its use. I will be submitting a revised edition with relations defined in the top SQLAlchemy section hopefully this afternoon.


#7177 Translation of Trac to Norwegian/bokmål [nb_NO] i18n 0.12 task normal 04/30/2008

This ticket should be used to coordinate the translation to Norwegian/bokmål.

See source:sandbox/i18n/trac/locale/nb_NO/LC_MESSAGES/messages.po


#7178 Translation of Trac to Finnish/suomi [fi_FI] i18n 0.12 task normal 04/30/2008

This ticket should be used to coordinate the translation to Finnish/suomi.

See source:sandbox/i18n/trac/locale/fi_FI/LC_MESSAGES/messages.po


#7186 Translation of Trac to Argentian Spanish/español de Argentina [es_AR] i18n 0.12 task normal 05/01/2008

This ticket should be used to coordinate the translation to Argentian Spanish/español de Argentina.


#7333 [PATCH] bugzilla2trac.py: import Bugzilla version 2.18.4 ticket system 0.11.2 defect normal 06/13/2008

I just managed to import my bugs from Bugzilla version 2.18.4 into Trac Version 0.10.4.

However, some changes were necessary to the original Bugzilla DB contents as well as to the import script itself:

Trac needs unique product names

I used the option in the conversion script:

COMPONENTS_FROM_PRODUCTS = False

This caused the script to fail because my Bugzilla DB contained the same component name for various products.

After renaming the duplicate components, the script managed to import them.

DB schema problem

The import of attachments failed because of a wrong check for the Bugzilla version in the script (line 824):

The correct select statement from tables attachments and attach_data depends on the Bugzilla version. The script uses the table attach_data for versions greater or equal than 2180. However, this table was introduced in version 2211 (see http://www.ravenbrook.com/project/p4dti/tool/cgi/bugzilla-schema/).

After changing the condition to

        if BZ_VERSION >= 2210:

the import succeeded.

Multiple attachments.isobsolete at the same time

My bugzilla DB contained three changes of type "attachments.isobsolete" for the same bug at the same time.

This caused a duplicate primary key error in table ticket_change.

See my comments on Ticket #6753 for details.


#7353 Catalan language for 0.12 i18n 0.12 enhancement normal 06/18/2008

Would be nice to have catalan language in 0.12.


mgood (2 matches)

Ticket Summary Component Milestone Type Severity Created
Description
#1538 Email notify fail if user have blank email field in settings notification 0.11.3 defect major 05/12/2005

I use trac trunk from 22 april 2005 with settings

always_notify_reporter = true always_notify_owner = true

If reporter not specified email address in settings, then trac fails to send emails:

Trac[Ticket] ERROR: Failure sending notification on change to ticket #25: iteration over non-sequence Traceback (most recent call last): 
  File "/usr/lib/python2.4/site-packages/trac/Ticket.py", line 434, in save_changes     tn.notify(ticket, newticket=0, modtime=now)
  File "/usr/lib/python2.4/site-packages/trac/Notify.py", line 217, in notify     NotifyEmail.notify(self, ticket['id'], subject
) 
  File "/usr/lib/python2.4/site-packages/trac/Notify.py", line 117, in notify     Notify.notify(self, resid) 
  File "/usr/lib/python2.4/site-packages/trac/Notify.py", line 56, in notify     self.send(to) 
  File "/usr/lib/python2.4/site-packages/trac/Notify.py", line 356, in send     NotifyEmail.send(self, rcpt, hdrs)   File "/usr/lib/python2.4/site-packages/trac/Notify.py", line 150, in send     sel