Modify

Opened 6 years ago

Closed 3 years ago

#3796 closed defect (worksforme)

trac-admin upgrade fails

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

Description (last modified by rjollos)

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 4 years ago by rjollos

  • Description modified (diff)
  • Summary changed from upgrade after enabeling in webadmin fails to trac-admin upgrade fails

comment:2 Changed 3 years ago by hasienda

  • Keywords upgrade SQL error added
  • 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

  • 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 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.

Add Comment

Modify Ticket

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from hasienda. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.