Opened 5 years ago

Closed 3 years ago

#3796 closed defect (worksforme)

Reported by: Owned by: michael.nitschke@… hasienda normal TracFormsPlugin blocker needinfo upgrade SQL error 0.11

Traceback (most recent call last):
File "d:\Program Files\Python25\Scripts\trac-admin-script.py", line 8, in <mod
ule>
1295, in run
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\env.py", line 442, in u
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)

comment:1 Changed 3 years ago by rjollos

• Description modified (diff)

comment:2 Changed 3 years ago by hasienda

• Owner changed from rharkins to hasienda

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?

comment:3 Changed 3 years ago by hasienda

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.

comment:4 Changed 3 years ago by hasienda

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.

comment:5 Changed 3 years ago by 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.

comment:6 Changed 3 years ago by hasienda

• Resolution set to worksforme
• Status changed from new to closed

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

Modify Ticket

Change Properties