Error when using trac-admin upgrade

[anonymous]

I have upgraded my whole web server (apache, pyhthon, sqlite, trac, etc.). After installing the new version for FullBlogPlugin, when running the command: trac-admin /path/to/project upgrade it stopped with a stacktrace error message I have lost (sorry) that was something like this:

(...)
SQL ERROR: INDEX fullblog_comments_time_idx already exists
/usr/lib/python2.6/site-packages/TracFullBlogPlugin-0.1.1-py2.6.egg/tracfullblog/db.py line 70
/usr/lib/python2.6/site-packages/trac/db/sqlite_backend.py line 50
/usr/lib/python2.6/site-packages/trac/db/sqlite_backend.py line 58

I have solved the problem myself changing tracfullblog/db.py's 70th line to

    "CREATE INDEX IF NOT EXISTS fullblog_comments_time_idx ON fullblog_comments (time)")

and 72th line to

    "CREATE INDEX IF NOT EXISTS fullblog_posts_version_time_idx ON fullblog_posts (version_time)")

(the trick was adding IF NOT EXISTS)
I changed the source code that I had downloaded and installed the plugin again with easyinstall -Z -U path/to/my/source/

[anonymous]

Changed file to solve this issue

[Ryan J Ollos]

This shouldn't be a problem in the 1.4 branch at least.