To add more info..we have never done any upgrade. We install Reviewboard Beta in 2008 and still using the old Beta version. Is there a way or we need to start with new database with our RB 1.0.3 release?
-Kunjal On Oct 28, 2:30 pm, Kunjal <kunjal.par...@gmail.com> wrote: > 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? > > ... > > 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 -~----------~----~----~----~------~----~------~--~---