Hi Paul,
rb-site upgrade isn't meant to be used on a completely empty database. It
expects an existing install, so when you dropped and recreated the
database, it was unable to find the state it needs to perform an actual
upgrade.
If you need to just start fresh from a database, you can re-run install, or:
$ rb-site manage /path/to/site syncdb
That should generate a fresh new database (if there isn't already any
schema).
Christian
--
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com
On Fri, Apr 18, 2014 at 4:54 AM, Paul Fee <paul.f....@gmail.com> wrote:
> Hi all,
>
> I was testing migration from a 1.5 system to 2.0RC2.
>
> I took a mysql dump from the old system and copied it to the new system.
> Following an "rb-site install" on the new system, I dropped and recreated
> the reviewboard database, then tried "rb-site upgrade <path>".
>
> This procedure worked on CentOS6/EPEL/ReviewBoard 1.7.22, however with
> Fedora rawhide/COPR/Reviewboard 2.0RC2, I get this error:
>
> $ sudo rb-site upgrade /var/www/reviewboard
> Traceback (most recent call last):
> File "/bin/rb-site", line 9, in <module>
> load_entry_point('ReviewBoard==2.0rc2', 'console_scripts', 'rb-site')()
> File "/usr/lib/python2.7/site-packages/reviewboard/cmdline/rbsite.py",
> line 1727, in main
> command.run()
> File "/usr/lib/python2.7/site-packages/reviewboard/cmdline/rbsite.py",
> line 1530, in run
> diff_dedup_needed = site.get_diff_dedup_needed()
> File "/usr/lib/python2.7/site-packages/reviewboard/cmdline/rbsite.py",
> line 443, in get_diff_dedup_needed
> return FileDiff.objects.unmigrated().count() > 0
> File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line
> 291, in count
> return self.query.get_count(using=self.db)
> File "/usr/lib/python2.7/site-packages/django/db/models/sql/query.py",
> line 390, in get_count
> number = obj.get_aggregation(using=using)[None]
> File "/usr/lib/python2.7/site-packages/django/db/models/sql/query.py",
> line 356, in get_aggregation
> result = query.get_compiler(using).execute_sql(SINGLE)
> File
> "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line
> 782, in execute_sql
> cursor.execute(sql, params)
> File "/usr/lib/python2.7/site-packages/django/db/backends/util.py", line
> 53, in execute
> return self.cursor.execute(sql, params)
> File "/usr/lib/python2.7/site-packages/django/db/utils.py", line 99, in
> __exit__
> six.reraise(dj_exc_type, dj_exc_value, traceback)
> File "/usr/lib/python2.7/site-packages/django/db/backends/util.py", line
> 53, in execute
> return self.cursor.execute(sql, params)
> File
> "/usr/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line
> 124, in execute
> return self.cursor.execute(query, args)
> File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174,
> in execute
> self.errorhandler(self, exc, value)
> File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line
> 36, in defaulterrorhandler
> raise errorclass, errorvalue
> django.db.utils.OperationalError: (1054, "Unknown column
> 'diffviewer_filediff.diff_hash_id' in 'where clause'")
>
> Since this worked with reviewboard 1.7, I presume this is a bug in 2.0.
> Would you like more data to help diagnose the issue?
>
> Thanks,
> Paul
>
> --
> Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
> ---
> Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
> ---
> Happy user? Let us know at http://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.
>
--
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://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.
