We are upgrading from Beta version.

We did perform rb-site upgrade.

Kunjal


On Oct 28, 10:56 am, Christian Hammond <chip...@chipx86.com> wrote:
> Did you then run rb-site upgrade on it? It should have taken care of that.
>
> What version were you upgrading from? I thought 1.0 had this field.
>
> Christian
>
> --
> Christian Hammond - chip...@chipx86.com
> Review Board -http://www.reviewboard.org
> VMware, Inc. -http://www.vmware.com
>
>
>
> On Wed, Oct 28, 2009 at 9:26 AM, Kunjal <kunjal.par...@gmail.com> wrote:
>
> > Hello Chris,
>
> > The new import shows more information imported.  It looks like the
> > database is imported correctly.
> > Now, when I login to RB, I get below message...
> > Looks like some mismatch in the database fields. Is some database
> > fields obsolete? How to fix this?
>
> > TemplateSyntaxError at /dashboard/
> > Caught an exception while rendering: (1054, "Unknown column
> > 'reviews_reviewrequest.last_review_timestamp' in 'field list'")
>
> > Original Traceback (most recent call last):
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/template/debug.py", line 71, in
> > render_node
> >    result = node.render(context)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/template/__init__.py", line 936,
> > in render
> >    dict = func(*args)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/ReviewBoard-1.0.3.1-py2.5.egg/reviewboard/reviews/
> > templatetags/reviewtags.py", line 348, in dashboard_entry
> >    count = len(review_requests)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/models/query.py", line 81, in
> > __len__
> >    self._result_cache = list(self.iterator())
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/models/query.py", line 238, in
> > iterator
> >    for row in self.query.results_iter():
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/models/sql/query.py", line
> > 287, in results_iter
> >    for rows in self.execute_sql(MULTI):
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/models/sql/query.py", line
> > 2369, in execute_sql
> >    cursor.execute(sql, params)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Djblets-0.5.3-py2.5.egg/djblets/log/middleware.py", line 49,
> > in execute
> >    return self.cursor.execute(sql, params)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/backends/mysql/base.py", line
> > 84, in execute
> >    return self.cursor.execute(query, args)
> >  File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 166, in
> > execute
> >    self.errorhandler(self, exc, value)
> >  File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 35,
> > in defaulterrorhandler
> >    raise errorclass, errorvalue
> > OperationalError: (1054, "Unknown column
> > 'reviews_reviewrequest.last_review_timestamp' in 'field list'")
> > Request Method: GET
> > Request URL:http://mob-rb-test.sj.broadcom.com/dashboard/
> > Exception Type: TemplateSyntaxError
> > Exception Value: Caught an exception while rendering: (1054, "Unknown
> > column 'reviews_reviewrequest.last_review_timestamp' in 'field list'")
>
> > Original Traceback (most recent call last):
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/template/debug.py", line 71, in
> > render_node
> >    result = node.render(context)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/template/__init__.py", line 936,
> > in render
> >    dict = func(*args)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/ReviewBoard-1.0.3.1-py2.5.egg/reviewboard/reviews/
> > templatetags/reviewtags.py", line 348, in dashboard_entry
> >    count = len(review_requests)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/models/query.py", line 81, in
> > __len__
> >    self._result_cache = list(self.iterator())
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/models/query.py", line 238, in
> > iterator
> >    for row in self.query.results_iter():
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/models/sql/query.py", line
> > 287, in results_iter
> >    for rows in self.execute_sql(MULTI):
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/models/sql/query.py", line
> > 2369, in execute_sql
> >    cursor.execute(sql, params)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Djblets-0.5.3-py2.5.egg/djblets/log/middleware.py", line 49,
> > in execute
> >    return self.cursor.execute(sql, params)
> >  File "/projects/mob_tools/xampp/1.6.4-brcm-v2/lib/python2.5/site-
> > packages/Django-1.1-py2.5.egg/django/db/backends/mysql/base.py", line
> > 84, in execute
> >    return self.cursor.execute(query, args)
> >  File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 166, in
> > execute
> >    self.errorhandler(self, exc, value)
> >  File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 35,
> > in defaulterrorhandler
> >    raise errorclass, errorvalue
> > OperationalError: (1054, "Unknown column
> > 'reviews_reviewrequest.last_review_timestamp' in 'field list'")
>
> > Exception Location: /projects/mob_tools/xampp/1.6.4-brcm-v2/lib/
> > python2.5/site-packages/Django-1.1-py2.5.egg/django/template/debug.py
> > in render_node, line 81
> > Python Executable: /opt/lampp/bin/python
> > Python Version: 2.5.2
> > Python Path: ['/opt/lampp/htdocs/reviewboard/conf', '/opt/lampp/lib/
> > python2.5/site-packages/django', '/opt/lampp/lib/python2.5/site-
> > packages/reviewboard', '/opt/lampp/lib/python2.5/site-packages/
> > MySQL_python-1.2.2-py2.5-linux-i686.egg', '/opt/lampp/lib/python2.5/
> > site-packages/setuptools-0.6c9-py2.5.egg', '/opt/lampp/lib/python2.5/
> > site-packages/ReviewBoard-1.0.3.1-py2.5.egg', '/opt/lampp/lib/
> > python2.5/site-packages/pytz-2009l-py2.5.egg', '/opt/lampp/lib/
> > python2.5/site-packages/flup-1.0.3.dev_20090716-py2.5.egg', '/opt/
> > lampp/lib/python2.5/site-packages/Pygments-1.1.1-py2.5.egg', '/opt/
> > lampp/lib/python2.5/site-packages/Djblets-0.5.3-py2.5.egg', '/opt/
> > lampp/lib/python2.5/site-packages/django_evolution-0.0.0-py2.5.egg', '/
> > opt/lampp/lib/python2.5/site-packages/Django-1.1-py2.5.egg', '/opt/
> > lampp/lib/python2.5/site-packages/PIL-1.1.6-py2.5-linux-i686.egg', '/
> > opt/lampp/lib/python2.5/site-packages/RBTools-0.2beta2-py2.5.egg', '/
> > opt/lampp/lib/python2.5/site-packages/simplejson-2.0.9-py2.5-linux-
> > i686.egg', '/opt/lampp/lib/python2.5/site-packages/python_ldap-2.3.9-
> > py2.5-linux-i686.egg', '/opt/lampp/lib/python25.zip', '/opt/lampp/lib/
> > python2.5', '/opt/lampp/lib/python2.5/plat-linux2', '/opt/lampp/lib/
> > python2.5/lib-tk', '/opt/lampp/lib/python2.5/lib-dynload', '/opt/lampp/
> > lib/python2.5/site-packages']
> > Server time: Wed, 28 Oct 2009 09:22:41 -0700
>
> > On Oct 27, 4:38 pm, Kunjal <kunjal.par...@gmail.com> wrote:
> > > Thanks.
> > > I really like your quick support.
> > > All the thanks to your team. I will try it out after porting
> > > settings_local.py file.
>
> > > Regards,
> > > Kunjal
>
> > > On Oct 27, 4:18 pm, Christian Hammond <chip...@chipx86.com> wrote:
>
> > > > You shouldn't care about settings.py, as that's part of the Review
> > Board
> > > > source.
>
> > > > However, settings_local.py is important, as it contains the uniquely
> > > > generated secure key used for any encryption of passwords and such. You
> > will
> > > > want the original if you're using the same database.
>
> > > > That said, I don't imagine it's responsible for not seeing the review
> > > > requests. That wouldn't be a Review Board problem, but I also don't
> > know
> > > > what it is. It does sound like the database didn't move over correctly.
>
> > > > You could attempt to copy over /var/lib/mysql directly.
>
> > > > Christian
>
> > > > --
> > > > Christian Hammond - chip...@chipx86.com
> > > > Review Board -http://www.reviewboard.org
> > > > VMware, Inc. -http://www.vmware.com
>
> > > > On Tue, Oct 27, 2009 at 4:07 PM, Kunjal <kunjal.par...@gmail.com>
> > wrote:
>
> > > > > Very good point.
> > > > > We have settings_local.py  in our prod. server but I did not port it
> > > > > over.
> > > > > I already have settings.py in my new RB1.0.3 installation.
> > > > > What is the difference between settings_local.py and settings.py and
> > > > > do I need both?
>
> > > > > Should I port the settings_local.py and do the rb-site upgrade again?
>
> > > > > On Oct 27, 3:55 pm, Christian Hammond <chip...@chipx86.com> wrote:
> > > > > > Should work in theory.
>
> > > > > > Are you re-using the same settings_local.py and other contents of
> > the
> > > > > site
> > > > > > directory?
>
> > > > > > Christian
>
> > > > > > --
> > > > > > Christian Hammond - chip...@chipx86.com
> > > > > > Review Board -http://www.reviewboard.org
> > > > > > VMware, Inc. -http://www.vmware.com
>
> > > > > > On Tue, Oct 27, 2009 at 3:54 PM, Kunjal <kunjal.par...@gmail.com>
> > wrote:
>
> > > > > > > Is there a proper way to do it?
>
> > > > > > > I did like this.
>
> > > > > > > mysqldump --user=root -p --all-databases --socket=/var/lib/mysql/
> > > > > > > mysql.sock > backup-reviewboard.sql
>
> > > > > > > On Oct 27, 3:41 pm, Kunjal <kunjal.par...@gmail.com> wrote:
> > > > > > > > Hello Chris,
>
> > > > > > > > I have installed RB 1.0.3 on VM.
>
> > > > > > > > I wanted that RB 1.0.3 release should have existing RB database
> > so I
> > > > > > > > copied over the RB database and then perform rb-site upgrade.
> > > > > > > > I did not get any error messages while doing
>
> ...
>
> read more »- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to