Jon, Did this really do what you wanted? I find myself in much the same situation, of having an ancient RB implementation in use, setting up a more modern one, and the prospect of either keeping the old one around for some indeterminite amount of time.
The question I have is: isn't reviews_review a table of completed reviews? The 'id' field in reviews_review seems to have the auto_increment attribute. Isn't the thing you want to adjust reviews_reviewrequest table, so that the review *request* numbers don't collide with the old ones, rather than the completed review records? . Once I executed ALTER TABLE reviews_reviewrequest 20000; I got review requests numbered up that high. (Of course, I changed reviews_reviewrequest *after* changing reviews_review. So now my IDs in the reviews_review table are starting at around 20000. Gulp!) Thanks, m@ On Aug 21, 6:48 pm, Jon Stevens <latch...@gmail.com> wrote: > 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 > > athttp://www.reviewboard.org/donate/ > > Happy user? Let us know athttp://www.reviewboard.org/users/ > > -~----------~----~----~----~------~----~------~--~--- > > To unsubscribe from this group, send email to > > reviewboard+unsubscr...@googlegroups.com > > For more options, visit this group > > athttp://groups.google.com/group/reviewboard?hl=en > > > -- > > Want to help the Review Board project? Donate today > > athttp://www.reviewboard.org/donate/ > > Happy user? Let us know athttp://www.reviewboard.org/users/ > > -~----------~----~----~----~------~----~------~--~--- > > To unsubscribe from this group, send email to > > reviewboard+unsubscr...@googlegroups.com > > For more options, visit this group > > athttp://groups.google.com/group/reviewboard?hl=en > > > -- > > Want to help the Review Board project? Donate today > > athttp://www.reviewboard.org/donate/ > > Happy user? Let us know athttp://www.reviewboard.org/users/ > > -~----------~----~----~----~------~----~------~--~--- > > To unsubscribe from this group, send email to > > reviewboard+unsubscr...@googlegroups.com > > For more options, visit this group > > athttp://groups.google.com/group/reviewboard?hl=en > > > -- > > Want to help the Review Board project? Donate today > > athttp://www.reviewboard.org/donate/ > > Happy user? Let us know athttp://www.reviewboard.org/users/ > > -~----------~----~----~----~------~----~------~--~--- > > To unsubscribe from this group, send email to > > reviewboard+unsubscr...@googlegroups.com > > For more options, visit this group > > athttp://groups.google.com/group/reviewboard?hl=en > > > -- > > Want to help the Review Board project? Donate today > > athttp://www.reviewboard.org/donate/ > > Happy user? Let us know athttp://www.reviewboard.org/users/ > > -~----------~----~----~----~------~----~------~--~--- > > To unsubscribe from this group, send email to > > reviewboard+unsubscr...@googlegroups.com > > For more options, visit this group > > athttp://groups.google.com/group/reviewboard?hl=en > > > -- > > Want to help the Review Board project? Donate today > > athttp://www.reviewboard.org/donate/ > > Happy user? Let us know athttp://www.reviewboard.org/users/ > > -~----------~----~----~----~------~----~------~--~--- > > To unsubscribe from this group, send email to > > reviewboard+unsubscr...@googlegroups.com > > For more options, visit this group > > athttp://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