Hi,
i just pulled the latest git,
and tried to display a table with an emoji in comments of the table
and i got an exception...
using python3.5
4398d1d8694024b3f357e74fba4683d5f3cd5745
here is the traceback
2016-06-04 00:23:15,050: ERROR pgadmin: Exception on
/browser/table/sql/1/1/25554/2200/34037 [GET]
Traceback (most recent call last):
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1817, in wsgi_app
response = self.full_dispatch_request()
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/_compat.py",
line 33, in reraise
raise value
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1475, in full_dispatch_request
rv = self.dispatch_request()
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/views.py",
line 84, in view
return self.dispatch_request(*args, **kwargs)
File "/tmp/pgadmin4/web/pgadmin/browser/utils.py", line 233, in
dispatch_request
return method(*args, **kwargs)
File
"/tmp/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py",
line 328, in wrap
return f(*args, **kwargs)
File
"/tmp/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py",
line 2437, in sql
data=data, conn=self.conn)
File
"/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/templating.py", line
128, in render_template
context, ctx.app)
File
"/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/templating.py", line
110, in _render
rv = template.render(context)
File
"/tmp/pgadmin4/venv3/lib/python3.5/site-packages/jinja2/environment.py",
line 969, in render
return self.environment.handle_exception(exc_info, True)
File
"/tmp/pgadmin4/venv3/lib/python3.5/site-packages/jinja2/environment.py",
line 742, in handle_exception
reraise(exc_type, exc_value, tb)
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/jinja2/_compat.py",
line 36, in reraise
raise value.with_traceback(tb)
File
"/tmp/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/table/sql/9.5_plus/create.sql",
line 123, in <module>
IS {{c.description|qtLiteral}};
File "/tmp/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py", line
1405, in qtLiteral
res = adapt(value).getquoted()
UnicodeEncodeError: 'latin-1' codec can't encode character '\U0001f4a9' in
position 6: ordinal not in range(256)
2016-06-04 00:23:17,443: ERROR pgadmin: Exception on
/browser/table/sql/1/1/25554/2200/34037 [GET]
Traceback (most recent call last):
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1817, in wsgi_app
response = self.full_dispatch_request()
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/_compat.py",
line 33, in reraise
raise value
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1475, in full_dispatch_request
rv = self.dispatch_request()
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/app.py", line
1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/views.py",
line 84, in view
return self.dispatch_request(*args, **kwargs)
File "/tmp/pgadmin4/web/pgadmin/browser/utils.py", line 233, in
dispatch_request
return method(*args, **kwargs)
File
"/tmp/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py",
line 328, in wrap
return f(*args, **kwargs)
File
"/tmp/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py",
line 2437, in sql
data=data, conn=self.conn)
File
"/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/templating.py", line
128, in render_template
context, ctx.app)
File
"/tmp/pgadmin4/venv3/lib/python3.5/site-packages/flask/templating.py", line
110, in _render
rv = template.render(context)
File
"/tmp/pgadmin4/venv3/lib/python3.5/site-packages/jinja2/environment.py",
line 969, in render
return self.environment.handle_exception(exc_info, True)
File
"/tmp/pgadmin4/venv3/lib/python3.5/site-packages/jinja2/environment.py",
line 742, in handle_exception
reraise(exc_type, exc_value, tb)
File "/tmp/pgadmin4/venv3/lib/python3.5/site-packages/jinja2/_compat.py",
line 36, in reraise
raise value.with_traceback(tb)
File
"/tmp/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/table/sql/9.5_plus/create.sql",
line 123, in <module>
IS {{c.description|qtLiteral}};
File "/tmp/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py", line
1405, in qtLiteral
res = adapt(value).getquoted()
UnicodeEncodeError: 'latin-1' codec can't encode character '\U0001f4a9' in
position 6: ordinal not in range(256)
btw, sorry to reach you guys directly but i can't post on *-hackers and
don't think there is a bug tracker somewhere?
regards,
Brice
