Hi Martin, The "#sql-" tables are generated internally by MySQL. Do you know if you're using InnoDB or MyISAM on the database?
>From a Google search, it seems that there may be several causes for this. It's basically a very misleading error message, and seems to vary on configuration. What version of MySQL are you running? And how about the test server? Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com On Mon, Sep 12, 2011 at 1:56 AM, M. Exner <ex...@dps-online.de> wrote: > We've been using reviewboard for a while now and had no problems with > upgrading several times. > We're running it on a windows server using apache 2.2 and mysql 5.5. > But now I try to upgrade our 1.5.6 installation to 1.6 I get several > database issues. > > 'rb-site upgrade reviewboard' gives the following: > > Rebuilding directory structure > Upgrading site settings_local.py > Updating database. This may take a while. > C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db > \__init__.py:19: DeprecationWarning: settings.DATABASE_* is > deprecated; use settings.DATABASES instead. > DeprecationWarning > Creating tables ... > Creating table accounts_localsiteprofile > Traceback (most recent call last): > File "C:\Python27\Scripts\rb-site-script.py", line 8, in <module> > load_entry_point('ReviewBoard==1.6', 'console_scripts', 'rb-site') > () > File "C:\Python27\lib\site-packages\reviewboard-1.6-py2.7.egg > \reviewboard\cmdline\rbsite.py", line 1747, in main > command.run() > File "C:\Python27\lib\site-packages\reviewboard-1.6-py2.7.egg > \reviewboard\cmdline\rbsite.py", line 1644, in run > site.sync_database() > File "C:\Python27\lib\site-packages\reviewboard-1.6-py2.7.egg > \reviewboard\cmdline\rbsite.py", line 346, in sync_database > self.run_manage_command("syncdb", params) > File "C:\Python27\lib\site-packages\reviewboard-1.6-py2.7.egg > \reviewboard\cmdline\rbsite.py", line 472, in run_manage_command > execute_manager(reviewboard.settings, [__file__, cmd] + params) > File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\core > \management\__init__.py", line 438, in execute_manager > utility.execute() > File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\core > \management\__init__.py", line 379, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\core > \management\base.py", line 191, in run_from_argv > self.execute(*args, **options.__dict__) > File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\core > \management\base.py", line 220, in execute > output = self.handle(*args, **options) > File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\core > \management\base.py", line 351, in handle > return self.handle_noargs(**options) > File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\core > \management\commands\syncdb.py", line 101, in handle_noargs > cursor.execute(statement) > File "C:\Python27\lib\site-packages\django-1.3-py2.7.egg\django\db > \backends\mysql\base.py", line 86, in execute > return self.cursor.execute(query, args) > File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 174, > in execute > self.errorhandler(self, exc, value) > File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line > 36, in defaulterrorhandler > raise errorclass, errorvalue > _mysql_exceptions.OperationalError: (1005, "Can't create table > 'reviewboard.#sql-680_1' (errno: 150)") > > I've been able to go back to 1.5.6 again and used the site and > database backups, so I'm fine for the moment. > But we really would like to use 1.6 for all the great new features. > Same problem occurs if I try to update to 1.6.1 release. > > On my test sytem (Ubuntu 11.04) there was no problem with the upgrade, > but the steps were 1.5.6 -> 1.6RC1 -> 1.6RC2 -> 1.6. > > Any advise would be appreciated! > > Regards, > Martin > > -- > 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 > -- 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