trac-admin upgrade fails

[michael.nitschke@…]

d:\Program Files\Python25\Scripts>trac-admin g:\projects\trac\newone upgrade

Traceback (most recent call last):
  File "d:\Program Files\Python25\Scripts\trac-admin-script.py", line 8, in <mod
ule>
    load_entry_point('Trac==0.11.1', 'console_scripts', 'trac-admin')()
  File "d:\Program Files\Python25\Lib\site-packages\trac\admin\console.py", line
 1295, in run
    return admin.onecmd(command)
  File "d:\Program Files\Python25\Lib\site-packages\trac\admin\console.py", line
 123, in onecmd
    rv = cmd.Cmd.onecmd(self, line) or 0
  File "d:\Program Files\Python25\lib\cmd.py", line 219, in onecmd
    return func(arg)
  File "d:\Program Files\Python25\Lib\site-packages\trac\admin\console.py", line
 1145, in do_upgrade
    self.__env.upgrade(backup=do_backup)
  File "d:\Program Files\Python25\Lib\site-packages\trac\env.py", line 442, in u
pgrade
    participant.upgrade_environment(db)
  File "build\bdist.win32\egg\tracforms\tracdb.py", line 137, in upgrade_environ
ment
  File "build\bdist.win32\egg\tracforms\formdb.py", line 198, in dbschema_2008_0
6_15_0000
  File "build\bdist.win32\egg\tracforms\tracdb.py", line 87, in __call__
  File "build\bdist.win32\egg\tracforms\tracdb.py", line 42, in execute
sqlite3.OperationalError: near "unsigned": syntax error

other upgrades (for example BlogPartsMacro work like a charm)

[Steffen Hoffmann]

The attempted Trac db 'upgrade' should create the first TracForms tables schema. Now we've some more revisions and variants support for special SQL db systems (MySQL) since [3967] - quite a long time.

Issue is still there? What database do you use? Could you test current trunk code to be sure about current status of development regarding this issue, please?

[Steffen Hoffmann]

Ping.

The error obviously has been raised exactly by the alternative table creation statement for dbtype == 'mysql'. But this issue will be closed soon, if not relevant anymore, as suggested by missing feedback.

[Steffen Hoffmann]

I'd really appreciate, if someone could check and report on TracForms 0.4 using a MySQL Trac db.

The major rewrite initiated to get PostgreSQL support (see changeset [10211]) should have fixed this as well. If you find it working, please drop a note here.

[michael.nitschke@…]

Im sorry but i can not give you feedback, because i was assigned to an other project and have no access to the original system anymore.

[Steffen Hoffmann]

So let's assume this has been resolved as suggested before.