Re: Text Reports query

On Nov 27, 2003, at 19:36, Russell Valentine wrote:

>> I have a few
>> questions about the advanced query search.
>
>
> Alright I found a problem. Sorry, I got confused because it was doing
> "resolved_d.name as resolution" in the select then doing "left join on
> resolve_d on resolve_d.id = resolution" however the resolution you 
> where
> using was bugs.resolution.
>
> I hope this will fix it and you see data.

This does fix the advanced query.  I definitely see data in there now.  
=)

Also, not sure what was up with the text reports before but I tried it 
again today and it worked.  I didn't have any bugs in the dbase but I 
know I had done a few reinstalls so I can't remember if the last time I 
tried maybe the reason it came up empty was because I had nothing in 
the db.  If that was the case, I'd feel fairly dumb.  =)

Anyways, other than a small notice error in the advanced query, it 
looks like it works, and likewise with the text reports.

Have you come across any other issues regarding postgres support?

I think one thing I may try is see if there is a way I can dump the 
contents of a mysql db and import it into postgres... that way I'd have 
a db with about 300+ bugs in it (nice for testing since I don't feel 
like doing 300 bugs here on my own).

I've applied the patch and will commit to CVS as soon as I fix this 
notice I'm seeing in there.

---
MandrakeSoft Security; http://www.mandrakesecure.net/
Online Security Resource Book; http://linsec.ca/
"lynx -source http://linsec.ca/vdanen.asc | gpg --import"
{FE6F2AFD : 88D8 0D23 8D4B 3407 5BD7  66F9 2043 D0E5 FE6F 2AFD}

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers