Hi All,
I have been using agile for long time and I am working agile 7.3
source we have planned to upgrade our TRAC and Agile to its newer
version. In the installation level I have not got any issues when
update the existing projects to new Instance of Agile and Trac I have
got an issue on the agile DB upgrade, for your reference I have
enclosed my old Trac details and current Trac details with error log.
Note:- When I create a new project in the Latest instance it works
fine, When I upgraded my old projects alone I have got an issue.
Thanks for you assistance in Advance
Previous Setup:-
Trac11.1
Agile 7.3
Python2.5
Sqlite3.5
Current Setup:-
Trac12.2
Agile 9.5
Python2.6
Sqlite3.7
Error log:-
2011-11-09 09:34:21,365 Trac[env] WARNING: Component
<agilo.init.AgiloInit object at 0xa19bcac> requires environment
upgrade
2011-11-09 09:34:21,378 Trac[env] INFO: agilo.init.AgiloInit
upgrading...
2011-11-09 09:34:22,177 Trac[plugin_env_setup] ERROR: Exception while
upgrading agilo database: no such column: None
2011-11-09 09:34:22,177 Trac[plugin_env_setup] ERROR: Upgrading agilo
tables failed!
2011-11-09 09:34:22,179 Trac[console] ERROR: Exception in trac-admin
command:
Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/admin/console.py", line 107, in onecmd
rv = cmd.Cmd.onecmd(self, line) or 0
File "/usr/lib/python2.6/cmd.py", line 218, in onecmd
return self.default(line)
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/admin/console.py", line 266, in default
return cmd_mgr.execute_command(*args)
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/admin/api.py", line 123, in execute_command
return f(*fargs)
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/env.py", line 782, in _do_upgrade
self.env.upgrade(backup=no_backup is None)
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/env.py", line 525, in upgrade
with_transaction(self)(participant.upgrade_environment)
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/db/api.py", line 77, in transaction_wrapper
fn(ldb)
File "/usr/local/lib/python2.6/dist-packages/agilo-0.9.4-py2.6.egg/
agilo/db/plugin_env_setup.py", line 81, in upgrade_environment
successful_upgrade = self.run_upgrade_scripts(cursor, db_ver)
File "/usr/local/lib/python2.6/dist-packages/agilo-0.9.4-py2.6.egg/
agilo/db/plugin_env_setup.py", line 157, in run_upgrade_scripts
upgrade_was_successful = script.do_upgrade(self.env, i, cursor,
connector)
File "/usr/local/lib/python2.6/dist-packages/agilo-0.9.4-py2.6.egg/
agilo/db/upgrades/db4.py", line 32, in do_upgrade
_convert_ordinals_to_timestamps(cursor)
File "/usr/local/lib/python2.6/dist-packages/agilo-0.9.4-py2.6.egg/
agilo/db/upgrades/db4.py", line 62, in _convert_ordinals_to_timestamps
cursor.execute(base_sql + value_sql)
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/db/util.py", line 66, in execute
return self.cursor.execute(sql)
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/db/sqlite_backend.py", line 78, in execute
result = PyFormatCursor.execute(self, *args)
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/db/sqlite_backend.py", line 56, in execute
args or [])
File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/
trac/db/sqlite_backend.py", line 48, in _rollback_on_error
return function(self, *args, **kwargs)
OperationalError: no such column: None
Thanks,
Vela.
--
Follow Agilo on Twitter: http://twitter.com/agiloforscrum
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-scrum
http://freshmeat.net/projects/agiloforscrum
You have received this message because you are subscribed to
the "Agilo for Scrum" Google Group. This group is focused on
supporting Agilo for Scrum users and is moderated by
Agilo Software GmbH <http://www.agiloforscrum.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