Hi Alvin, This was reported recently, and I've been trying to figure out the best course of action. I expect to put out a release later this week with a fix. I recommend sticking to 1.5 for now, and upgrading once the new 1.7 is out.
Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com On Mon, Aug 5, 2013 at 6:52 PM, Alvin .Feng <alvin4f...@yahoo.com> wrote: > Hi there, > > I currently have a Review Board 1.5 setup, and I'm trying to upgrade to > 1.7. When I try to run the rb-site upgrade part to upgrade the database, I > get the following error: > > File > "lib64/reviewboard/MySQL_python-1.2.4-py2.6-linux-x86_64.egg/MySQLdb/connections.py", > line 36, in defaulterrorhandler > raise errorclass, errorvalue > django.db.utils.DatabaseError: (1071, 'Specified key was too long; max key > length is 1000 bytes') > > I think the sql statement it is trying to execute is: > > CREATE TABLE `hostingsvcs_hostingserviceaccount` ( > `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, > `service_name` varchar(128) NOT NULL, > `hosting_url` varchar(255), > `username` varchar(128) NOT NULL, > `data` longtext NOT NULL, > `visible` bool NOT NULL, > `local_site_id` integer, > UNIQUE (`service_name`, `hosting_url`, `username`, `local_site_id`) > ) > ; > > I clean install reviewboard 1.7 on one host, and I try to connect it to > the db host that was running with 1.5. Is there a way to just migrate the > mysql db across versions? Any help would be appreciated. Thanks. > > -- > 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 > --- > 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/groups/opt_out. > > > -- 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 --- 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/groups/opt_out.