Edgewall Software
Modify

Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#12949 closed defect (cantfix)

ProgrammingError: column "ipnr" does not existLINE 2: ... SELECT filename, description, size, time, author, ipnr ^

Reported by: emecas Owned by:
Priority: normal Milestone:
Component: general Version: 1.2.2
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

How to Reproduce

While doing a GET operation on any ticket /ticket/<##>, Trac issued an internal error.

I've tried too by disabling all active plugins and updating from trac 1.2.2DEV to 1.2.2, but error still same.

Request parameters:

{'id': u'<##>'}

<##> —> any valid ticket number

User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:55.0) Gecko/20100101 Firefox/55.0

System Information

Trac 1.2.2
Genshi 0.7 (with speedups)
GIT 2.10.1
psycopg2 2.6.1
Python 2.7.10 (default, Oct 23 2015, 19:19:21)
[GCC 4.2.1 Compatible Apple LLVM 7.0.0 (clang-700.0.59.5)]
pytz 2013.7
setuptools 23.1.0
jQuery 1.11.3
jQuery UI 1.11.4
jQuery Timepicker 1.5.5

Enabled Plugins

Interface Customization

shared-htdocs
shared-templates
site-htdocs PreviewCompanies1_2_3.png, StatusKPIsPreview.png, StatusKPIsPreview1.png, allGraph.png, draftModel.jpg, operaciones.sql, previewCompany1.png, site, your_project_logo.png
site-templates

Python Traceback

Traceback (most recent call last):
  File "build/bdist.macosx-10.11-intel/egg/trac/web/main.py", line 623, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.macosx-10.11-intel/egg/trac/web/main.py", line 239, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.macosx-10.11-intel/egg/trac/ticket/web_ui.py", line 174, in process_request
    return self._process_ticket_request(req)
  File "build/bdist.macosx-10.11-intel/egg/trac/ticket/web_ui.py", line 691, in _process_ticket_request
    get_reporter_id(req, 'author'), field_changes)
  File "build/bdist.macosx-10.11-intel/egg/trac/ticket/web_ui.py", line 1762, in _insert_ticket_data
    'attachments': AttachmentModule(self.env).attachment_data(context),
  File "build/bdist.macosx-10.11-intel/egg/trac/attachment.py", line 265, in attachment_data
    attachments = self.viewable_attachments(context)
  File "build/bdist.macosx-10.11-intel/egg/trac/attachment.py", line 256, in viewable_attachments
    for attachment in Attachment.select(self.env, parent.realm, parent.id):
  File "build/bdist.macosx-10.11-intel/egg/trac/attachment.py", line 902, in select
    """, (parent_realm, unicode(parent_id))):
  File "build/bdist.macosx-10.11-intel/egg/trac/db/api.py", line 122, in execute
    return db.execute(query, params)
  File "build/bdist.macosx-10.11-intel/egg/trac/db/util.py", line 128, in execute
    cursor.execute(query, params if params is not None else [])
  File "build/bdist.macosx-10.11-intel/egg/trac/db/util.py", line 72, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: column "ipnr" does not exist
LINE 2: ...      SELECT filename, description, size, time, author, ipnr
                                                                   ^

Attachments (0)

Change History (3)

comment:1 by Jun Omae, 6 years ago

Resolution: cantfix
Status: newclosed

InstallationIssue.

I believe you've upgraded to 1.3.x and downgraded to 1.2.2. Since 1.3.x, ipnr column is removed. Please restore with your backup which has been created before upgrading to 1.3.x.

Last edited 6 years ago by Jun Omae (previous) (diff)

comment:2 by anonymous, 6 years ago

Thanks Jun, I understand the point.

It is such experimental installation where I play around with different versions and plugins, unfortunately I'm not sure if there're still any backup.

Do you think there could be some specific steps for a rollback procedure? so I can fix the installation by myself

comment:3 by Jun Omae, 6 years ago

Trac upgrade steps create backups for conf/trac.ini and db/trac.db before processing the upgrade. You can use to restore with the files.

$ ~/venv/trac/1.2.2/bin/trac-admin /dev/shm/tracenv-1.2.2 initenv 'My Project' sqlite:db/trac.db
...
$ ~/venv/trac/1.3.2/bin/trac-admin /dev/shm/tracenv-1.2.2 upgrade
Upgrade done.

You may want to upgrade the Trac documentation now by running:

  trac-admin "/dev/shm/tracenv-1.2.2" wiki upgrade
$ ls -l /dev/shm/tracenv-1.2.2/db
total 1064
-rw-r--r-- 1 jun66j5 jun66j5 543744 Nov  1 12:23 sqlite.41.1509506593.bak  # <== created by upgrade/db41.py
-rw-r--r-- 1 jun66j5 jun66j5 544768 Nov  1 12:23 trac.db
$ ls -l /dev/shm/tracenv-1.2.2/conf
total 24
-rw------- 1 jun66j5 jun66j5 6104 Nov  1 12:23 trac.ini
-rw-r--r-- 1 jun66j5 jun66j5 6085 Nov  1 12:23 trac.ini.db43.bak  # <== created by upgrade/db43.py
-rw-r--r-- 1 jun66j5 jun66j5 5563 Nov  1 12:23 trac.ini.sample

Modify Ticket

Change Properties
Set your email in Preferences
Action
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.