Sure, all you need to do is update to at least that revision, you can do that 
with:

% hg pull -u -r 89190bcd1ccf http://bitbucket.org/galaxy/galaxy-central/



On Mar 24, 2011, at 4:58 AM, Vincent Le Texier wrote:

> Hello Dannon,
> Thanks for your answer. So could you tell me when this issue will be resolved 
> ? Can I apply a patch now and how ?
> I am facing problem with galaxy-reports and mysql (date_trunc of Postgresql), 
> so it would be better for me to use postgreSQL 9.
> Vincent
> 
> Le 3/22/11 6:13 PM, Dannon Baker a écrit :
>> Vincent,
>> 
>> This issue should be resolved after changeset 5074:89190bcd1ccf, available 
>> in the galaxy-central repository.  This change will also be available in the 
>> near future in the galaxy-dist repository.
>> 
>> Thanks!
>> 
>> Dannon
>> 
>> 
>> 
>> On Mar 22, 2011, at 12:59 PM, Vincent Le Texier wrote:
>> 
>>> Hello everyone,
>>> I am having trouble to save/edit a workflow with postgreSQL 9.0.3.
>>> (It works fine if I use MySQL)
>>> 
>>> Any idea of the problem ?
>>> 
>>> I get the following error (JSONDecodeError: No JSON object could be 
>>> decoded: line 1 column 0 (char 0))  :
>>> 
>>> 
>>> URL: http://localhost:8080/workflow
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/WebError-0.8a-py2.6.egg/weberror/evalexception/middleware.py',
>>>  line 364 in respond
>>>   app_iter = self.application(environ, detect_start_response)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/Paste-1.6-py2.6.egg/paste/debug/prints.py',
>>>  line 98 in __call__
>>>   environ, self.app)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/Paste-1.6-py2.6.egg/paste/wsgilib.py',
>>>  line 539 in intercept_output
>>>   app_iter = application(environ, replacement_start_response)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/Paste-1.6-py2.6.egg/paste/recursive.py',
>>>  line 80 in __call__
>>>   return self.application(environ, start_response)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/Paste-1.6-py2.6.egg/paste/httpexceptions.py',
>>>  line 632 in __call__
>>>   return self.application(environ, start_response)
>>> File '/data-ddn/home/galaxy/galaxy-dist/lib/galaxy/web/framework/base.py', 
>>> line 145 in __call__
>>>   body = method( trans, **kwargs )
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/lib/galaxy/web/controllers/workflow.py', 
>>> line 114 in index
>>>   return self.list( trans )
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/lib/galaxy/web/framework/__init__.py', 
>>> line 84 in decorator
>>>   return func( self, trans, *args, **kwargs )
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/lib/galaxy/web/controllers/workflow.py', 
>>> line 139 in list
>>>   .order_by( desc( model.StoredWorkflow.table.c.update_time ) ) \
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/query.py',
>>>  line 1267 in all
>>>   return list(self)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/query.py',
>>>  line 1422 in instances
>>>   rows = [process[0](context, row) for row in fetch]
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/query.py',
>>>  line 2032 in main
>>>   return _instance(row, None)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/mapper.py',
>>>  line 1729 in _instance
>>>   populate_state(state, dict_, row, isnew, only_load_props)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/mapper.py',
>>>  line 1614 in populate_state
>>>   populator(state, dict_, row, isnew=isnew, **flags)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/strategies.py',
>>>  line 762 in execute
>>>   dict_[key] = _instance(row, None)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/mapper.py',
>>>  line 1729 in _instance
>>>   populate_state(state, dict_, row, isnew, only_load_props)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/mapper.py',
>>>  line 1614 in populate_state
>>>   populator(state, dict_, row, isnew=isnew, **flags)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/strategies.py',
>>>  line 781 in execute
>>>   _instance(row, result_list)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/mapper.py',
>>>  line 1729 in _instance
>>>   populate_state(state, dict_, row, isnew, only_load_props)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/mapper.py',
>>>  line 1614 in populate_state
>>>   populator(state, dict_, row, isnew=isnew, **flags)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/orm/strategies.py',
>>>  line 120 in new_execute
>>>   dict_[key] = row[col]
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py',
>>>  line 1348 in __getitem__
>>>   return self.__parent._get_col(self.__row, key)
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py',
>>>  line 1620 in _get_col
>>>   return processor(row[index])
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/types.py',
>>>  line 288 in process
>>>   return self.process_result_value(value, dialect)
>>> File '/data-ddn/home/galaxy/galaxy-dist/lib/galaxy/model/custom_types.py', 
>>> line 32 in process_result_value
>>>   return json_decoder.decode( str( value ) )
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/simplejson-2.1.1-py2.6-linux-x86_64-ucs2.egg/simplejson/decoder.py',
>>>  line 402 in decode
>>> File 
>>> '/data-ddn/home/galaxy/galaxy-dist/eggs/simplejson-2.1.1-py2.6-linux-x86_64-ucs2.egg/simplejson/decoder.py',
>>>  line 420 in raw_decode
>>> JSONDecodeError: No JSON object could be decoded: line 1 column 0 (char 0)
>>> -- 
>>> Vincent Le Texier
>>> Senior Software Engineer
>>> Synergie Lyon Cancer
>>> Leon Berard Center, Cheney C
>>> 28, rue Laennec
>>> 69373 LYON Cedex 08
>>> +33 4 26 55 67 85
>>> 
>>> letex...@lyon.fnclcc.fr
>>> ___________________________________________________________
>>> The Galaxy User list should be used for the discussion of
>>> Galaxy analysis and other features on the public server
>>> at usegalaxy.org.  Please keep all replies on the list by
>>> using "reply all" in your mail client.  For discussion of
>>> local Galaxy instances and the Galaxy source code, please
>>> use the Galaxy Development list:
>>> 
>>>  http://lists.bx.psu.edu/listinfo/galaxy-dev
>>> 
>>> To manage your subscriptions to this and other Galaxy lists,
>>> please use the interface at:
>>> 
>>>  http://lists.bx.psu.edu/
> 
> 
> -- 
> Vincent Le Texier
> Senior Software Engineer
> Synergie Lyon Cancer
> Leon Berard Center, Cheney C
> 28, rue Laennec
> 69373 LYON Cedex 08
> +33 4 26 55 67 85
> letex...@lyon.fnclcc.fr
> 


___________________________________________________________
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org.  Please keep all replies on the list by
using "reply all" in your mail client.  For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:

  http://lists.bx.psu.edu/listinfo/galaxy-dev

To manage your subscriptions to this and other Galaxy lists,
please use the interface at:

  http://lists.bx.psu.edu/

Reply via email to