Hi, Looks like you have a mix of InnoDB and MyISAM tables. You're going to need to update all tables in your database to use InnoDB (or configure MySQL to use MyISAM by default, though InnoDB is preferable).
The workaround you have that results in the "attachment_histories" bit is due to installing with 2.5.x, and then restoring your database without wiping the new tables, so it's trying to create tables that were already created during the 2.5 'rb-site install'. You don't want to go that route, so be sure to fix the MyISAM vs. InnoDB issue and then upgrade to a brand new, freshly-created database. Hope that helps! Christian -- Christian Hammond - christ...@beanbaginc.com Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com On Mon, Dec 7, 2015 at 6:40 PM, rfs <rfs...@gmail.com> wrote: > Some additional information after further experimentation: > > * I tried upgrading from the same 1.7.27 database to 2.0.18. This worked > perfectly fine. I ran compressdiffs afterwards as suggested, that worked > too. > * I then tried upgrading from 2.0.18 to 2.5.2, but got the same "Can't > create table 'reviewboard.#xxxx'" error. > > Next I scripted the upgrade from 1.7.27 to 2.5.2, and tried a few > variations, including location of the database, etc. > The process is: > 1) Create empty database > 2) Restore my 1.7.27 database > 3) Run rb-site upgrade > > That reliably triggers the "Can't create table" error. However, if I add > one step: > 1) Create empty database > 1.5) Run rb-site install > 2) Restore my 1.7.27 database > 3) Run rb-site upgrade > > Then the "Can't create table" error is avoided, and it manages to apply > many django evolutions. Eventually it fails with: > CommandError: Error applying evolution: (1050, "Table > 'reviews_reviewrequest_file_attachment_histories' already exists") > which is not entirely unexpected since I ran rb-site install which likely > created that table. > > I am using mariadb-5.5.44 on CentOS 7.1. > > -Ralph > > -- > 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 > "reviewboard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to reviewboard+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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 "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
