Issue 2550542
Created on 2009-04-29 09:54 by jrplant, last changed 2012-01-05 21:51 by schlatterbeck.
| Messages | |||
|---|---|---|---|
| msg3698 | Author: [hidden] (jrplant) | Date: 2009-04-29 09:54 | |
When running "roundup-admin migrate" to upgrade to 1.4.6 on my roundup
1.3.3 installation with sqlite backend, the function
"fix_version_4_tables" in /usr/local/lib/python2.5/site-
packages/roundup/backends/rdbms_common.py (quoted below)
> def fix_version_4_tables(self):
> # note this is an explicit call now
> c = self.cursor
> for cn, klass in self.classes.items():
> c.execute('select id from _%s where __retired__<>0'%(cn,))
> for (id,) in c.fetchall():
> c.execute('update _%s set __retired__=%s where
id=%s'%(cn,
> self.arg, self.arg), (id, id))
...
throws the error:
> Traceback (most recent call last):
> File "/usr/local/bin/roundup-admin", line 6, in <module>
> run()
> File "/usr/local/lib/python2.5/site-
packages/roundup/scripts/roundup_admin.py", line 38, in run
> sys.exit(tool.main())
> File "/usr/local/lib/python2.5/site-packages/roundup/admin.py", line
1529, in main
> ret = self.run_command(args)
> File "/usr/local/lib/python2.5/site-packages/roundup/admin.py", line
1428, in run_command
> self.db = tracker.open('admin')
> File "/usr/local/lib/python2.5/site-packages/roundup/instance.py",
line 130, in open
> db.post_init()
> File "/usr/local/lib/python2.5/site-
packages/roundup/backends/rdbms_common.py", line 234, in post_init
> save = save | self.upgrade_db()
> File "/usr/local/lib/python2.5/site-
packages/roundup/backends/rdbms_common.py", line 287, in upgrade_db
> self.fix_version_4_tables()
> File "", line 309, in fix_version_4_tables
> for (id,) in c.fetchall():
> TypeError: 'sqlite3.Row' object is not iterable
(Noticing that the code above changed the value of __retired__ to be the
same as 'id' for rows where __retired__ was non-zero for all the object
classes in the database, I worked around this by manually updating the
tables, then commenting out the code above. This allowed "roundup-admi
n migrate" to complete without error.
|
|||
| msg4483 | Author: [hidden] (schlatterbeck) | Date: 2012-01-05 21:51 | |
closing as out of date for ancient 1.4.6 version. |
|||
| History | |||
|---|---|---|---|
| Date | User | Action | Args |
| 2012-01-05 21:51:09 | schlatterbeck | set | status: new -> closed resolution: out of date messages: + msg4483 nosy: + schlatterbeck |
| 2009-04-29 09:54:10 | jrplant | create | |