On 13-May-09, at 3:13 AM, David E. Wheeler wrote:
> On May 12, 2009, at 10:16 PM, Phillip Smith wrote:
>
>> Anyway, I've deleted the previous import, and re-imported the bugs
>> with slightly better formatting, and the original bug ID, should we
>> need to dig it up in the Bugzilla SQL export.
>>
>> Paul: can you re-direct http://bugs.bricolagecms.org/ and
>> bugs.bricolage.cc to:
>> http://bricolage.lighthouseapp.com/projects/29601-bricolage/
>
> Are all the comments imported, as well? Because, looking at, say,
> this ticket:
>
> http://bricolage.lighthouseapp.com/projects/29601/tickets/82-uploading-media-with-spaces-in-the-name-fails-to-preview
>
> It looks to me like there might have been some discussion that
> wasn't copied over. If so, I'd like to be able to access the
> Bugzilla interface to see all of the context -- at least until all
> bugs are closed.
David: Do you want to grab a copy of the SQL? (I'll forward you Paul's
note with the link to it.)
Might be useful for you to have a look.
On the ticket referred to above, I ran:
SELECT
phillipadsmith_bricbugs.bugs.bug_id,
phillipadsmith_bricbugs.longdescs.bug_id,
phillipadsmith_bricbugs.bugs.short_desc,
phillipadsmith_bricbugs.longdescs.thetext
FROM phillipadsmith_bricbugs.bugs
INNER JOIN phillipadsmith_bricbugs.longdescs
ON phillipadsmith_bricbugs.bugs.bug_id =
phillipadsmith_bricbugs.longdescs.bug_id
WHERE phillipadsmith_bricbugs.bugs.bug_id = '1456'
And got these results:
1456,1456,uploading media with spaces in the name fails to
preview,"Create a media with a filename called 'Autumn Leaves.jpg'.
\nPreview it. The media saved to disk is something like\nmedia/
12/63/80/v.0/Autumn Leaves.jpg\nwith a space, but the row in the
resources table is\nmiles=> select id,uri from resource where uri like
E'%Autumn\\%%';\n\n id |
uri \n---------
+
---------------------------------------------------------------------------\n
8079249 | /entity/knowledge_communities/communities_practice/en/
Autumn%20Leaves.jpg\n 8079250 | /entity/knowledge_communities/
communities_practice/Autumn%20Leaves.jpg\n(2 rows)"
1456,1456,uploading media with spaces in the name fails to preview,Is
that not what it should be?
1456,1456,uploading media with spaces in the name fails to
preview,"Maybe so.. but preview doesn't work, so something is wrong. I
didn't look at it closely. Maybe it isn't distributing."
Which matches what's in the Lighthouse ticket.
That said, I agree that it might be useful to have read-only, or
password-protected, access to Bugzilla until these imported Lighthouse
bugs are closed.
Paul: are you able to help with that?
Phillip.
--
Phillip Smith // Simplifier of Technology // COMMUNITY BANDWIDTH
www.communitybandwidth.ca // www.phillipadsmith.com