Hi Ron,
This looks to me like there's state recorded that says some parts of the
upgrade (perhaps to an earlier release, like a 2.0.x/2.5.x) was attempted,
but that it never completed successfully, and it's now trying to resume
from that bad state. Do you know anything about any attempted upgrades from
the past?
You might want to try completely dropping the new database and then
importing the mysql one without letting Review Board create or populate the
database at all, to make absolutely sure that you're not introducing some
bad state there. Once you've imported, please run:
rb-site manage /path/to/sitedir list-evolutions
And show me the results. I can get a sense of whether my hunch is correct.
We do offer database repair services as part of a support contract, or as a
one-off job (billed per-hour). If the state's all wrong (and particularly
if the database schema itself is in some half-upgraded state), then it
requires a bit of work to undo. We're good at this, though, and can
untangle this pretty fast. We can talk more about this in private, if
you're interested.
Christian
On Tue, Jun 11, 2019 at 2:07 PM Ron A <[email protected]> wrote:
> Hi, Posted this in the wrong group so am reposting to the Review Board
> Community, thanks!
>
> On linux I have reviewboard 1.7 and an upgrading to 3.0.14 on a second
> server. 3.0.14 was working fine on the second server but just with a base
> install and an empty database created by the inital reviewboard
> installation. I did a mysqldump of the data from 1.7 and then imported the
> data to reviewboard 3.0.14. Upon accessing the 3.0.14 url I am prompted to
> run the rb-site upgrade <dirname> tool.
>
> During the upgrade I get this error below. What steps should I take next
> to resolve the error? Thanks!
> Applying database evolutions for auth...
> Applying database evolutions for contenttypes...
> Applying database evolutions for accounts...
> Database evolutions for accounts failed!
> The SQL statement was: ALTER TABLE `accounts_profile` CHANGE COLUMN
> `show_submitted` `show_closed` bool NOT NULL;
> The database error was: (1054, "Unknown column 'show_submitted' in
> 'accounts_profile'")
> CommandError: Error applying evolution for accounts: (1054, "Unknown
> column 'show_submitted' in 'accounts_profile'")
>
> --
> Supercharge your Review Board with Power Pack:
> https://www.reviewboard.org/powerpack/
> Want us to host Review Board for you? Check out RBCommons:
> https://rbcommons.com/
> Happy user? Let us know! https://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "Review Board Community" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/reviewboard/b6d41dc9-915b-4c4d-895a-9090c62c1383%40googlegroups.com
> <https://groups.google.com/d/msgid/reviewboard/b6d41dc9-915b-4c4d-895a-9090c62c1383%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
Christian Hammond
President/CEO of Beanbag <https://www.beanbaginc.com/>
Makers of Review Board <https://www.reviewboard.org/>
--
Supercharge your Review Board with Power Pack:
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons:
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups
"Review Board Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/reviewboard/CAE7Vndn7sQpVNYaGz95PbzonhxS2Vy4yOS4QJ%2BKCCQBmSJ9NDg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
