Phew, that worked, thanks! Ian
On Monday, September 15, 2014 6:45:50 PM UTC-7, Ian wrote: > > I was running 2.0.6. I'll try to figure out the PostgreSQL equivalent to > drop the index and try again. > > Ian > > On Monday, September 15, 2014 6:44:48 PM UTC-7, Christian Hammond wrote: >> >> Hmmm, it should have tried to drop the old index in that upgrade. Very >> odd. >> >> What version were you running before this? >> >> (I have to take off for a couple hours, but will be back.. hopefully the >> other instructions will have helped.) >> >> Christian >> >> -- >> Christian Hammond - [email protected] >> Review Board - https://www.reviewboard.org >> Beanbag, Inc. - https://www.beanbaginc.com >> >> >> On September 15, 2014 at 6:43:27 PM, Ian ([email protected]) wrote: >> > Upgraded from 2.0.6 and using PostgreSQL. >> > >> > $ sudo rb-site manage /Library/Server/Web/Data/WebApps/ReviewBoard >> evolve >> > -- --sql >> > >> > Password: >> > >> > >> > -- Evolve application scmtools >> > >> > ALTER TABLE "scmtools_repository" ADD COLUMN "hooks_uuid" varchar(32) >> NULL; >> > >> > CREATE UNIQUE INDEX scmtools_repository_8c446842 ON scmtools_repository >> > ("archived_timestamp", "path", "local_site_id"); >> > >> > CREATE UNIQUE INDEX scmtools_repository_f22c3cf5 ON scmtools_repository >> > ("hooks_uuid", "local_site_id"); >> > >> > On Monday, September 15, 2014 6:40:21 PM UTC-7, Christian Hammond >> wrote: >> > > >> > > What version did you upgrade from? >> > > >> > > That looks like it may be a duplicate index. >> > > >> > > Can you run: >> > > >> > > rb-site manage /path/to/site evolve -- --sql >> > > >> > > And show me what that says? >> > > >> > > Also, are you using MySQL? >> > > >> > > Christian >> > > >> > > -- >> > > Christian Hammond - [email protected] >> > > Review Board - https://www.reviewboard.org >> > > Beanbag, Inc. - https://www.beanbaginc.com >> > > >> > > >> > > On September 15, 2014 at 6:37:05 PM, Ian ([email protected] ) >> > > wrote: >> > > > I did the easy_install -U thing to update Review Board, and then >> the >> > > > rb-side upgrade thing to upgrade my site. I get this output though, >> and >> > > > now I can't view anything in Review Board. Any workarounds much >> > > > appreciated! >> > > > >> > > > $ sudo rb-site upgrade /Library/Server/Web/Data/WebApps/ReviewBoard >> > > > >> > > > Password: >> > > > >> > > > Rebuilding directory structure >> > > > >> > > > Updating database. This may take a while. >> > > > >> > > > >> > > > The log output below, including warnings and errors, >> > > > >> > > > can be ignored unless upgrade fails. >> > > > >> > > > >> > > > ------------------ ------------------ >> > > > >> > > > Creating tables ... >> > > > >> > > > There are unapplied evolutions for scmtools. >> > > > >> > > > Project signature has changed - an evolution is required >> > > > >> > > > Installing custom SQL ... >> > > > >> > > > Installing indexes ... >> > > > >> > > > Installed 0 object(s) from 0 fixture(s) >> > > > >> > > > *CommandError: Error applying evolution: relation >> > > > "scmtools_repository_8c446842" already exists* >> > > > >> > > > -- >> > > > Get the Review Board Power Pack at >> http://www.reviewboard.org/powerpack/ >> > > > --- >> > > > Sign up for Review Board hosting at RBCommons: >> https://rbcommons.com/ >> > > > --- >> > > > Happy user? Let us know at http://www.reviewboard.org/users/ >> > > > --- >> > > > You received this message because you are subscribed to the Google >> > > Groups "reviewboard" >> > > > group. >> > > > To unsubscribe from this group and stop receiving emails from it, >> send >> > > an email to [email protected] . >> > > > For more options, visit https://groups.google.com/d/optout. >> > > > >> > > >> > > >> > >> > -- >> > Get the Review Board Power Pack at >> http://www.reviewboard.org/powerpack/ >> > --- >> > Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ >> > --- >> > Happy user? Let us know at http://www.reviewboard.org/users/ >> > --- >> > You received this message because you are subscribed to the Google >> Groups "reviewboard" >> > group. >> > To unsubscribe from this group and stop receiving emails from it, send >> an email to [email protected]. >> > For more options, visit https://groups.google.com/d/optout. >> > >> >> -- Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ --- Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ --- Happy user? Let us know at http://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
