page editor problem when saving Chinese - galaxy-dev

18 Oct 2013


      I run a local instance of galaxy and edit content of a page, error occurs when the content contains Chinese:
URL: http://127.0.0.1:8080/page/save
Module weberror.evalexception.middleware:364 in respond
...
...
app_iter = self.application(environ, detect_start_response)
Module paste.recursive:84 in __call__
...
...
return self.application(environ, start_response)
Module paste.httpexceptions:633 in __call__
...
...
return self.application(environ, start_response)
Module galaxy.web.framework.base:132 in __call__
...
...
return self.handle_request( environ, start_response )
Module galaxy.web.framework.base:190 in handle_request
...
...
body = method( trans, **kwargs )
Module galaxy.web.framework:98 in decorator
...
...
return func( self, trans, *args, **kwargs )
Module galaxy.webapps.galaxy.controllers.page:566 in save
...
...
trans.sa_session.flush()
Module sqlalchemy.orm.scoping:114 in do
Module sqlalchemy.orm.session:1718 in flush
Module sqlalchemy.orm.session:1789 in _flush
Module sqlalchemy.orm.unitofwork:331 in execute
Module sqlalchemy.orm.unitofwork:475 in execute
Module sqlalchemy.orm.persistence:64 in save_obj
Module sqlalchemy.orm.persistence:558 in _emit_insert_statements
Module sqlalchemy.engine.base:1449 in execute
Module sqlalchemy.engine.base:1584 in _execute_clauseelement
Module sqlalchemy.engine.base:1698 in _execute_context
Module sqlalchemy.engine.base:1691 in _execute_context
Module sqlalchemy.engine.default:331 in do_execute
ProgrammingError: (ProgrammingError) You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings. u'INSERT INTO page_revision (create_time, update_time, page_id, title, content) VALUES (?, ?, ?, ?, ?)' ('2013-10-18 17:09:01.226991', '2013-10-18 17:09:01.227000', 1, u'test', '<p>aavdx</p><p>\xe4\xb8\xad</p>')
[]