Re: Error: Error applying evolution: (1051, "Unknown table 'auth_message'"). Occurred from upgrading from 1.6.13 to 1.7.7.1
Dear Christian, Version of Django Evolution is 0.6.9. Michael On Mon, May 20, 2013 at 3:07 AM, Christian Hammond wrote: > Hi Michael, > > Can you check what version of Django Evolution you have installed? You > should try to upgrade that if it's below 0.6.9. > > Christian > > > On May 19, 2013, at 5:47, Michael Zhu wrote: > > Dear all, > > # rb-site upgrade path/to/reviewboard > Rebuilding directory structure > Updating database. This may take a while. > > The log output below, including warnings and errors, > can be ignored unless upgrade fails. > > -- -- > Creating tables ... > There are unapplied evolutions for auth. > There are unapplied evolutions for accounts. > There are unapplied evolutions for diffviewer. > There are unapplied evolutions for reviews. > Project signature has changed - an evolution is required > Installing custom SQL ... > Installing indexes ... > Installed 0 object(s) from 0 fixture(s) > Error: Error applying evolution: (1051, "Unknown table 'auth_message'") > > > If I force to start server, error message is reported on some review > requests. Error log is below: > Traceback (most recent call last): > File > "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/handlers/base.py", > line 111, in get_response > response = callback(request, *callback_args, **callback_kwargs) > File > "/usr/lib/python2.7/site-packages/ReviewBoard-1.7.7.1-py2.7.egg/reviewboard/accounts/decorators.py", > line 22, in _check > return view_func(*args, **kwargs) > File > "/usr/lib/python2.7/site-packages/ReviewBoard-1.7.7.1-py2.7.egg/reviewboard/reviews/views.py", > line 538, in review_detail > objs = list(q) > File > "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/models/query.py", > line 87, in __len__ > self._result_cache.extend(self._iter) > File > "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/models/query.py", > line 291, in iterator > for row in compiler.results_iter(): > File > "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/models/sql/compiler.py", > line 763, in results_iter > for rows in self.execute_sql(MULTI): > File > "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/models/sql/compiler.py", > line 818, in execute_sql > cursor.execute(sql, params) > File > "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py", > line 114, in execute > return self.cursor.execute(query, args) > File "/usr/lib/python2.7/site-packages/MySQLdb/cursors.py", line 174, in > execute > self.errorhandler(self, exc, value) > File "/usr/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, > in defaulterrorhandler > raise errorclass, errorvalue > DatabaseError: (1054, "Unknown column > 'reviews_fileattachmentcomment.extra_data' in 'field list'") > > > Michael > > -- > 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 > --- > You received this message because you are subscribed to the Google Groups > "reviewboard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to reviewboard+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- > 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 > --- > You received this message because you are subscribed to the Google Groups > "reviewboard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to reviewboard+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at
Error: Error applying evolution: (1051, "Unknown table 'auth_message'"). Occurred from upgrading from 1.6.13 to 1.7.7.1
Dear all, # rb-site upgrade path/to/reviewboard Rebuilding directory structure Updating database. This may take a while. The log output below, including warnings and errors, can be ignored unless upgrade fails. -- -- Creating tables ... There are unapplied evolutions for auth. There are unapplied evolutions for accounts. There are unapplied evolutions for diffviewer. There are unapplied evolutions for reviews. Project signature has changed - an evolution is required Installing custom SQL ... Installing indexes ... Installed 0 object(s) from 0 fixture(s) Error: Error applying evolution: (1051, "Unknown table 'auth_message'") If I force to start server, error message is reported on some review requests. Error log is below: Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/core/handlers/base.py", line 111, in get_response response = callback(request, *callback_args, **callback_kwargs) File "/usr/lib/python2.7/site-packages/ReviewBoard-1.7.7.1-py2.7.egg/reviewboard/accounts/decorators.py", line 22, in _check return view_func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/ReviewBoard-1.7.7.1-py2.7.egg/reviewboard/reviews/views.py", line 538, in review_detail objs = list(q) File "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/models/query.py", line 87, in __len__ self._result_cache.extend(self._iter) File "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/models/query.py", line 291, in iterator for row in compiler.results_iter(): File "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/models/sql/compiler.py", line 763, in results_iter for rows in self.execute_sql(MULTI): File "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/models/sql/compiler.py", line 818, in execute_sql cursor.execute(sql, params) File "/usr/lib/python2.7/site-packages/Django-1.4.5-py2.7.egg/django/db/backends/mysql/base.py", line 114, in execute return self.cursor.execute(query, args) File "/usr/lib/python2.7/site-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue DatabaseError: (1054, "Unknown column 'reviews_fileattachmentcomment.extra_data' in 'field list'") Michael -- 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 --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Re: how to use nginx to host review board site
Dear Christian,
I setup refer to this link
http://www.rramsden.ca/blog/2011/09/26/nginx-reviewboard/.
My configuration is below:
server {
listen 80;
server_name review.mysite.com;
root /var/www/review.mysite.com/htdocs/;
location /media {
root /var/www/review.mysite.com/htdocs/;
}
location /errordoc {
root /var/www/review.mysite.com/htdocs/;
}
location / {
# host and port to fastcgi server
fastcgi_pass 127.0.0.1:3033;
fastcgi_param PATH_INFO $fastcgi_script_name;
fastcgi_param REQUEST_METHOD $request_method;
fastcgi_param QUERY_STRING $query_string;
fastcgi_param CONTENT_TYPE $content_type;
fastcgi_param CONTENT_LENGTH $content_length;
fastcgi_pass_header Authorization;
fastcgi_intercept_errors off;
}
}
But there is a strange problem. No error is reported on web on uploading
attachment/screenshot.
But in fact, no file is uploaded to media directory. If I place the file at
the right place under media
directory, it can not download from web.
Please help me.
Thanks!
Michael
On Tue, Aug 21, 2012 at 12:02 PM, Christian Hammond wrote:
> Hi Michael,
>
> Here's a configuration you can base yours off of:
>
>
> upstream reviews {
> server 127.0.0.1:6081;
> }
>
> server {
> listen 80;
> server_name reviews.reviewboard.org reviews.review-board.org;
> access_log /var/www/reviews.reviewboard.org/logs/nginx_access_log;
> error_log /var/www/reviews.reviewboard.org/logs/nginx_error_log;
>
> location / {
> proxy_pass http://reviews;
> proxy_redirect off;
> proxy_set_headerHost $host;
> proxy_set_headerX-Real-IP $remote_addr;
> proxy_set_headerX-Forwarded-For
> $proxy_add_x_forwarded_for;
> client_max_body_size10m;
> client_body_buffer_size 128k;
> proxy_connect_timeout 90;
> proxy_send_timeout 90;
> proxy_read_timeout 90;
> proxy_buffer_size 4k;
> proxy_buffers 4 32k;
> proxy_busy_buffers_size 64k;
> proxy_temp_file_write_size 64k;
> }
>
> location /media/ {
> alias /var/www/reviews.reviewboard.org/htdocs/media/;
>
> if ($query_string) {
> expires max;
> }
> }
>
> location /static/ {
> alias /var/www/reviews.reviewboard.org/htdocs/static/;
>
> if ($query_string) {
> expires max;
> }
> }
>
> location /errordocs/ {
> alias /var/www/reviews.reviewboard.org/htdocs/errordocs/;
> expires 30d;
> }
> }
>
>
> Christian
>
>
> --
> Christian Hammond - chip...@chipx86.com
> Review Board - http://www.reviewboard.org
> VMware, Inc. - http://www.vmware.com
>
>
> On Mon, Aug 20, 2012 at 7:49 PM, Michael Zhu wrote:
>
>> Dear all,
>>
>> I want to setup reviewboard using nginx. please help me.
>> thank you all.
>> B.R.
>>
>>
>> Michael
>>
>> --
>> 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
>
>
> --
> 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
--
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
how to use nginx to host review board site
Dear all, I want to setup reviewboard using nginx. please help me. thank you all. B.R. Michael -- 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
