[prev in list] [next in list] [prev in thread] [next in thread]
List: trac
Subject: Re: [Trac] Questions about upgrading Trac 1.2.3 to 1.2.6
From: RjOllos <rjollos () gmail ! com>
Date: 2023-05-18 18:59:57
Message-ID: cae74243-6599-4a92-87a9-7a33dadd5b86n () googlegroups ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
On Thursday, May 18, 2023 at 9:27:47 AM UTC-7 pcottrill wrote:
I was recently advised to upgrade Trac 1.2.3 to 1.2.6 to address an issue
with TracQuery using custom fields.
Specifically, I am getting the following error when using TracQuery with
custom fields:
Trac detected an internal error:
OperationalError: ambiguous column name: id
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 would appreciate some guidance on upgrading to 1.2.6.
When the system was upgraded in 2019 from Trac 1.0.9 to 1.2.3, it was done
using *easy_install --upgrade Trac*.
A global directory was setup for the python egg cache.
An export statement was added to /etc/apache2/envvars as per Trac v. 1.2
deployment instructions:
- export PKG_RESOURCES_CACHE_ZIP_MANIFESTS=1
Since we used easy_install for the Trac 1.2.3 upgrade, does that mean we
have to use it again to upgrade to Trac 1.2.6?
Can we instead use pip?
Yes, you should be able to use pip.
I would do "pip uninstall Trac", repeating until it returns "not
installed", in case you have more than one older version of Trac. Then "pip
install Trac==1.2.6". Make sure to stop your webserver before doing those
operations.
If we can use pip, can we remove the global python egg cache directory as
well as the *export **PKG_RESOURCES_CACHE_ZIP_MANIFESTS=1* statement?
If you upgrade your setuptools to greater than 5.6 you can remove that.
"pip install -U setuptools".
https://trac.edgewall.org/wiki/TracInstall#DeployingTrac
It is my understanding that pip does not use eggs, but rather flat packages.
Pip will prefer installing the whl package from pypi.
I recommend reading the entire TracInstall document:
https://trac.edgewall.org/wiki/TracInstall
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/cae74243-6599-4a92-87a9-7a33dadd5b86n%40googlegroups.com.
[Attachment #5 (text/html)]
<br /><br /><div><div dir="auto">On Thursday, May 18, 2023 at 9:27:47 AM UTC-7 \
pcottrill wrote:<br /></div><blockquote style="margin: 0px 0px 0px 0.8ex; \
border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<font face="Tahoma" size="3"><span style="font-size: 12pt;">
<div><font color="#0F243E">I was recently advised to upgrade Trac 1.2.3 to 1.2.6 to \
address an issue with TracQuery using custom fields.</font></div> <div><font \
color="#0F243E">Specifically, I am getting the following error when using TracQuery \
with custom fields:</font></div> <div><font color="#C00000">Trac detected an internal \
error:</font></div> <div><font color="#C00000">OperationalError: ambiguous column \
name: id</font></div> <div><font color="#0F243E"> </font></div>
<div><font color="#0F243E">Below is the environment:</font></div>
<ul style="margin: 0px; padding-left: 36pt;">
<font color="#0F243E">
<li>Trac 1.2.3</li><li>Genshi 0.7 (with speedups)</li><li>mod_python \
3.3.1</li><li>Pygments 2.1</li><li>pysqlite 2.7.0</li><li>Python \
2.7.12</li><li>setuptools 20.7.0</li><li>SQLite 3.11.0</li><li>jQuery \
1.11.3</li><li>jQuery UI 1.11.4</li><li>jQuery Timepicker 1.5.5</li><li>Apache2 \
2.4.18</li></font> </ul>
<div><font face="Calibri" size="2" color="#0F243E"><span style="font-size: 11pt;"> \
</span></font></div> <div><font color="#0F243E">I would appreciate some guidance on \
upgrading to 1.2.6.</font></div> <div><font color="#0F243E"> </font></div>
<div><font color="#0F243E">When the system was upgraded in 2019 from Trac 1.0.9 to \
1.2.3, it was done using <b><i>easy_install --upgrade Trac</i></b>.</font></div> \
<div><font color="#0F243E">A global directory was setup for the python egg \
cache.</font></div> <div><font color="#0F243E">An export statement was added to \
/etc/apache2/envvars as per Trac v. 1.2 deployment instructions:</font></div> <ul \
style="margin: 0px; padding-left: 36pt;"> <font color="#0F243E">
<li>export PKG_RESOURCES_CACHE_ZIP_MANIFESTS=1</li></font>
</ul>
<div><font face="Calibri" size="2" color="#0F243E"><span style="font-size: 11pt;"> \
</span></font></div> <div><font color="#0F243E">Since we used easy_install for the \
Trac 1.2.3 upgrade, does that mean we have to use it again to upgrade to Trac \
1.2.6?</font></div> <div><font color="#0F243E">Can we instead use \
pip?</font></div></span></font></div></blockquote><div><br /></div><div>Yes, you \
should be able to use pip.</div><div><br /></div><div>I would do "pip uninstall \
Trac", repeating until it returns "not installed", in case you have more than one \
older version of Trac. Then "pip install Trac==1.2.6". Make sure to stop your \
webserver before doing those operations.</div><div> </div><blockquote style="margin: \
0px 0px 0px 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: \
1ex;"><div><font face="Tahoma" size="3"><span style="font-size: 12pt;"> <div><font \
color="#0F243E">If we can use pip, can we remove the global python egg cache \
directory as well as the <b><i>export \
</i></b><b><i>PKG_RESOURCES_CACHE_ZIP_MANIFESTS=1</i></b> \
statement?</font></div></span></font></div></blockquote><div><div><br /></div><div>If \
you upgrade your setuptools to greater than 5.6 you can remove that. "pip install -U \
setuptools".</div><div>https://trac.edgewall.org/wiki/TracInstall#DeployingTrac</div></div><div> \
</div><blockquote style="margin: 0px 0px 0px 0.8ex; border-left: 1px solid rgb(204, \
204, 204); padding-left: 1ex;"><div><font face="Tahoma" size="3"><span \
style="font-size: 12pt;"> <div><font color="#0F243E">It is my understanding that pip \
does not use eggs, but rather flat \
packages.</font></div></span></font></div></blockquote><div><br /></div><div>Pip will \
prefer installing the whl package from pypi.<br /></div><div><br /></div><div>I \
recommend reading the entire TracInstall \
document:</div><div>https://trac.edgewall.org/wiki/TracInstall</div><div><br \
/></div><div>Ryan </div></div>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "Trac \
Users" group.<br /> To unsubscribe from this group and stop receiving emails \
from it, send an email to <a \
href="mailto:trac-users+unsubscribe@googlegroups.com">trac-users+unsubscribe@googlegroups.com</a>.<br \
/> To view this discussion on the web visit <a \
href="https://groups.google.com/d/msgid/trac-users/cae74243-6599-4a92-87a9-7a33dadd5b8 \
6n%40googlegroups.com?utm_medium=email&utm_source=footer">https://groups.google.com/d/ \
msgid/trac-users/cae74243-6599-4a92-87a9-7a33dadd5b86n%40googlegroups.com</a>.<br />
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic