page editor problem when saving Chinese

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>')
[]

lardo

Jeremy Goecks

tags

participants (2)