Modify

Opened 9 years ago

Closed 6 years ago

#3796 closed defect (worksforme)

trac-admin upgrade fails

Reported by: michael.nitschke@… Owned by: Steffen Hoffmann
Priority: normal Component: TracFormsPlugin
Severity: blocker Keywords: needinfo upgrade SQL error
Cc: Trac Release: 0.11

Description (last modified by Ryan J Ollos)

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)

Attachments (0)

Change History (6)

comment:1 Changed 7 years ago by Ryan J Ollos

Description: modified (diff)
Summary: upgrade after enabeling in webadmin failstrac-admin upgrade fails

comment:2 Changed 7 years ago by Steffen Hoffmann

Keywords: upgrade SQL error added
Owner: changed from Rich Harkins to 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?

comment:3 Changed 6 years ago by Steffen Hoffmann

Keywords: needinfo added

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 6 years ago by 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.

comment:5 Changed 6 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 6 years ago by Steffen Hoffmann

Resolution: worksforme
Status: newclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Steffen Hoffmann.
The resolution will be deleted.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.