Thanks, that solved the issue. Looks like mysql 5.5 defaults to InnoDB but 
our original tables were in the older format. I altered them to InnoDB and 
everything works now. Thanks,
--Erik

On Tuesday, June 25, 2013 4:26:12 PM UTC-4, Christian Hammond wrote:
>
> That error has to do with having a mix of InnoDB and MyISAM tables. You 
> need to make sure all tables are the same format. If MySQL is creating new 
> tables with one, then you should convert the rest.
>
> Christian
>
> -- 
> Christian Hammond - chi...@chipx86.com <javascript:>
> Review Board - http://www.reviewboard.org
> Beanbag, Inc. - http://www.beanbaginc.com
>
>
> On Tue, Jun 25, 2013 at 12:44 PM, Erik Lattimore 
> <erik...@gmail.com<javascript:>
> > wrote:
>
>> I'm getting the exact same error. I'm trying to test an upgrade before 
>> actually performing one on the live server and am getting the same Django 
>> stack trace.
>>
>> We are running RB 1.5.2 in production on Ubuntu 12.04. I've been using 
>> easy_install to install ReviewBoard and made sure to force the Django 
>> dependency(1.3.3) since the 1.5.2 package pulls in too new of a version. I 
>> used mysqldump to dump the db from the live server and installed a site by 
>> running rb-site install ... and then seeding the database with the 
>> production data through mysql reviewboard < dump.sql. I then use 
>> easy_install to upgrade to 1.7.1, which completes but the rb-site upgrade 
>> command fails. However, one thing that I did notice is that I have no issue 
>> upgrading an empty install by doing the same steps as before, but not 
>> seeding the backup database and only upgrading an empty site.
>>
>>
>>
>>
>> On Tuesday, January 8, 2013 4:34:42 PM UTC-5, virtualAdmin wrote:
>>>
>>> We've been making regular backups of our RB 1.5.5 database, and I 
>>> decided it was time to verify that we can restore the DB to a new install 
>>> in case our server fails.  The backups are made with mysqlhotcopy, so I 
>>> understand they can be restored by simply stopping the mysql service, 
>>> copying the backup files into the appropriate folder 
>>> (/var/lib/mysql/reviewboard), and starting mysql.
>>>
>>> I installed RB 1.7 on an Ubuntu 12.04 LTS VM.  I got the software all 
>>> installed and removed the fresh 1.7 database, replacing it with our 
>>> backed-up 1.5.5 DB, making sure to set proper privileges on the db files 
>>> and in mysql itself.
>>>
>>> I ran:
>>>
>>> rb-site upgrade -d /var/www/mysite
>>>
>>> Which failed, giving this output:
>>>
>>> ------------------ <begin log output> ------------------
>>> Creating tables ...
>>> Creating table attachments_fileattachment
>>> Creating table diffviewer_filediffdata
>>> Creating table hostingsvcs_**hostingserviceaccount
>>> Creating table reviews_fileattachmentcomment
>>> Creating table site_localsite_users
>>> Traceback (most recent call last):
>>>   File "/usr/local/bin/rb-site", line 9, in <module>
>>>     load_entry_point('ReviewBoard=**=1.7.1', 'console_scripts', 
>>> 'rb-site')()
>>>   File "/usr/local/lib/python2.7/**dist-packages/ReviewBoard-1.7.**
>>> 1-py2.7.egg/reviewboard/**cmdline/rbsite.py", line 1937, in main
>>>     command.run()
>>>   File "/usr/local/lib/python2.7/**dist-packages/ReviewBoard-1.7.**
>>> 1-py2.7.egg/reviewboard/**cmdline/rbsite.py", line 1778, in run
>>>     site.sync_database()
>>>   File "/usr/local/lib/python2.7/**dist-packages/ReviewBoard-1.7.**
>>> 1-py2.7.egg/reviewboard/**cmdline/rbsite.py", line 366, in sync_database
>>>     self.run_manage_command("**syncdb", params)
>>>   File "/usr/local/lib/python2.7/**dist-packages/ReviewBoard-1.7.**
>>> 1-py2.7.egg/reviewboard/**cmdline/rbsite.py", line 556, in 
>>> run_manage_command
>>>     execute_manager(reviewboard.**settings, [__file__, cmd] + params)
>>>   File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-**
>>> py2.7.egg/django/core/**management/__init__.py", line 459, in 
>>> execute_manager
>>>     utility.execute()
>>>   File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-**
>>> py2.7.egg/django/core/**management/__init__.py", line 382, in execute
>>>     self.fetch_command(subcommand)**.run_from_argv(self.argv)
>>>   File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-**
>>> py2.7.egg/django/core/**management/base.py", line 196, in run_from_argv
>>>     self.execute(*args, **options.__dict__)
>>>   File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-**
>>> py2.7.egg/django/core/**management/base.py", line 232, in execute
>>>     output = self.handle(*args, **options)
>>>   File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-**
>>> py2.7.egg/django/core/**management/base.py", line 371, in handle
>>>     return self.handle_noargs(**options)
>>>   File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-**
>>> py2.7.egg/django/core/**management/commands/syncdb.py"**, line 102, in 
>>> handle_noargs
>>>     cursor.execute(statement)
>>>   File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-**
>>> py2.7.egg/django/db/backends/**mysql/base.py", line 114, in execute
>>>     return self.cursor.execute(query, args)
>>>   File "/usr/lib/python2.7/dist-**packages/MySQLdb/cursors.py", line 
>>> 174, in execute
>>>     self.errorhandler(self, exc, value)
>>>   File "/usr/lib/python2.7/dist-**packages/MySQLdb/connections.**py", 
>>> line 36, in defaulterrorhandler
>>>     raise errorclass, errorvalue
>>> django.db.utils.DatabaseError: (1005, "Can't create table 
>>> 'reviewboard.#sql-5a2b_5b' (errno: 150)")
>>>
>>> Any ideas?
>>>
>>  -- 
>> 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...@googlegroups.com <javascript:>
>> 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...@googlegroups.com <javascript:>.
>> 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.


Reply via email to