Mailing List Archive

SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist
Hello,

we can't create new projects anymore using
TracSimpleMultiProject-0.7.2.dev0 on Trac-1.4:
https://trac-hacks.org/ticket/13955

Any idea how to solve this?

Here is the error message with callstack:

UndefinedTable: relation "smp_project_id_seq" does not exist
LINE 1: SELECT CURRVAL('"smp_project_id_seq"')

File
"/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/web/main.py",
line 639, in dispatch_request
dispatcher.dispatch(req)
File
"/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/web/main.py",
line 250, in dispatch
resp = chosen_handler.process_request(req)
File
"/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/admin/web_ui.py",
line 104, in process_request
resp = provider.render_admin_panel(req, cat_id, panel_id, path_info)
File
"/mnt/data/trac/virtualenv/lib/python2.7/site-packages/simplemultiproject/admin_project.py",
line 85, in render_admin_panel
self.smp_project.add(name, summary, description, None, 'YES' if
restricted else None)
File
"/mnt/data/trac/virtualenv/lib/python2.7/site-packages/simplemultiproject/smp_model.py",
line 213, in add
prj_id = db.get_last_id(cursor, 'smp_project')
File
"/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/db/postgres_backend.py",
line 372, in get_last_id
(self.quote(self._sequence_name(table, column)),))
File
"/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/db/util.py",
line 73, in execute
return self.cursor.execute(sql_escape_percent(sql), args)

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/cbe1b091-d8ad-4c31-a2da-ee45e102f0bfn%40googlegroups.com.
Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
On Sunday, February 21, 2021 at 11:41:37 PM UTC-8 Mo wrote:

>
> Hello,
>
> we can't create new projects anymore using
> TracSimpleMultiProject-0.7.2.dev0 on Trac-1.4:
> https://trac-hacks.org/ticket/13955
>
> Any idea how to solve this?
>
> Here is the error message with callstack:
>
> UndefinedTable: relation "smp_project_id_seq" does not exist
> LINE 1: SELECT CURRVAL('"smp_project_id_seq"')
>
> File
> "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/web/main.py",
> line 639, in dispatch_request
> dispatcher.dispatch(req)
> File
> "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/web/main.py",
> line 250, in dispatch
> resp = chosen_handler.process_request(req)
> File
> "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/admin/web_ui.py",
> line 104, in process_request
> resp = provider.render_admin_panel(req, cat_id, panel_id, path_info)
> File
> "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/simplemultiproject/admin_project.py",
> line 85, in render_admin_panel
> self.smp_project.add(name, summary, description, None, 'YES' if
> restricted else None)
> File
> "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/simplemultiproject/smp_model.py",
> line 213, in add
> prj_id = db.get_last_id(cursor, 'smp_project')
> File
> "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/db/postgres_backend.py",
> line 372, in get_last_id
> (self.quote(self._sequence_name(table, column)),))
> File
> "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/db/util.py",
> line 73, in execute
> return self.cursor.execute(sql_escape_percent(sql), args)


It might be helpful to see the descriptions of the tables:
https://www.postgresqltutorial.com/postgresql-describe-table/

The only significant changes to the smp_project table where made in:
https://trac-hacks.org/changeset/11785
If you installed an earlier version, maybe the table primary key is still
"id" rather than "id_project"?

We try to stick to cross-db compatible types in Trac: text, int, int64.
TracSimpleMultiProject uses varchar, which on quick look might be
compatible on all 3 supported databases, but I'm not certain.
https://trac-hacks.org/browser/simplemultiprojectplugin/trunk/simplemultiproject/environmentSetup.py

Ryan

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/d311e023-b8b3-4af3-8bb9-fdeac88a7f2fn%40googlegroups.com.
Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
RjOllos schrieb am Montag, 22. Februar 2021 um 21:19:27 UTC+1:

> The only significant changes to the smp_project table where made in:
> https://trac-hacks.org/changeset/11785
> If you installed an earlier version, maybe the table primary key is still
> "id" rather than "id_project"?
>

Not the case here, column is named id_project. We have been using SimpleMultiProjectPlugin
for many years after that change in 2012.


> We try to stick to cross-db compatible types in Trac: text, int, int64.
> TracSimpleMultiProject uses varchar, which on quick look might be
> compatible on all 3 supported databases, but I'm not certain.
>
> https://trac-hacks.org/browser/simplemultiprojectplugin/trunk/simplemultiproject/environmentSetup.py
>

If this has not changed recently then it can't be the cause either.

