Re: Existing Reviews not visible after rb-site upgrade
Chirs, The old install was done by someone else. I see the folders created on 4th Aug, 2008. I am not sure whether rb-site was used or not. Do I need to perform commands like /.manage.py evolve after rb-site upgrade? At this point I am really stuck...!! On Oct 28, 2:38 pm, Kunjal kunjal.par...@gmail.com wrote: 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
Re: Existing Reviews not visible after rb-site upgrade
I found the Version of the Reviewboard we have. /* Define to the address where bug reports for this package should be sent. */ #define PACKAGE_BUGREPORT http://code.google.com/p/reviewboard/issues/ entry /* Define to the full name of this package. */ #define PACKAGE_NAME Review Board /* Define to the full name and version of this package. */ #define PACKAGE_STRING Review Board 0.4 /* Define to the one symbol short name of this package. */ #define PACKAGE_TARNAME reviewboard /* Define to the version of this package. */ #define PACKAGE_VERSION 0.4 /* Version number of package */ #define VERSION 0.4 On Oct 28, 2:38 pm, Kunjal kunjal.par...@gmail.com wrote: 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-
Re: Existing Reviews not visible after rb-site upgrade
Chirs, Sorry for all this email but I found this. In the older installation, there are few dir. which are not present in 1.0.3 installation. Did I miss installing something? The dir. I do not see in RB 1.0.3 installation are: djblets iphone m3 The files I do not see in RB 1.0.3 instllation are: Makefile Makefile.am Makefile.in py-compile Thanks Kunjal On Oct 28, 7:17 pm, Christian Hammond chip...@chipx86.com wrote: Do you know exactly how old the old install was? Preferably which SVN revision? Did you use rb-site for the old version as well? You shouldn't need to start with a new database, but it doesn't sound like your site install upgraded correctly. We'll need to figure out what exactly is causing this. Chris Clark posted some good notes on upgrading his old install today. That might be useful as well. Christian -- Christian Hammond - chip...@chipx86.com Review Board -http://www.reviewboard.org VMware, Inc. -http://www.vmware.com On Wed, Oct 28, 2009 at 2:38 PM, Kunjal kunjal.par...@gmail.com wrote: 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
Re: Existing Reviews not visible after rb-site upgrade
Wow, this is ancient. Definitely pre-rb-site. Okay, so you'll need to do the following: 1) Copy over the database. 2) Go through the rb-site install process for the new site, creating a brand new site directory. Specify the existing database information during the process. 3) Run rb-site upgrade on that site directory. 4) Edit the conf/settings_local.py in your site directory to use your old secret key from your old settings_local.py file. 4) Copy over the new Apache config file. Don't use your old one. 5) Restart Apache and cross your fingers. I've never attempted an upgrade from such an old version, so I can't say for sure that it will work correctly. Can only hope. Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com On Thu, Oct 29, 2009 at 1:07 PM, Kunjal kunjal.par...@gmail.com wrote: I found the Version of the Reviewboard we have. /* Define to the address where bug reports for this package should be sent. */ #define PACKAGE_BUGREPORT http://code.google.com/p/reviewboard/issues/ entry /* Define to the full name of this package. */ #define PACKAGE_NAME Review Board /* Define to the full name and version of this package. */ #define PACKAGE_STRING Review Board 0.4 /* Define to the one symbol short name of this package. */ #define PACKAGE_TARNAME reviewboard /* Define to the version of this package. */ #define PACKAGE_VERSION 0.4 /* Version number of package */ #define VERSION 0.4 On Oct 28, 2:38 pm, Kunjal kunjal.par...@gmail.com wrote: 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
Re: Existing Reviews not visible after rb-site upgrade
Yeah, those files were removed long ago. Much has changed since that version. That was essentially a pre-alpha. Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com On Thu, Oct 29, 2009 at 1:21 PM, Kunjal kunjal.par...@gmail.com wrote: Chirs, Sorry for all this email but I found this. In the older installation, there are few dir. which are not present in 1.0.3 installation. Did I miss installing something? The dir. I do not see in RB 1.0.3 installation are: djblets iphone m3 The files I do not see in RB 1.0.3 instllation are: Makefile Makefile.am Makefile.in py-compile Thanks Kunjal On Oct 28, 7:17 pm, Christian Hammond chip...@chipx86.com wrote: Do you know exactly how old the old install was? Preferably which SVN revision? Did you use rb-site for the old version as well? You shouldn't need to start with a new database, but it doesn't sound like your site install upgraded correctly. We'll need to figure out what exactly is causing this. Chris Clark posted some good notes on upgrading his old install today. That might be useful as well. Christian -- Christian Hammond - chip...@chipx86.com Review Board -http://www.reviewboard.org VMware, Inc. -http://www.vmware.com On Wed, Oct 28, 2009 at 2:38 PM, Kunjal kunjal.par...@gmail.com wrote: 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,
Re: Existing Reviews not visible after rb-site upgrade
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
Re: Existing Reviews not visible after rb-site upgrade
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
Re: Existing Reviews not visible after rb-site upgrade
It is mysql database and we tar it on one server and untar it on the server where RB1.0.3 installed. Is there any better way to copy over? 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 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Existing Reviews not visible after rb-site upgrade
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 --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Existing Reviews not visible after rb-site upgrade
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.comreviewboard%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 -~--~~~~--~~--~--~---
Re: Existing Reviews not visible after rb-site upgrade
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.comreviewboard%2bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en -~--~~~~--~~--~--~ 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 -~--~~~~--~~--~--~---
Re: Existing Reviews not visible after rb-site upgrade
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.comreviewboard%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.comreviewboard%2bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en -~--~~~~--~~--~--~ 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 -~--~~~~--~~--~--~---
