Hi Stefano, at first my simplesjon version is
python-simplejson-2.0.9-8.el5 but my trac version is
trac-0.11.5-1.el5.rf. Anyway, I tried the upgrade to
trac-0.12-2.el5.rf and when I did this, all my trac projects started
asking for an upgrade. In the project, I have agilo configured I tried
to do the upgrade but it fails with this error message:

# trac-admin . upgrade
ProgrammingError: relation "agilo_link" already exists

On 25 September 2012 11:32, Stefano Rago <[email protected]> wrote:
> Hi Bernardo,
>
> can you please try what's suggested on this thread and see if that fixes your 
> problem?
>
> https://groups.google.com/d/topic/agilo/txxMFrhInkg/discussion
> Cheers
>
> Stefano
>
> On Sep 6, 2012, at 2:12 PM, Bernardo Costa <[email protected]> wrote:
>
>> This is the output I got from the console when I try to make an
>> upgrade of a agilo enabled project. It looks like a problem on
>> creating a table.
>>
>> <module 'agilo' from
>> '/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/__init__.pyc'>
>> Traceback (most recent call last):
>>  File "/tmp/sdb1/trac-admin", line 7, in ?
>>    sys.exit(
>>  File "/usr/lib/python2.4/site-packages/trac/admin/console.py", line
>> 1314, in run
>>    return admin.onecmd(command)
>>  File "/usr/lib/python2.4/site-packages/trac/admin/console.py", line
>> 133, in onecmd
>>    rv = cmd.Cmd.onecmd(self, line) or 0
>>  File "/usr/lib64/python2.4/cmd.py", line 219, in onecmd
>>    return func(arg)
>>  File "/usr/lib/python2.4/site-packages/trac/admin/console.py", line
>> 1154, in do_upgrade
>>    self.__env.upgrade(backup=do_backup)
>>  File "/usr/lib/python2.4/site-packages/trac/env.py", line 457, in upgrade
>>    participant.upgrade_environment(db)
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/db/plugin_env_setup.py",
>> line 77, in upgrade_environment
>>    return self.environment_created()
>>  File "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/init.py",
>> line 142, in environment_created
>>    initialize_config(self.env, __CONFIG_PROPERTIES__)
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/utils/config.py",
>> line 724, in initialize_config
>>    config = AgiloConfig(env)
>>  File "/usr/lib/python2.4/site-packages/trac/core.py", line 111, in 
>> maybe_init
>>    init(self)
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/utils/config.py",
>> line 439, in __init__
>>    self.reload(init=True)
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/utils/config.py",
>> line 674, in reload
>>    self.notify_other_components_of_config_change()
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/utils/config.py",
>> line 630, in notify_other_components_of_config_change
>>    for listener in self.config_change_listeners:
>>  File "/usr/lib/python2.4/site-packages/trac/core.py", line 70, in extensions
>>    return filter(None, [component.compmgr[cls] for cls in extensions])
>>  File "/usr/lib/python2.4/site-packages/trac/core.py", line 207, in 
>> __getitem__
>>    component = cls(self)
>>  File "/usr/lib/python2.4/site-packages/trac/core.py", line 111, in 
>> maybe_init
>>    init(self)
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/utils/permissions.py",
>> line 59, in __init__
>>    self.config_reloaded()
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/utils/permissions.py",
>> line 67, in config_reloaded
>>    self.get_actions_for_custom_types()
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/utils/permissions.py",
>> line 71, in get_actions_for_custom_types
>>    plain_name = str('CREATE_' + typename.upper())
>> UnicodeEncodeError: 'ascii' codec can't encode characters in position
>> 12-13: ordinal not in range(128)
>>
>> After getting this error, I thought the problem might be related to
>> having two python instructions in the same line. So I splited "import
>> agilo; print agilo" in two lines and then tried to do the upgrade
>> again. Now the error message is another but still something elated to
>> database structure. See the attached sql file to see how the database
>> schema is now. I am using postgresql as database.
>>
>> <module 'agilo' from
>> '/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/__init__.pyc'>
>> Traceback (most recent call last):
>>  File "/tmp/sdb1/trac-admin", line 8, in ?
>>    sys.exit(
>>  File "/usr/lib/python2.4/site-packages/trac/admin/console.py", line
>> 1314, in run
>>    return admin.onecmd(command)
>>  File "/usr/lib/python2.4/site-packages/trac/admin/console.py", line
>> 133, in onecmd
>>    rv = cmd.Cmd.onecmd(self, line) or 0
>>  File "/usr/lib64/python2.4/cmd.py", line 219, in onecmd
>>    return func(arg)
>>  File "/usr/lib/python2.4/site-packages/trac/admin/console.py", line
>> 1154, in do_upgrade
>>    self.__env.upgrade(backup=do_backup)
>>  File "/usr/lib/python2.4/site-packages/trac/env.py", line 457, in upgrade
>>    participant.upgrade_environment(db)
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/db/plugin_env_setup.py",
>> line 77, in upgrade_environment
>>    return self.environment_created()
>>  File "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/init.py",
>> line 124, in environment_created
>>    create_table(self.env, table)
>>  File 
>> "/usr/lib/python2.4/site-packages/agilo-0.9.8-py2.4.egg/agilo/utils/db.py",
>> line 143, in create_table
>>    cursor.execute(statement)
>>  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 60, in execute
>>    return self.cursor.execute(sql)
>>  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 60, in execute
>>    return self.cursor.execute(sql)
>> psycopg2.ProgrammingError: relation "agilo_link" already exists
>>
>> On 6 September 2012 05:03, Stefano Rago <[email protected]> 
>> wrote:
>>> Hi Bernardo,
>>>
>>> On Aug 20, 2012, at 1:45 PM, Bernardo Costa wrote:
>>>
>>> Here it is.
>>>
>>> $ cat $(which trac-admin)
>>> #!/usr/bin/python
>>> # EASY-INSTALL-ENTRY-SCRIPT: 'Trac==0.11.5','console_scripts','trac-admin'
>>> __requires__ = 'Trac==0.11.5'
>>> import sys
>>> from pkg_resources import load_entry_point
>>>
>>> sys.exit(
>>>   load_entry_point('Trac==0.11.5', 'console_scripts', 'trac-admin')()
>>> )
>>>
>>>
>>>
>>> Have you been able to fix the issue?
>>> If not, can you please try to add this line to your trac-admin.sh
>>>
>>> import agilo; print agilo
>>>
>>> right before the line
>>>
>>> sys.exit(
>>>
>>> and report the output?
>>>
>>>
>>> Cheers
>>>
>>>
>>>
>>> Stefano Rago
>>>
>>> --
>>> Follow Agilo on Twitter: http://twitter.com/agilofortrac
>>> Please support us by reviewing and voting on:
>>> http://userstories.com/products/8-agilo-for-scrum
>>> http://ohloh.net/p/agilo-trac
>>> http://freshmeat.net/projects/agiloforscrum
>>>
>>> You have received this message because you are subscribed to
>>> the "Agilo for Trac" Google Group. This group is focused on
>>> supporting Agilo for Trac users and is moderated by
>>> Agilo Software GmbH <http://www.agilosoftware.com>.
>>>
>>> To post to this group, send email to [email protected]
>>> To unsubscribe from this group, send an email to
>>> [email protected]
>>> For more options, visit this group at
>>> http://groups.google.com/group/agilo
>>
>> --
>> Follow Agilo on Twitter: http://twitter.com/agilofortrac
>> Please support us by reviewing and voting on:
>> http://userstories.com/products/8-agilo-for-scrum
>> http://ohloh.net/p/agilo-trac
>> http://freshmeat.net/projects/agiloforscrum
>>
>> You have received this message because you are subscribed to
>> the "Agilo for Trac" Google Group. This group is focused on
>> supporting Agilo for Trac users and is moderated by
>> Agilo Software GmbH <http://www.agilosoftware.com>.
>>
>> To post to this group, send email to [email protected]
>> To unsubscribe from this group, send an email to
>> [email protected]
>> For more options, visit this group at
>> http://groups.google.com/group/agilo
>> <tracdb.sql>
>
> --
> Follow Agilo on Twitter: http://twitter.com/agilofortrac
> Please support us by reviewing and voting on:
> http://userstories.com/products/8-agilo-for-scrum
> http://ohloh.net/p/agilo-trac
> http://freshmeat.net/projects/agiloforscrum
>
> You have received this message because you are subscribed to
> the "Agilo for Trac" Google Group. This group is focused on
> supporting Agilo for Trac users and is moderated by
> Agilo Software GmbH <http://www.agilosoftware.com>.
>
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send an email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/agilo

-- 
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on: 
http://userstories.com/products/8-agilo-for-scrum 
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to [email protected]
To unsubscribe from this group, send an email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo

Reply via email to