Best regards,
Mo

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/28b00ab0-bba4-4c5a-af45-926816091302n%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
On Wed, Feb 24, 2021 at 3:56 PM Mo <burcheri.massimo@gmail.com> wrote:
>
> RjOllos schrieb am Montag, 22. Februar 2021 um 21:19:27 UTC+1:
>>
>> The only significant changes to the smp_project table where made in:
>> https://trac-hacks.org/changeset/11785
>> If you installed an earlier version, maybe the table primary key is still "id" rather than "id_project"?
>
>
> Not the case here, column is named id_project. We have been using SimpleMultiProjectPlugin for many years after that change in 2012.
>
>>
>> We try to stick to cross-db compatible types in Trac: text, int, int64. TracSimpleMultiProject uses varchar, which on quick look might be compatible on all 3 supported databases, but I'm not certain.
>> https://trac-hacks.org/browser/simplemultiprojectplugin/trunk/simplemultiproject/environmentSetup.py
>
>
> If this has not changed recently then it can't be the cause either.

It seems that the author of the plugin has not tested creating a
project with PostgreSQL on applying r11785.


Index: simplemultiproject/model.py
===================================================================
--- simplemultiproject/model.py (revision 18015)
+++ simplemultiproject/model.py (working copy)
@@ -137,7 +137,7 @@
""", (self.id, self.name, _to_null(self.summary),
_to_null(self.description), _to_null(self.closed),
'YES' if self.restricted else None))
- self.id = db.get_last_id(cursor, 'smp_project')
+ self.id = db.get_last_id(cursor, 'smp_project', 'id_project')
# keep internal ticket custom field data up to date
self.refresh_ticket_custom_list()




--
Jun Omae <jun66j5@gmail.com> (?? ?)

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CAEVLMaiPQda347sSdwVCM%3DbZppuxjMnVUthzpHiPam7-m6ZYpQ%40mail.gmail.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
Jun Omae schrieb am Samstag, 27. Februar 2021 um 07:20:55 UTC+1:

>
> It seems that the author of the plugin has not tested creating a
> project with PostgreSQL on applying r11785.
>

Yes, we are using PostgreSQL, so what can we do now?
But I doubt it's about a change from 2012 as we were starting using it
later and have been updating continuously.

Best regards,
Mo

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/f5d65991-228c-433f-bcef-77d49071709an%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
On Mon, Mar 1, 2021 at 3:32 PM Mo <burcheri.massimo@gmail.com> wrote:
>
> Jun Omae schrieb am Samstag, 27. Februar 2021 um 07:20:55 UTC+1:
>>
>>
>> It seems that the author of the plugin has not tested creating a
>> project with PostgreSQL on applying r11785.
>
> Yes, we are using PostgreSQL, so what can we do now?

Please try the proposed patch in my mail.
If the issue is not fixed, please provide results of \ds <schema.>
using psql shell.


trac=> \dn
List of schemas
Name | Owner
-----------+----------
public | postgres
trac_0_12 | tracuser
trac_1_0 | tracuser
trac_1_2 | tracuser
trac_1_5 | tracuser
tractest | tracuser
(6 rows)

trac=> \ds trac_1_2.
List of relations
Schema | Name | Type | Owner
----------+----------------------------+----------+----------
trac_1_2 | node_change_id_seq | sequence | tracuser
trac_1_2 | notify_subscription_id_seq | sequence | tracuser
trac_1_2 | notify_watch_id_seq | sequence | tracuser
trac_1_2 | report_id_seq | sequence | tracuser
trac_1_2 | ticket_id_seq | sequence | tracuser
(5 rows)

--
Jun Omae <jun66j5@gmail.com> (?? ?)

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CAEVLMajzDMaovXVgy%2B9iLxydR38niWf1p6GP%3D1mo3Wo5%2Bh7Akw%40mail.gmail.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
Jun Omae schrieb am Samstag, 27. Februar 2021 um 07:20:55 UTC+1:

>
> Index: simplemultiproject/model.py
> ===================================================================
> --- simplemultiproject/model.py (revision 18015)
> +++ simplemultiproject/model.py (working copy)
> @@ -137,7 +137,7 @@
> """, (self.id, self.name, _to_null(self.summary),
> _to_null(self.description), _to_null(self.closed),
> 'YES' if self.restricted else None))
> - self.id = db.get_last_id(cursor, 'smp_project')
> + self.id = db.get_last_id(cursor, 'smp_project', 'id_project')
> # keep internal ticket custom field data up to date
> self.refresh_ticket_custom_list()
>
>
Something is wrong with the patch:
patch: **** malformed patch at line 6: """, (self.id, self.name,
_to_null(self.summary),

I'm working now on the trunk of
https://trac-hacks.org/svn/simplemultiprojectplugin, r18041.

However I adapted the line 140 manually to
*self.id = db.get_last_id(cursor, 'smp_project', 'id_project')*
which did not help.

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/62a12c9d-f8b2-45be-8b64-9dc925652be5n%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
Jun Omae schrieb am Montag, 1. März 2021 um 09:42:27 UTC+1:

>
> Please try the proposed patch in my mail.
> If the issue is not fixed, please provide results of \ds <schema.>
> using psql shell.
>

I'm connected with pgAdmin 4, how can I help you there?

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/c1536467-fb98-4ef5-9221-db1e1e1785a4n%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
Please provide list of sequence objects in your schema.

On Thu, Mar 4, 2021 at 19:16 Mo <burcheri.massimo@gmail.com> wrote:

> Jun Omae schrieb am Montag, 1. März 2021 um 09:42:27 UTC+1:
>
>>
>> Please try the proposed patch in my mail.
>> If the issue is not fixed, please provide results of \ds <schema.>
>> using psql shell.
>>
>
> I'm connected with pgAdmin 4, how can I help you there?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Trac Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to trac-users+unsubscribe@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/trac-users/c1536467-fb98-4ef5-9221-db1e1e1785a4n%40googlegroups.com
> <https://groups.google.com/d/msgid/trac-users/c1536467-fb98-4ef5-9221-db1e1e1785a4n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
Jun Omae <jun66j5@gmail.com> (?? ?)

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CAEVLMaibuEcBW_6ZhjWEUxiayE3pYuZikJU6Q_K-7s8EiMvoew%40mail.gmail.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
Jun Omae schrieb am Donnerstag, 4. März 2021 um 11:36:43 UTC+1:

> Please provide list of sequence objects in your schema.
>

trac-pp=> \ds
List of relations
Schema | Name | Type | Owner
--------+-------------------------------+----------+-------
public | forum_group_id_seq | sequence | trac
public | forum_id_seq | sequence | trac
public | message_id_seq | sequence | trac
public | node_change_id_seq | sequence | trac
public | notify_subscription_id_seq | sequence | trac
public | notify_watch_id_seq | sequence | trac
public | report_id_seq | sequence | trac
public | smp_component_project_id_seq | sequence | trac
public | smp_milestone_project_id_seq | sequence | trac
public | smp_project_id_project_seq | sequence | trac
public | smp_version_project_id_seq | sequence | trac
public | subscription_attribute_id_seq | sequence | trac
public | subscription_id_seq | sequence | trac
public | ticket_id_seq | sequence | trac
public | ticket_time_id_seq | sequence | trac
public | ticket_time_query_id_seq | sequence | trac
public | topic_id_seq | sequence | trac
public | xmail_id_seq | sequence | trac
(18 rows)

Does that help you?

BR,
Mo

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/663e7314-8095-408f-83a2-5c7368f7be95n%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
Does the Schema list help you to see the issue?

Is only the /admin/smproject/projects dialog broken?
I tried adding a new project by adding an item to

[ticket-custom]
project.options = FOO|BAR|NEW

but it does not appear in a new ticket dialog or in the admin settings.

Best regards,
Mo

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/e2dc2833-e612-49d8-bf44-5d38cdd4c5dbn%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
Hi, this is quite urgent in the meantime. How can I help fixing the plugin?

Best regards,
Mo

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/ce32d62d-9591-4d4c-8b80-1d8be6dadb02n%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
On Thursday, March 4, 2021 at 2:14:40 AM UTC-8 Mo wrote:

> Jun Omae schrieb am Samstag, 27. Februar 2021 um 07:20:55 UTC+1:
>
>>
>> Index: simplemultiproject/model.py
>> ===================================================================
>> --- simplemultiproject/model.py (revision 18015)
>> +++ simplemultiproject/model.py (working copy)
>> @@ -137,7 +137,7 @@
>> """, (self.id, self.name, _to_null(self.summary),
>> _to_null(self.description), _to_null(self.closed),
>> 'YES' if self.restricted else None))
>> - self.id = db.get_last_id(cursor, 'smp_project')
>> + self.id = db.get_last_id(cursor, 'smp_project', 'id_project')
>> # keep internal ticket custom field data up to date
>> self.refresh_ticket_custom_list()
>>
>>
> Something is wrong with the patch:
> patch: **** malformed patch at line 6: """, (self.id, self.name,
> _to_null(self.summary),
>
> I'm working now on the trunk of
> https://trac-hacks.org/svn/simplemultiprojectplugin, r18041.
>
> However I adapted the line 140 manually to
> *self.id <http://self.id> = db.get_last_id(cursor, 'smp_project',
> 'id_project')*
> which did not help.
>

I haven't had time to look, but note the sequence in your schema is smp_project_id_project_seq
and the patch seems like it should fix the issue:
https://trac.edgewall.org/browser/tags/trac-1.4.2/trac/db/postgres_backend.py?marks=442#L441

Line 207 in smp_model.py may need the same change:
https://trac-hacks.org/browser/simplemultiprojectplugin/trunk/simplemultiproject/smp_model.py?marks=207#L191

Do you get the same error with the patch?

Ryan

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/a61c6106-3745-4ef2-946e-d32af11831d9n%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
RjOllos schrieb am Mittwoch, 24. März 2021 um 06:21:30 UTC+1:

> I haven't had time to look, but note the sequence in your schema is smp_project_id_project_seq
> and the patch seems like it should fix the issue:
>
> https://trac.edgewall.org/browser/tags/trac-1.4.2/trac/db/postgres_backend.py?marks=442#L441
>
> Line 207 in smp_model.py may need the same change:
>
> https://trac-hacks.org/browser/simplemultiprojectplugin/trunk/simplemultiproject/smp_model.py?marks=207#L191
>
> Do you get the same error with the patch?
>

Thank you very much, that patch solved the issue.
Would you like to submit this patch to the plugin trunk?

I need to revise my info about Trac-1.4, I already have 1.4.2, and this
alone was not solving the issue, only the last patch you pointed to.

Best regards,
Mo


--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/3fc53df7-6d85-408a-80f4-66ffdca230b1n%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
On Wednesday, March 24, 2021 at 9:04:46 AM UTC-7 Mo wrote:

> RjOllos schrieb am Mittwoch, 24. März 2021 um 06:21:30 UTC+1:
>
>> I haven't had time to look, but note the sequence in your schema is smp_project_id_project_seq
>> and the patch seems like it should fix the issue:
>>
>> https://trac.edgewall.org/browser/tags/trac-1.4.2/trac/db/postgres_backend.py?marks=442#L441
>>
>> Line 207 in smp_model.py may need the same change:
>>
>> https://trac-hacks.org/browser/simplemultiprojectplugin/trunk/simplemultiproject/smp_model.py?marks=207#L191
>>
>> Do you get the same error with the patch?
>>
>
> Thank you very much, that patch solved the issue.
> Would you like to submit this patch to the plugin trunk?
>
> I need to revise my info about Trac-1.4, I already have 1.4.2, and this
> alone was not solving the issue, only the last patch you pointed to.
>
> Best regards,
> Mo
>

Would be great if you can create a patch file and attach it to the issue:
https://trac-hacks.org/ticket/13955

https://trac.edgewall.org/wiki/TracDev/SubmittingPatches

Ryan

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/962afe2c-c55e-4982-b0c4-7a9f9a4510d1n%40googlegroups.com.
Re: Re: SimpleMultiProjectPlugin: Create new project, undefinedTable: relation "smp_project_id_seq" does not exist [ In reply to ]
On Wednesday, March 24, 2021 at 10:39:26 AM UTC-7 RjOllos wrote:

> On Wednesday, March 24, 2021 at 9:04:46 AM UTC-7 Mo wrote:
>
>> RjOllos schrieb am Mittwoch, 24. März 2021 um 06:21:30 UTC+1:
>>
>>> I haven't had time to look, but note the sequence in your schema is smp_project_id_project_seq
>>> and the patch seems like it should fix the issue:
>>>
>>> https://trac.edgewall.org/browser/tags/trac-1.4.2/trac/db/postgres_backend.py?marks=442#L441
>>>
>>> Line 207 in smp_model.py may need the same change:
>>>
>>> https://trac-hacks.org/browser/simplemultiprojectplugin/trunk/simplemultiproject/smp_model.py?marks=207#L191
>>>
>>> Do you get the same error with the patch?
>>>
>>
>> Thank you very much, that patch solved the issue.
>> Would you like to submit this patch to the plugin trunk?
>>
>> I need to revise my info about Trac-1.4, I already have 1.4.2, and this
>> alone was not solving the issue, only the last patch you pointed to.
>>
>> Best regards,
>> Mo
>>
>
> Would be great if you can create a patch file and attach it to the issue:
> https://trac-hacks.org/ticket/13955
>
> https://trac.edgewall.org/wiki/TracDev/SubmittingPatches
>
> Ryan
>


Untested patch:
https://trac-hacks.org/attachment/ticket/13955/t13935.diff

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/b6f9675b-b1a6-4784-96e2-399c0e260bf0n%40googlegroups.com.