Opened 12 years ago

Closed 12 years ago

#402 closed defect (invalid)

no such column:

Reported by: Mike Owned by: Radek Bartoň
Priority: high Component: DiscussionPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.9

Description (last modified by Noah Kantrowitz)

I finally got the plugin installled and ran the upgrade to the database which it said ran successfully, and now I'm getting a "no such column:" error.

The traceback is as follows (typed in by hand):

Traceback (most recent call last):
  File "E:\Python23\Lib\site-packages\trac\web\", line 131, in run dispatch_request(req.path_info, req, env)
  File "E:\Python23\Lib\site-packages\trac\web\", line 139, in dispatch_request dispatcher.dispatch(req)
  File "E:\Python23\Lib\site-packages\trac\web\", line 107, in dispatch resp = chosen_handler.process_request(req)
  File "build\bdist.win32\egg\tracdiscussion\", line 147, in process_request
  File "build\bdist.win32\egg\tracdiscussion\", line 305, in get_forums
  File "E:\Python23\Lib\site-packages\sqlite\", line 244, in execute = self.con.db.execute(SQL)
DatabaseError: no such column:

Any suggestions?

Attachments (0)

Change History (9)

comment:1 Changed 12 years ago by Noah Kantrowitz

Description: modified (diff)

Fix formatting on traceback

comment:2 Changed 12 years ago by Radek Bartoň

Status: newassigned

Check if forum table exists, if don't try to clear all DiscussionPlugin database entries (if you know how) and run trac-admin upgrade again. Maybe error in updating existing db shema. This part is not well-coded yet. New installation should be clear.

comment:3 Changed 12 years ago by anonymous

I have tried to get access to the trac.db database through SQLite with no success. It tells me that the trac.db is either encrypted or not a database. I know that is not a DiscussionPlugin issue specifically, but maybe you can help shed some light on the subject. I am using Trac 0.9.3 with Python 2.3 on a Windows 2000 Server. The SQLite version is 2.8.16. Trac and Subversion are being served by Apache 2.0.54.

comment:4 Changed 12 years ago by Radek Bartoň

I had this issue some time ago too. See

comment:5 Changed 12 years ago by Mike

The only time I get the “file is encrypted or is not a database” error is when I try to access the DB from the DOS command prompt with the sqlite.exe program. Otherwise DB access seems to be fine through Trac except for the "no such column:" error for this plugin. If I understand the TracUpgrade page correctly, I need to upgrade from SQLite 2.8.x to 3.x if I have upgraded from Trac 0.8.x to 0.9.x. Is that right?

comment:6 Changed 12 years ago by Radek Bartoň

Yes it is. Perhaps your sqlite.exe is version 2 and your database is version 3.

comment:7 Changed 12 years ago by Radek Bartoň

Could you please evoke this error with 836 and post cut from debug log?

comment:8 in reply to:  7 Changed 12 years ago by Mike

Replying to Blackhex:

Could you please evoke this error with 836 and post cut from debug log?

I was able to fix the problem by upgrading to sqlite3.exe and pysqlite-2.2.2 for Windows. Once I did those two things, I was able to access the database correctly and the plugin started working.

comment:9 Changed 12 years ago by Radek Bartoň

Resolution: invalid
Status: assignedclosed

So that means that it's invalid.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Radek Bartoň.
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.