| [00:13:06] |
<pacopablo> |
in the interpreter type: import svn |
| [00:37:45] |
* |
jodok has joined #trac |
| [00:50:10] |
* |
silentpyjamas is now known as sleepyjamas |
| [00:50:22] |
* |
_shawn has joined #trac |
| [01:06:32] |
* |
matt_good has joined #trac |
| [01:16:52] |
* |
matt_good has quit IRC |
| [01:19:37] |
* |
matt_good has joined #trac |
| [01:23:37] |
* |
matt_good has quit IRC |
| [01:29:36] |
* |
m_g has joined #trac |
| [01:45:58] |
* |
coderanger_ has quit IRC |
| [02:14:43] |
* |
jodok has quit IRC |
| [02:30:22] |
* |
pradeep has quit IRC |
| [03:01:33] |
* |
cmlenz has joined #trac |
| [03:16:41] |
* |
pradeep has joined #trac |
| [03:20:40] |
* |
cmlenz has quit IRC |
| [03:22:02] |
* |
cmlenz has joined #trac |
| [03:30:15] |
* |
cboos has joined #trac |
| [03:35:28] |
* |
tkp has joined #trac |
| [03:38:06] |
* |
pradeep has quit IRC |
| [03:43:38] |
* |
pradeep has joined #trac |
| [03:48:05] |
* |
cmlenz has quit IRC |
| [03:59:59] |
* |
cmlenz has joined #trac |
| [04:01:25] |
* |
eblot has joined #trac |
| [04:05:20] |
* |
eblot has quit IRC |
| [04:07:59] |
* |
SinnerG has quit IRC |
| [04:10:43] |
* |
Epcylon has quit IRC |
| [04:19:17] |
* |
mitsuhiko has quit IRC |
| [04:21:44] |
* |
tkp has joined #trac |
| [04:22:16] |
* |
mitsuhiko has joined #trac |
| [04:22:53] |
* |
tkp has quit IRC |
| [04:28:49] |
* |
Epcylon has joined #trac |
| [04:34:32] |
* |
MarkJaquith has joined #trac |
| [04:35:23] |
<MarkJaquith> |
How are attachments associated with tickets in the DB? |
| [04:38:59] |
<cboos> |
there's an attachment table |
| [04:39:30] |
<cboos> |
if you have sqlite, do: .table attachment |
| [04:39:38] |
<cboos> |
at the sqlite(3) prompt |
| [04:40:04] |
<cboos> |
other possibility is to have a look at trac/db_default.py |
| [04:40:22] |
<MarkJaquith> |
I have admin access to the install, but not to the server... Looked at db_default.py and I don't see a ticket_id column |
| [04:40:31] |
<MarkJaquith> |
Or an attachment2ticket table |
| [04:40:43] |
<cboos> |
you have type and id fields |
| [04:40:55] |
<cboos> |
the same attachment is also used for wiki attachments |
| [04:41:19] |
<cboos> |
(the same attachment table is ...) |
| [04:41:44] |
<MarkJaquith> |
oh, I assumed id meant for the ticket... are you saying that it could be wiki/ticket id (with that type determined by the type column?) |
| [04:41:56] |
<cboos> |
yes, |
| [04:42:04] |
<cboos> |
oh just look at one of our recent ticket |
| [04:42:16] |
<cboos> |
which incidentally contains a dump of that table |
| [04:42:31] |
<cboos> |
@ticket 4837 |
| [04:42:31] |
<evil_twin> |
cboos: http://trac.edgewall.org/ticket/4837 |
| [04:44:05] |
<MarkJaquith> |
sweet. many thanks. (Report I'm trying to write is looking for tickets without an attachment) |
| [04:44:53] |
<cboos> |
yes, should be easily doable |
| [04:56:06] |
* |
cmlenz has quit IRC |
| [05:06:48] |
* |
tkp has joined #trac |
| [05:09:19] |
* |
cmlenz has joined #trac |
| [05:12:52] |
* |
tkp has quit IRC |
| [05:13:16] |
* |
cboos has quit IRC |
| [05:37:51] |
* |
rjdave_ has quit IRC |
| [05:52:46] |
* |
eblot has joined #trac |
| [06:01:25] |
* |
cboos has joined #trac |
| [06:06:13] |
* |
eblot has quit IRC |
| [06:08:07] |
* |
thatch has joined #trac |
| [06:11:20] |
* |
rjdave has joined #trac |
| [06:20:20] |
* |
m_g has quit IRC |
| [06:24:55] |
* |
cmlenz has quit IRC |
| [06:31:36] |
* |
pradeep has quit IRC |
| [06:38:35] |
* |
thatch has quit IRC |
| [06:46:36] |
* |
ErikRose has joined #trac |
| [06:54:22] |
* |
MarkJaquith has left #trac |
| [07:06:27] |
* |
retracile has joined #trac |
| [07:06:48] |
* |
matt_good has joined #trac |
| [07:10:10] |
<retracile> |
pycon! |
| [07:14:35] |
* |
m_g has joined #trac |
| [07:18:02] |
<s0undt3ch> |
hello ppl... |
| [07:18:08] |
<s0undt3ch> |
I need some sql help :\ |
| [07:18:58] |
* |
tpollari has joined #trac |
| [07:19:03] |
<s0undt3ch> |
I'm trying to count the ocurrences of item.name='x' item.value='y' on an outer join, but I'm getting really weird results |
| [07:20:03] |
<s0undt3ch> |
http://paste.ufsoft.org/show/45/ <- current sql |
| [07:21:35] |
<s0undt3ch> |
any help here would be more than wonderfull |
| [07:22:55] |
* |
mitsuhiko has quit IRC |
| [07:26:11] |
* |
mitsuhiko has joined #trac |
| [07:35:08] |
* |
jurigo has joined #trac |
| [07:35:18] |
<jurigo> |
hi |
| [07:35:40] |
<jurigo> |
i'm new to trac, i need some help |
| [07:37:04] |
<jurigo> |
zipimport.ZipImportError when installing TracAccountManager egg |
| [07:38:33] |
* |
jodok has joined #trac |
| [07:38:50] |
* |
scoates has quit IRC |
| [07:43:56] |
<cboos> |
jurigo: you should probably ping matt_good about that |
| [07:44:44] |
<jurigo> |
tnx... |
| [07:44:59] |
<jurigo> |
and also need help about WebAdmin |
| [07:45:36] |
<jurigo> |
i get HTTP 500 in my server log, and Internal Error - No admin pages available in browser |
| [07:55:17] |
* |
cboos rambles in french (et bien sur #4840 /vient/ d'etre ferme il y a 1 minute, encore un coup pour rien...) |
| [07:56:04] |
<cboos> |
btw manu, you can write TH:AccountManagerPlugin (without the wiki: part), works as well |
| [07:56:48] |
<cboos> |
(ah, eblot is not there, my bad) |
| [08:08:09] |
* |
thatch has joined #trac |
| [08:08:23] |
* |
jwiles has joined #trac |
| [08:14:35] |
<jurigo> |
cboos >> was that for me? |
| [08:14:49] |
<cboos> |
no, for eblot |
| [08:15:10] |
<jurigo> |
can u help about WebAdmin setup? |
| [08:15:23] |
<cboos> |
0.10? |
| [08:15:26] |
<jurigo> |
yep |
| [08:16:00] |
<jurigo> |
i will be back in 15 mins |
| [08:16:07] |
<cboos> |
well, I can try. Do you have the matching WebAdmin version for your Trac version? (as described in WebAdmin) |
| [08:16:11] |
<cboos> |
@wiki WebAdmin |
| [08:16:11] |
<evil_twin> |
cboos: http://trac.edgewall.org/wiki/WebAdmin |
| [08:16:26] |
<jurigo> |
brb |
| [08:16:31] |
<cboos> |
ok |
| [08:25:22] |
<alect> |
morning |
| [08:27:08] |
* |
twb has quit IRC |
| [08:27:52] |
* |
jodok has quit IRC |
| [08:28:29] |
* |
nesl247 has joined #trac |
| [08:28:44] |
* |
tpollari has quit IRC |
| [08:28:54] |
<nesl247> |
Hello there folks. Could someone help me out with this Unsupported version control system "svn" error |
| [08:31:19] |
<alect> |
your svn bindings are not installed correctly |
| [08:31:44] |
<nesl247> |
What svn bindings do I need.. |
| [08:32:07] |
<nesl247> |
The swig stuff in subversion? |
| [08:34:02] |
<alect> |
read the trac installation guide |
| [08:34:10] |
<nesl247> |
I did. |
| [08:35:09] |
<nesl247> |
Hmm, I take it make install doesn't do make swig-py, make install-swig-py |
| [08:36:20] |
* |
thatch has quit IRC |
| [08:38:51] |
<nesl247> |
Well, I ran the swig make stuff, didn't help |
| [08:39:23] |
<alect> |
python -c 'import svn' |
| [08:39:27] |
<alect> |
try that |
| [08:39:43] |
<nesl247> |
No module |
| [08:39:51] |
<nesl247> |
Aah, I think I know the issue now |
| [08:40:32] |
<nesl247> |
I needed the swig stuff installed, then the python path to it's directory |
| [08:41:25] |
<nesl247> |
I blame this on the documentation, mainly the setting the python path part of mod_python setup |
| [08:41:52] |
<nesl247> |
alect: thanks though |
| [08:43:02] |
<cboos> |
nesl247: just in case: http://trac.edgewall.org/wiki/TracSubversion#BuildingSubversion |
| [08:43:14] |
<jurigo> |
i'm back |
| [08:43:19] |
* |
ErikRose has quit IRC |
| [08:43:21] |
<jurigo> |
so |
| [08:43:50] |
<nesl247> |
cboos: Heh thanks. It really would help if this stuff would be located in the actual install stuff, like ah, hey, here's a possible reason it's not working |
| [08:44:19] |
<cboos> |
nesl247: in the INSTALL file you mean? |
| [08:44:27] |
<nesl247> |
Either there or on the site |
| [08:44:35] |
<nesl247> |
I was reading the site at least |
| [08:44:52] |
<cboos> |
we have a TracTroubleshooting page ... maybe it's not obvious to find it |
| [08:45:24] |
* |
pradeep has joined #trac |
| [08:46:21] |
<jurigo> |
cboos>> i think u were right |
| [08:46:25] |
<jurigo> |
wrong version |
| [08:47:05] |
<cboos> |
yes, there's also a "known issues" list in that WebAdmin page that can serve as a starting point... |
| [08:49:41] |
<jurigo> |
or not |
| [08:49:48] |
<jurigo> |
right version |
| [08:49:54] |
<jurigo> |
properly installed |
| [08:50:29] |
<jurigo> |
how can i rebuild webadmin? |
| [08:50:46] |
<jurigo> |
notice: i'm new to python |
| [08:50:47] |
<cboos> |
you did a svn checkout ? |
| [08:50:52] |
<jurigo> |
yep |
| [08:51:02] |
<cboos> |
python setup.py bdist_egg |
| [08:51:20] |
<cboos> |
then throw the dist/....egg at the appropriate place |
| [08:51:39] |
<jurigo> |
st by, i will checkout into new folder, |
| [08:52:26] |
<jurigo> |
co - got rev 4831 |
| [08:52:40] |
<cboos> |
good catch ;) |
| [08:52:46] |
<cboos> |
that's the latest for sure ;) |
| [08:52:56] |
<jurigo> |
neo:/SHARED/trac-0.10.3/webadmin # python setup.py egg_info running egg_info |
| [08:52:56] |
<jurigo> |
creating TracWebAdmin.egg-info |
| [08:52:56] |
<jurigo> |
writing TracWebAdmin.egg-info/PKG-INFO |
| [08:52:56] |
<jurigo> |
writing top-level names to TracWebAdmin.egg-info/top_level.txt |
| [08:52:56] |
<jurigo> |
writing dependency_links to TracWebAdmin.egg-info/dependency_links.txt |
| [08:52:57] |
<jurigo> |
writing entry points to TracWebAdmin.egg-info/entry_points.txt |
| [08:52:59] |
<jurigo> |
writing manifest file 'TracWebAdmin.egg-info/SOURCES.txt' |
| [08:53:01] |
<jurigo> |
writing manifest file 'TracWebAdmin.egg-info/SOURCES.txt' |
| [08:53:04] |
<cboos> |
hm... |
| [08:53:05] |
<jurigo> |
wtf?? where is build? |
| [08:53:19] |
<cboos> |
bdist_egg |
| [08:53:22] |
<cboos> |
not egg_info |
| [08:53:32] |
<cboos> |
which only gets you the TracWebAdmin.egg-info |
| [08:53:41] |
<cboos> |
unless you want to run it from the checkout |
| [08:53:46] |
<jurigo> |
upssy |
| [08:53:58] |
<cboos> |
in which case, you now need to do: python setup.py develop |
| [08:54:15] |
<cboos> |
(that's also a valid option) |
| [08:54:16] |
<jurigo> |
done |
| [08:54:30] |
<jurigo> |
with bdist |
| [08:54:39] |
<cboos> |
either way |
| [08:54:53] |
<cboos> |
but now you need to put that egg somewhere |
| [08:55:16] |
<jurigo> |
in env/plugins? |
| [08:55:51] |
<jurigo> |
env - trac env folder |
| [08:56:05] |
<jurigo> |
my case /srv/www/trac/ |
| [08:56:56] |
<jurigo> |
or in all trac/plugins folders |
| [08:57:17] |
<jurigo> |
like /usr/local/share/trac/plugins |
| [08:59:25] |
<cboos> |
either way, |
| [08:59:32] |
* |
ErikRose has joined #trac |
| [08:59:34] |
<cboos> |
but if it's global, you'll have to enable it |
| [08:59:35] |
<nesl247> |
Ah, this isn't 100% trac specific but ah, I need to have trac at /trac instead of /. Now how can I get apache to redirect all from / to /trac in httpd.conf and not a .htaccess |
| [08:59:36] |
<cboos> |
http://trac.edgewall.org/wiki/WebAdmin#EnablingthePlugin |
| [09:00:10] |
<jurigo> |
i think i get it |
| [09:00:15] |
<jurigo> |
tnx for now |
| [09:03:14] |
<jurigo> |
i have [components] |
| [09:03:14] |
<jurigo> |
webadmin.* = enabled |
| [09:03:22] |
<jurigo> |
in trac.ini |
| [09:03:25] |
<cboos> |
good |
| [09:03:26] |
<jurigo> |
but still nothing |
| [09:03:31] |
<cboos> |
bad ;) |
| [09:03:40] |
<cboos> |
did you restart the server? |
| [09:03:43] |
<jurigo> |
im using tracd |
| [09:03:55] |
<jurigo> |
because apache even let me login |
| [09:03:58] |
<cboos> |
well, but did you restart it after the config change |
| [09:04:13] |
<jurigo> |
yes, always |
| [09:04:35] |
<jurigo> |
im still getting Internal error |
| [09:04:40] |
<jurigo> |
same as before |
| [09:05:00] |
<jurigo> |
on tracd |
| [09:05:03] |
<cboos> |
for /admin or in general? |
| [09:05:10] |
<jurigo> |
i can login as admin user |
| [09:05:28] |
<jurigo> |
for /admin |
| [09:05:44] |
<jurigo> |
admin user was created using trac-admin |
| [09:05:52] |
<jurigo> |
and granted all rights |
| [09:06:21] |
<nesl247> |
Oh does anyone know if there's a plugin that has the subcomponent feature of bugzilla? |
| [09:06:23] |
<jurigo> |
when i login as admin i'm not getting admin buttom |
| [09:07:00] |
<cboos> |
check: trac-admin <env> permission list admin |
| [09:07:09] |
<jurigo> |
st by |
| [09:07:19] |
<cboos> |
nesl247: not yet -> |
| [09:07:22] |
<cboos> |
@ticket 548 |
| [09:07:22] |
<evil_twin> |
cboos: http://trac.edgewall.org/ticket/548 |
| [09:07:31] |
<nesl247> |
Damn. That's the feature I really need most |
| [09:09:19] |
<jurigo> |
im getting some domp |
| [09:09:34] |
<jurigo> |
because webadmin egg is loaded twice? |
| [09:10:14] |
<jurigo> |
neo:/usr/local/share/trac/plugins # trac-admin /srv/www/trac permission list admin |
| [09:10:14] |
<jurigo> |
egg.activate() |
| [09:10:14] |
<jurigo> |
egg.activate() |
| [09:11:05] |
<cboos> |
well, hm, maybe never tried that -> disable the component in trac.ini again |
| [09:11:22] |
<cboos> |
then check the permission list again |
| [09:11:27] |
<jurigo> |
webadmin.* = disabled?? |
| [09:11:32] |
<cboos> |
yes |
| [09:12:38] |
<jurigo> |
still dumps same messages |
| [09:12:59] |
<cboos> |
hm |
| [09:13:11] |
<cboos> |
and no other output than this? |
| [09:13:30] |
<cboos> |
do you have the DEBUG information ? |
| [09:13:36] |
<cboos> |
@logging |
| [09:13:36] |
<evil_twin> |
cboos: "logging" is http://trac.edgewall.org/wiki/TracLogging <-- Enable debug logging to file, ensure your environments log/ directory is writeable by your web server user, check for errors. |
| [09:13:47] |
<alect> |
cboos: the dom stuff looks interesting, will you be adding any sample code? |
| [09:13:56] |
<jurigo> |
i normally get premission list after that |
| [09:14:03] |
<jurigo> |
*permission |
| [09:14:09] |
<cboos> |
nah, no code as I chat on IRC ;-) |
| [09:14:29] |
<cboos> |
seriously, this begins to take shape ... |
| [09:14:36] |
<alect> |
yeah |
| [09:14:36] |
<cboos> |
it will be BIG! |
| [09:14:45] |
<alect> |
the interfaces would be good to see |
| [09:14:55] |
<alect> |
and the base class, maybe an example of a subclass |
| [09:15:01] |
<jurigo> |
brb |
| [09:15:40] |
<cboos> |
I need to get something working first, to validate the ideas |
| [09:16:30] |
<alect> |
yep cool |
| [09:16:48] |
<alect> |
the design sounds feasible so far though, badly needed too :) |
| [09:16:49] |
* |
bitsweat has joined #trac |
| [09:16:57] |
<cboos> |
AH! |
| [09:17:07] |
<cboos> |
bitsweat: I was waiting for you !!! |
| [09:17:42] |
<bitsweat> |
hey :) how's it going |
| [09:17:54] |
<cboos> |
fine for me ... I was looking at |
| [09:17:58] |
<cboos> |
@ticket 4837 |
| [09:17:58] |
<evil_twin> |
cboos: http://trac.edgewall.org/ticket/4837 |
| [09:17:59] |
<bitsweat> |
I came to ask about query params in reports actually |
| [09:18:06] |
<cboos> |
this morning |
| [09:18:22] |
<cboos> |
yeah, wait for your question, I first have one for you ... |
| [09:18:27] |
<cboos> |
please ;-) |
| [09:18:51] |
<cboos> |
and then, following links from this ticket e.g. http://dev.rubyonrails.org/attachment/ticket/6175/6175_flash_update_and_filter_chain%2Btests.diff |
| [09:18:56] |
<bitsweat> |
oh I think that URL works now cause Michael updated the row in attachments |
| [09:19:29] |
<bitsweat> |
checking.. |
| [09:19:51] |
<cboos> |
... and I wondered... <uppercase-loud>how on earth can you be satisfied with such dramatic mess-up of the CSS?</uppercase-loud> |
| [09:20:19] |
<alect> |
yeah, truly |
| [09:20:41] |
<cboos> |
I always wondered if the look and feel of the RoR Trac was not messed-up on purpose, ya know, politics ... ;-) |
| [09:20:49] |
<bitsweat> |
we disabled the patch renderer a while ago cause the css was hosed |
| [09:20:52] |
<bitsweat> |
this was ages ago |
| [09:21:08] |
<cboos> |
well, no excuse the source code is not rendered as well |
| [09:21:15] |
<bitsweat> |
because we had to override the templates to get the consistent header then never updated it for new tracs :P |
| [09:21:21] |
<bitsweat> |
yeah it blows |
| [09:21:26] |
<alect> |
so...we can close that ticket? |
| [09:21:46] |
<cboos> |
have you taken a look at e.g. the pocoo site, to have a taste of how a recent Trac would look instead? |
| [09:21:47] |
<bitsweat> |
ticket | 6175 | 6175_flash_update_and_filter_chain+tests.diff | 3976 | 1158076185 | all together now | caio | 201.52.81.228 |
| [09:21:54] |
<bitsweat> |
ticket | 6175 | 6175_flash_update_and_filter_chain+tests.diff | 3976 | 1158076185 | all together now | caio | 201.52.81.228 |
| [09:21:57] |
<bitsweat> |
oops sorry |
| [09:22:45] |
<bitsweat> |
I just haven't taken the time to wipe the custom templates and recreate them with the latest release |
| [09:23:01] |
<bitsweat> |
haha not a good time to visit trac.pocoo.org |
| [09:23:24] |
<cboos> |
oops ;) right |
| [09:23:43] |
<bitsweat> |
alect: one sec, I'll try an attachment with a filename full of CGI escapeable nasties |
| [09:23:49] |
<alect> |
heh |
| [09:23:56] |
<alect> |
bitsweat: ok |
| [09:24:02] |
<mitsuhiko> |
bitsweat: why? |
| [09:24:04] |
* |
alect is now known as athomas |
| [09:24:09] |
* |
athomas is now known as alect |
| [09:24:13] |
<bitsweat> |
mitsuhiko: why a bad time? try the site |
| [09:24:13] |
<mitsuhiko> |
a. still offline |
| [09:24:36] |
<mitsuhiko> |
bitsweat: yeah. birkenfeld is currently working on getting svn running for python2.5 |
| [09:24:56] |
<bitsweat> |
our post-commit is broken too, haven't had time to fix it |
| [09:25:09] |
<birkenfeld> |
mitsuhiko: compiling at the moment... |
| [09:25:10] |
<bitsweat> |
since we have svn and trac on separate boxes, the post commit has to ssh to the trac box |
| [09:25:24] |
<bitsweat> |
and I messed up the bash quoting or something |
| [09:25:30] |
<mitsuhiko> |
bitsweat: are you the maintainer of the ror trac? |
| [09:25:53] |
<bitsweat> |
de facto maintainer, I wish I wasn't :P |
| [09:26:01] |
<mitsuhiko> |
haha |
| [09:26:06] |
<mitsuhiko> |
bitsweat: http://pocoo.org/~mitsuhiko/newpocootracfileview.png |
| [09:26:08] |
<bitsweat> |
textdrive is supposed to manage it for us but they never lift a finger |
| [09:26:10] |
<mitsuhiko> |
if you are looking for something like that |
| [09:26:25] |
<bitsweat> |
that's NICE |
| [09:26:42] |
<mitsuhiko> |
bitsweat: hey. and ruby highlighting works like a charm |
| [09:26:46] |
<mitsuhiko> |
even for erb templates ;) |
| [09:26:49] |
<bitsweat> |
rad |
| [09:26:59] |
<cboos> |
... was about to say that ;0 |
| [09:27:04] |
<bitsweat> |
ok maybe I'll fix trac today |
| [09:27:07] |
* |
jurigo has left #trac |
| [09:28:10] |
<bitsweat> |
example of the reports problem I was having: http://dev.rubyonrails.org/report/39?DATE=2007-01-01 |
| [09:28:19] |
<bitsweat> |
used to work in pre-0.10 |
| [09:28:34] |
<bitsweat> |
now $DATE gets substituted as an empty string |
| [09:29:36] |
<cboos> |
do you have the sql for that? |
| [09:29:53] |
<bitsweat> |
http://dev.rubyonrails.org/report/39?format=sql |
| [09:30:06] |
<bitsweat> |
oh you need to be registered to see that |
| [09:30:15] |
<bitsweat> |
excerpt: AND att.time >= extract('epoch' from date '$DATE') |
| [09:30:30] |
<cboos> |
i have an account... let's see if I remember the passwd ;) |
| [09:30:47] |
<cboos> |
ok |
| [09:30:51] |
<bitsweat> |
we get spam in our accounts for crissake, very annoying |
| [09:30:59] |
* |
ErikRose has quit IRC |
| [09:31:05] |
<bitsweat> |
cause the admin screen can't handle deletions in some cases |
| [09:31:41] |
<cboos> |
you mean you have spammers/spam bots registering? |
| [09:31:51] |
<bitsweat> |
ya |
| [09:31:57] |
* |
matt_good has quit IRC |
| [09:32:21] |
<bitsweat> |
and the spam filter plugin is broken for registered users :p |
| [09:32:56] |
<cboos> |
well, yes, there should be an option (maybe there is...) |
| [09:33:35] |
<cboos> |
yes, there is: [spam-filter] trust_authenticated = false |
| [09:33:39] |
* |
matt_good has joined #trac |
| [09:33:47] |
* |
ErikRose has joined #trac |
| [09:35:02] |
<bitsweat> |
right.. when I enable that, trac blows up for everyone |
| [09:35:25] |
<bitsweat> |
I can try again and get the error. I just disabled it immediately when it broke |
| [09:36:55] |
<bitsweat> |
confirmed: cgi escaping attachment filenames works |
| [09:37:07] |
<bitsweat> |
must've been a migration issue |
| [09:37:17] |
<bitsweat> |
I also noticed the attachment files path changed |
| [09:37:43] |
<bitsweat> |
we have a bunch of files in /attachments but all the new stuff is in /attachments/tickets |
| [09:37:53] |
<bitsweat> |
yet the old attachments still work.. |
| [09:40:44] |
<bitsweat> |
cboos: you like that mega-query? ;) |
| [09:40:53] |
<cboos> |
I'm dissecting it ;-) |
| [09:41:18] |
<bitsweat> |
we used the csv export to feed the contributions report on workingwithrails.com |
| [09:41:35] |
<bitsweat> |
Trac mashup! |
| [09:42:12] |
<bitsweat> |
also used a user -> email export to correlate Trac usernames with WWR logins, but Google found it so spammers started registering to show up there |
| [09:43:36] |
<bitsweat> |
here's a fun one: http://dev.rubyonrails.org/report/63 |
| [09:43:46] |
<bitsweat> |
distribution of tickets by size |
| [09:45:12] |
* |
coderanger__ has joined #trac |
| [09:45:19] |
* |
coderanger__ is now known as coderanger_ |
| [09:47:22] |
<bitsweat> |
here's a report using $DATE but with a simpler query: http://dev.rubyonrails.org/report/53?format=sql |
| [09:48:54] |
<bitsweat> |
in pre-0.10 I was wishing I could somehow default the query param |
| [09:49:09] |
<bitsweat> |
for example, substitute NULL so I could use COALESCE in the query |
| [09:49:10] |
* |
scyrma has joined #trac |
| [09:49:28] |
<cboos> |
I can an error: Report execution failed: invalid input syntax for type date: "" |
| [09:49:38] |
<cboos> |
s/can/get/ |
| [09:49:45] |
<bitsweat> |
yep it substitutes $DATE as empty string |
| [09:50:05] |
<scyrma> |
I get a "AttributeError: can't set attribute" when I try to login ... Trac 0.10 ... seems like this problem began only after upgrading from 0.9 |
| [09:50:07] |
<bitsweat> |
that's the problem.. it used to pull $DATE from the DATE query param |
| [09:50:13] |
* |
scyrma doesn't know what to do |
| [09:50:22] |
<cboos> |
bitsweat: no... in the log, I see: |
| [09:50:29] |
<bitsweat> |
did you update your db scyrma? |
| [09:50:35] |
<cboos> |
" ([u'cboos', u'2007-01-01']) |
| [09:50:46] |
<cboos> |
(I also added $USER) |
| [09:51:17] |
<cboos> |
ah, the || ... |
| [09:51:24] |
<cboos> |
what's that?!? |
| [09:51:27] |
<scyrma> |
bitsweat, yes, it was ... other stuff works fine (like browsing source...) |
| [09:51:37] |
<cboos> |
AND owner = ''||%s||'' |
| [09:51:39] |
<cboos> |
AND time > extract('epoch' from date ''||%s||'') |
| [09:51:53] |
<bitsweat> |
ohh the interpolation syntax has changed? |
| [09:52:03] |
<lisppaste5> |
scyrma pasted "AttributeError: can't set attribute" at http://paste.lisp.org/display/37371 |
| [09:52:17] |
<cboos> |
matt_good should probably now... |
| [09:52:22] |
<cboos> |
s/now/know/ |
| [09:52:44] |
<cboos> |
he, for scyrma as well (acct_mgr issue) |
| [09:54:58] |
<bitsweat> |
an example of broken attachments: http://dev.rubyonrails.org/attachment/ticket/4116/actionpack_pagination_helper_anchor_size_fixed_doc.diff |
| [09:55:17] |
<bitsweat> |
the attachment exists in /attachments/4116/foo.diff |
| [09:55:25] |
* |
pradeep has quit IRC |
| [09:55:49] |
<cboos> |
should be in /attachments/ticket/4116/... |
| [09:56:01] |
<scyrma> |
cboos, I thought it was a problem with accountmanager, and I upgraded it to 0.10, but the problem remains. :( |
| [09:56:05] |
<bitsweat> |
cboos: yup |
| [09:56:09] |
<bitsweat> |
the puzzle is, since when |
| [09:56:40] |
<cboos> |
well, is that still happening? or was that for some old(er) version of the code? |
| [09:57:00] |
<bitsweat> |
we have tons of entries in *both* /attachments root and /attachments/ticket |
| [09:57:17] |
<bitsweat> |
e.g. /attachments/96 and /attachments/ticket/20 -- both ancient tickets |
| [09:57:45] |
<cboos> |
ok, but those attachments could be recent... check the dates |
| [09:58:17] |
* |
ErikRose has quit IRC |
| [09:58:26] |
* |
nesl247 has quit IRC |
| [09:58:39] |
<bitsweat> |
ticket 20 is october 2004 |
| [09:58:53] |
<bitsweat> |
I imagine a textdrive guy could've rsynced em over |
| [09:58:57] |
* |
tpollari has joined #trac |
| [09:59:01] |
<cboos> |
I mean, the ls -l for those attachments |
| [09:59:19] |
<cboos> |
well I can look myself, wait... |
| [09:59:29] |
<cboos> |
ok, similar date |
| [10:00:06] |
<bitsweat> |
2007-02-25 17:53:01,287 Trac[main] WARNING: 500 Internal Error (Attachment #6175: 6175_flash_update_and_filter_chain+tests_r5270.diff does not exist.) |
| [10:00:09] |
<bitsweat> |
bah |
| [10:00:19] |
<cboos> |
If you have no recent attachments below /attachments/\d+, then the problem is "ancient" and could be safely ignored ;) |
| [10:00:34] |
<cboos> |
you could move all those ticket number folders below /attachments/ticket and voila |
| [10:00:39] |
<cboos> |
;-) |
| [10:00:47] |
<bitsweat> |
yeah I'm going to rsync them in and delete the others |
| [10:02:28] |
<bitsweat> |
if reports use ||%s|| now how can I disambiguate query params? |
| [10:02:45] |
<bitsweat> |
I can't use $USER and $DATE more than once in the same report |
| [10:03:24] |
<birkenfeld> |
the pocoo trac is now up again... |
| [10:03:25] |
<bitsweat> |
well.. ||%s|| doesn't work :) |
| [10:03:35] |
<cboos> |
hm, I think the arg list will match the sequence of %s in the query |
| [10:03:49] |
<bitsweat> |
that's a purty trac |
| [10:03:57] |
<cboos> |
but ||%s|| is probably not going to work in your date expression... |
| [10:04:17] |
* |
ErikRose has joined #trac |
| [10:04:20] |
<bitsweat> |
right, if it matches the sequence, I can't reuse elements of the sequence |
| [10:04:39] |
<bitsweat> |
birkenfeld: is that 0.10.3? |
| [10:04:43] |
<bitsweat> |
or 0.11? |
| [10:04:47] |
<birkenfeld> |
it's 0.11 svn |
| [10:05:01] |
<bitsweat> |
