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

[emecas]

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
                                                                   ^

[Jun Omae]

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.

[anonymous]

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

[Jun Omae]

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