I think I am going down a rabbit hole now. I was hoping this was going to
be faster and cleaner. I recreated the database as follows:
mysql> drop database reviewboard;
mysql> create database reviewboard;
# reviewboard user already created so skip!
#mysql> create user 'reviewboard'@'localhost' identified by 'reviewboard';
mysql> grant all on reviewboard.* to 'reviewboard'@'localhost';
Then ran rb-site and got the following error:
# rb-site upgrade /var/www/reviewboard/
Traceback (most recent call last):
File "/usr/bin/rb-site", line 9, in <module>
load_entry_point('ReviewBoard==2.0.6', 'console_scripts', 'rb-site')()
File
"/usr/lib/python2.6/site-packages/ReviewBoard-2.0.6-py2.6.egg/reviewboard/cmdline/rbsite.py",
line 1858, in main
command.run()
File
"/usr/lib/python2.6/site-packages/ReviewBoard-2.0.6-py2.6.egg/reviewboard/cmdline/rbsite.py",
line 1657, in run
static_media_upgrade_needed = site.get_static_media_upgrade_needed()
File
"/usr/lib/python2.6/site-packages/ReviewBoard-2.0.6-py2.6.egg/reviewboard/cmdline/rbsite.py",
line 436, in get_static_media_upgrade_needed
siteconfig = SiteConfiguration.objects.get_current()
File
"/usr/lib/python2.6/site-packages/Djblets-0.8.9-py2.6.egg/djblets/siteconfig/managers.py",
line 50, in get_current
site = Site.objects.get_current()
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/contrib/sites/models.py",
line 47, in get_current
current_site = self.get(pk=sid)
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/models/manager.py",
line 151, in get
return self.get_queryset().get(*args, **kwargs)
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/models/query.py",
line 304, in get
num = len(clone)
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/models/query.py",
line 77, in __len__
self._fetch_all()
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/models/query.py",
line 857, in _fetch_all
self._result_cache = list(self.iterator())
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/models/query.py",
line 220, in iterator
for row in compiler.results_iter():
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/models/sql/compiler.py",
line 713, in results_iter
for rows in self.execute_sql(MULTI):
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/models/sql/compiler.py",
line 786, in execute_sql
cursor.execute(sql, params)
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/backends/util.py",
line 53, in execute
return self.cursor.execute(sql, params)
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/utils.py",
line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/backends/util.py",
line 53, in execute
return self.cursor.execute(sql, params)
File
"/usr/lib/python2.6/site-packages/Django-1.6.7-py2.6.egg/django/db/backends/mysql/base.py",
line 124, in execute
return self.cursor.execute(query, args)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173,
in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line
36, in defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.ProgrammingError: (1146, "Table 'reviewboard.django_site'
doesn't exist")
[root@dsllinux4 reviewboard]#
The database appears to be not filled in correctly. Should I be running
'rb-site install' instead?
Jason
On Wednesday, September 10, 2014 1:37:24 PM UTC-4, Christian Hammond wrote:
>
> If you want to salvage the database, it's entirely possible to do so. I
> can help on here by having you e-mail information that I need, but
> depending, it could take time, and would need to be done over this list.
>
> If you were interested in a support contract or one-time support incident,
> it would speed up the process (we offer live chat, priority responses to
> urgent requests, and secure transmission/storage of sensitive data). I'd
> probably be able to get your old database ported over to 2.0.6 within a few
> hours.
>
> If you want to start fresh, you can drop the database, create a new one
> (granting permissions to your configured user), and then run 'rb-site
> upgrade' to have it repopulate the database.
>
> Christian
>
> --
> Christian Hammond - [email protected] <javascript:>
> Review Board - https://www.reviewboard.org
> Beanbag, Inc. - https://www.beanbaginc.com
>
>
> On September 10, 2014 at 8:26:57 AM, Jason Matheson ([email protected]
> <javascript:>) wrote:
> > Will now that it appears my database is corrupt, how do I start fresh.
> Is
> > it good enough just to delete the database in mysql or do I need to do
> more?
> >
> > Thanks
> > Jason
> >
> > On Tuesday, September 9, 2014 2:57:39 PM UTC-4, Jason Matheson wrote:
> > >
> > > Also be aware, that during the 1.7.25 to 2.0.5 upgrade there was very
> > > little in the database because there were no reviews created at that
> time.
> > >
> > > Jason
> > >
> > > On Tuesday, September 9, 2014 2:54:20 PM UTC-4, Jason Matheson wrote:
> > >>
> > >> Here are the logs from the 1.7.25 to 2.0.5 upgrade. All I saw was
> > >> warnings and the evolution had no errors or warnings
> > >>
> > >> Jason.
> > >>
> > >> On Tuesday, September 9, 2014 2:30:47 PM UTC-4, Christian Hammond
> wrote:
> > >>>
> > >>> Hi Jason,
> > >>>
> > >>> That’s pretty concerning, because there were no database schema
> changes
> > >>> at all made in 2.0.6. Are you sure the 2.0.5 upgrade actually went
> well?
> > >>> All these fields were introduced in 2.0.
> > >>>
> > >>> Christian
> > >>>
> > >>> --
> > >>> Christian Hammond - [email protected]
> > >>> Review Board - https://www.reviewboard.org
> > >>> Beanbag, Inc. - https://www.beanbaginc.com
> > >>>
> > >>>
> > >>> On September 9, 2014 at 11:28:42 AM, Jason Matheson (
> [email protected])
> > >>> wrote:
> > >>> > I am setting up a new ReviewBoard site and was just about to go
> live
> > >>> when I
> > >>> > noticed the new 2.0.6 update. Decided to upgrade as it was low
> risk. I
> > >>> > first installed the site using 1.7.25. Then upgraded it to 2.0.5
> with
> > >>> out a
> > >>> > problem. Tested the site with a few fake reviews. Everything
> appeared
> > >>> to be
> > >>> > working.
> > >>> >
> > >>> > The enclosed log shows the failure. manage.py did not give
> anything
> > >>> useful
> > >>> > as it also hits an error. I don't know python but this error leads
> me
> > >>> to
> > >>> > believe this is a problem with my python installation.
> > >>> >
> > >>> > I am tempted to scrape the MySQL database and start fresh but I
> would
> > >>> like
> > >>> > to understand what went wrong for future reference.
> > >>> >
> > >>> > Thanks for the help!
> > >>> >
> > >>> > --
> > >>> > 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 [email protected].
> > >>> > 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 [email protected] <javascript:>.
> > 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
