[prev in list] [next in list] [prev in thread] [next in thread] 

List:       trac
Subject:    RE: [Trac] Help with TracQuery
From:       Patty Cottrill <pcottrill () IMCI ! NET>
Date:       2023-05-17 23:24:17
Message-ID: MN2PR15MB3168FCFD6EBC7FAD1E35E2DCC27E9 () MN2PR15MB3168 ! namprd15 ! prod ! outlook ! com
[Download RAW message or body]

Thank you.
I was afraid you were going to tell me that.

I was hoping for a workaround in the current version.

Best,
Patty Cottrill

-----Original Message-----
From: trac-users@googlegroups.com <trac-users@googlegroups.com> On Behalf Of Jun Omae
Sent: Tuesday, May 16, 2023 8:41 PM
To: trac-users@googlegroups.com
Subject: Re: [Trac] Help with TracQuery

*** CAUTION: This email originated outside of IMCI Technologies. Do NOT respond, take \
any action, click on any links or open any attachments unless you recognize the \
sender and trust the content is safe. ***


On Wed, May 17, 2023 at 9:34 AM Patty Cottrill <pcottrill@imci.net> wrote:
> 
> I need help figuring out why my TracQuery is failing with the following error:
> Trac detected an internal error:
> OperationalError: ambiguous column name: id
> 
> This is only occurring when I use a custom field in the query.
> I have two custom fields:
> 
> referring_to
> 
> No problem using this field in TracQuery
> 
> Hostname
> 
> Problem using this field in TracQuery
> 
> 
> These are my steps:
> 
> Click on New Custom Query
> Select filters
> Select columns
> 
> E.g. Summary, Status, Component, Created, Hostname, Referring to
> 
> Click on Update
> The report displays with all the data selected, including the column for Hostname
> Click on Save query
> 
> This is when I get the error reported and I am not able to save query
> If I remove col=hostname, I can save successfully
> 
> 
> 
> This is the query that is created when I click on Save query:
> 
> query:?owner=pcottrill
> &
> col=id
> &
> col=summary
> &
> col=status
> &
> col=component
> &
> col=time
> &
> col=hostname
> &
> col=referring_to
> &
> order=priority
> 
> Below is the environment:
> 
> Trac  1.2.3
> Genshi 0.7 (with speedups)
> mod_python 3.3.1
> Pygments 2.1
> pysqlite 2.7.0
> Python 2.7.12
> setuptools 20.7.0
> SQLite 3.11.0
> jQuery 1.11.3
> jQuery UI 1.11.4
> jQuery Timepicker 1.5.5
> Apache2 2.4.18
> 
> 
> I am able to successfully create SQL queries using both custom fields with the LEFT \
> JOIN statement, but I should also be able to use TracQuery. Can you please help me \
> figure out why this particular custom field is causing this error with TracQuery. \
> Again, the query itself works, but I am not able to save it for later use, so I \
> have to create a new one every time. 
> 
> Best,
> Patty Cottrill

That has been fixed in Trac 1.2.4 [1].
Please upgrade to Trac 1.2.6 (at least 1.2.4).

[1] https://trac.edgewall.org/ticket/13068

--
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/CAEVLMag0DaOkWfG7%2BkUyLS5dsvRAO7r1Tt538D2cP%2B4%2BByEnow%40mail.gmail.com.
                
*** CONFIDENTIALITY NOTICE: This email and any attachments from IMCI Technologies are \
for the sole use of the intended recipient and may contain material that is \
proprietary, confidential, privileged or otherwise legally protected or restricted \
under applicable government laws. Any review, disclosure, distributing or other use \
without expressed permission of the sender is strictly prohibited. If you are not the \
intended recipient, please contact the sender and delete all copies without reading, \
printing, or saving. ***

-- 
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/MN2PR15MB3168FCFD6EBC7FAD1E35E2DCC27E9%40MN2PR15MB3168.namprd15.prod.outlook.com.



[prev in list] [next in list] [prev in thread] [next in thread]