I am currently migrating our ReviewBoard server from one server to another.

The old server runs ReviewBoard 2.0.24, thus I installed the very same 
version on the new server.
Then I rsync'ed the reviewboard directory, then mysqldump and reload the 
database, and `rb-site upgrade`.
All looks fine, the new server shows the same data as the old one.

Trouble come when I want to upgrade to a newer version of ReviewBoard.

Upgrading to 2.0.31 works perfectly. `rb-site upgrade` is happy after an 
apache and memcached restart.

The trouble comes when I want to upgrade from 2.0.31 to a 2.5 version (I 
tried 2.5, 2.5.1, and 2.5.1.1). (And also tried 3.0 BTW).

 # rb-site upgrade reviewboard
 Rebuilding directory structure
 Updating database. This may take a while.
 
 The log output below, including warnings and errors,
 can be ignored unless upgrade fails.
 
 ------------------ <begin log output> ------------------
 Creating tables ...
 Creating table accounts_trophy
 
 [!] There was an error synchronizing the database. Make sure the
     database is created and has the appropriate permissions, and then
     continue.
 [!] Details: (1005, 'Can\'t create table `reviewboard`.`#sql-791e_b0`
     (errno: 150 "Foreign key constraint is incorrectly formed")')

I've no idea how to deal with this.
Please help!

PS: I've already come across the limitation to 767 bytes for the index and 
solved it by setting the file_format to barracuda and large_prefix on for 
innodb. This is solved now.

-- 
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].
For more options, visit https://groups.google.com/d/optout.

Reply via email to