Edgewall Software

Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#13091 closed defect (cantfix)

Several plugins report "OperationalError: table wiki has no column named ipnr" on upgrade

Reported by: matthias@… Owned by:
Priority: normal Milestone:
Component: general Version:
Severity: minor Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


With Trac 1.3.2 I tried out several plugins for time estimation / tracking. After activation of the plugin in the admin section of trac, it requires me to run trac-admin upgrade. The upgrade fails with the error message:

OperationalError: table wiki has no column named ipnr

I checked the db schema of the project and the column really doesn't exist:

trac /srv/trac/projekt1/db >sqlite3 trac.db
SQLite version 3.25.1 2018-09-18 20:20:44
Enter ".help" for usage hints.
sqlite> .schema wiki
    name text,
    version integer,
    time integer,
    author text,
    text text,
    comment text,
    readonly integer,
    UNIQUE (name,version)
CREATE INDEX wiki_time_idx ON wiki (time);

Beeing new to trac, I'd like to ask if:

a) This column was part of a former trac version and was dropped for the devel branch? In this case - what was the purpose of this column?

b) This column was never part of the trac db scheme and maybe was added by another plugin?

c) The column should be there, but my installation is wrong?

Attachments (0)

Change History (4)

comment:1 by Jun Omae, 3 years ago

Milestone: not applicable
Resolution: cantfix
Status: newclosed

Please ask on the MailingList for support questions.

Also, the ipnr columns have been removed in milestone:1.3.1 (#9612).

comment:2 by Jun Omae, 3 years ago

Type: taskdefect

comment:3 by Jun Omae, 3 years ago

The 1.3.x is development version for committers, plugin authors, early testers…. If you will use Trac under production, you should use 1.2.x or 1.0.x.

comment:4 by Ryan J Ollos, 3 years ago

It would be helpful if you filed reports for the incompatible plugins to the plugin's issue tracker.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.