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 rb-site upgrade.
> > > > > > > After upgrade, What I see is that user table is ported
> correctly. But
> > > > > > > all the reviews are not visible in dashboard.
> > > > > > > Where they go?
> >
> > > > > > > Kunjal
> > > > > > > To unsubscribe from this group, send email to
> > > > > > reviewboard+unsubscr...@googlegroups.com<reviewboard%2bunsubscr...@googlegroups.com>
> <reviewboard%2bunsubscr...@googlegr­­oups.com>
> > > > <reviewboard%2bunsubscr...@googlegr­oups.com>
> > > > > > For more options, visit this group at
> > > > > >http://groups.google.com/group/reviewboard?hl=en
> > > > > > -~----------~----~----~----~------~----~------~--~---- Hide
> quoted text
> > > > -
> >
> > > > > - Show quoted text -
> > > > > To unsubscribe from this group, send email to
> > > > reviewboard+unsubscr...@googlegroups.com<reviewboard%2bunsubscr...@googlegroups.com>
> <reviewboard%2bunsubscr...@googlegr­­oups.com>
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/reviewboard?hl=en
> > > > -~----------~----~----~----~------~----~------~--~---- Hide quoted
> text -
> >
> > > - Show quoted text -- Hide quoted text -
> >
> > - Show quoted text -
> > To unsubscribe from this group, send email to
> reviewboard+unsubscr...@googlegroups.com<reviewboard%2bunsubscr...@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
-~----------~----~----~----~------~----~------~--~---

Reply via email to