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...@googlegroups.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>
> > > 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 -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
