Lol. That confirms my suspicions. No worries, we are fine just mothballing the 
old release and I'll set the review number to be n+1. Thanks for the help!

Jon

On Aug 21, 2010, at 11:40 AM, Christian Hammond <chip...@chipx86.com> wrote:

> In that case, an upgrade could potentially be tricky... Yeah, might want to 
> just start off with a new install.
> 
> Christian
> 
> -- 
> Christian Hammond - chip...@chipx86.com
> Review Board - http://www.reviewboard.org
> VMware, Inc. - http://www.vmware.com
> 
> 
> On Sat, Aug 21, 2010 at 7:22 AM, Jon Stevens <latch...@gmail.com> wrote:
> I'm inheriting this installation so I'm not entirely sure of it's history. I 
> believe that it was essentially a checkout of the source code at some point 
> at least a couple years ago and has never been upgraded.
> 
> jon
> 
> 
> On Sat, Aug 21, 2010 at 12:11 AM, Christian Hammond <chip...@chipx86.com> 
> wrote:
> Hi Jon,
> 
> It really depends on how old the version is. Unfortunately, at that time, we 
> didn't really have version numbers that meant anything. Can you tell me how 
> you performed database upgrades on the old install? Was it using the old 
> load-db.py and dump-db.py scripts, or was it using ./manage.py evolve?
> 
> Also, were you using rb-site?
> 
> 
> Christian
> 
> -- 
> Christian Hammond - chip...@chipx86.com
> Review Board - http://www.reviewboard.org
> VMware, Inc. - http://www.vmware.com
> 
> 
> On Fri, Aug 20, 2010 at 9:05 PM, Jon Stevens <latch...@gmail.com> wrote:
> Hi Christian,
> 
> Thanks for the fast response. I haven't tried upgrading things. I guess I 
> could try that, but I got the impression from somewhere that it would be 
> difficult to do so from the early version that we are currently running. If 
> you think it is worth trying, then that is probably the ideal route.
> 
> cheers,
> 
> jon
> 
> 
> On Fri, Aug 20, 2010 at 8:16 PM, Christian Hammond <chip...@chipx86.com> 
> wrote:
> Hi Jon,
> 
> Your plan to use ALTER TABLE should work. review_request_id just holds the 
> current ID. That's what should be auto_increment. I think so long as you do 
> that, you'll see the review request ID number you expect.
> 
> By the way, what problems did you hit with upgrading?
> 
> Christian
> 
> -- 
> Christian Hammond - chip...@chipx86.com
> Review Board - http://www.reviewboard.org
> VMware, Inc. - http://www.vmware.com
> 
> 
> On Fri, Aug 20, 2010 at 5:47 PM, jon <latch...@gmail.com> wrote:
> Apologies if this has been covered before, google didn't seem to have
> an obvious answer. Is it possible to set a starting review # for a
> clean install?
> 
> The issue is that we have a pre-1.0 installation that has been in use
> for awhile now. Instead of trying to figure out how to upgrade the
> database, I've just created a fresh new installation (of 1.5rc1) on a
> fresh new server and we are just going to consider the previous
> version effectively read-only.
> 
> But, on the new server, I'd like to start the review number +1 higher
> than the old server so that we don't have conflicting numbers in svn
> commit messages.
> 
> I see that reviews_review.id is auto_increment. I know that I can do:
> "ALTER TABLE reviews_review AUTO_INCREMENT = 100;", but I also see a
> 'review_request_id' column. What is that used for? Do you see any
> other issues with this approach?
> 
> thanks,
> 
> jon
> 
> --
> 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
> 
> -- 
> 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
> 
> -- 
> 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

-- 
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

Reply via email to