Re: Need to find the changedescs_changedescription row for a given review

2012-02-23 Thread Steve
 Unfortunately, I'm trying to find the bad text inserted into the 'Testing 
Done' field so I can edit it (my other post). I can find the broken review 
in the admin interface,  but when I select it for further investigation, I 
get an error (my other post) and can't go any further :(

I was trying to find it using mysql workbench, but I couldn't follow the 
various pointers to other tables.  I eventually found it by brute force.

--
-- Steve

-- 
Want to help the Review Board project? Donate today at 
http://www.reviewboard.org/donate/
Happy user? Let us know at http://www.reviewboard.org/users/
-~--~~~~--~~--~--~---
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en

Re: Need to find the changedescs_changedescription row for a given review

2012-02-23 Thread Christian Hammond
Hi Steve,

I assume you're directly accessing the database. If instead you navigate to
http://yourserver/admin/, you should be able to browse the database in a
much nicer way, and get proper IDs from there.

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
VMware, Inc. - http://www.vmware.com


On Thu, Feb 23, 2012 at 9:44 AM, Steve  wrote:

> I would like to find the entry in the changedescs_changedescription
> table for a given reviews_reviewrequest id. Neither the id nor the
> diffset_history_id from the reviewrequest get me there directly. I'm
> thinking that the diffset_history_id gets me into a table that will
> then get me to the changedescription I'm after, but I haven't been
> able to connect the dots. Anyone know how to navigate between these
> two tables?
>
> Thanks!
>
> --Steve
>
> --
> Want to help the Review Board project? Donate today at
> http://www.reviewboard.org/donate/
> Happy user? Let us know at http://www.reviewboard.org/users/
> -~--~~~~--~~--~--~---
> To unsubscribe from this group, send email to
> reviewboard+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/reviewboard?hl=en

-- 
Want to help the Review Board project? Donate today at 
http://www.reviewboard.org/donate/
Happy user? Let us know at http://www.reviewboard.org/users/
-~--~~~~--~~--~--~---
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en

Need to find the changedescs_changedescription row for a given review

2012-02-23 Thread Steve
I would like to find the entry in the changedescs_changedescription
table for a given reviews_reviewrequest id. Neither the id nor the
diffset_history_id from the reviewrequest get me there directly. I'm
thinking that the diffset_history_id gets me into a table that will
then get me to the changedescription I'm after, but I haven't been
able to connect the dots. Anyone know how to navigate between these
two tables?

Thanks!

--Steve

-- 
Want to help the Review Board project? Donate today at 
http://www.reviewboard.org/donate/
Happy user? Let us know at http://www.reviewboard.org/users/
-~--~~~~--~~--~--~---
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en