Modify

Opened 11 years ago

Closed 11 years ago

#402 closed defect (invalid)

no such column: forum.id

Reported by: trimblmc Owned by: Blackhex
Priority: high Component: DiscussionPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.9

Description (last modified by coderanger)

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: forum.id" error.

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

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

Any suggestions?

Attachments (0)

Change History (9)

comment:1 Changed 11 years ago by coderanger

  • Description modified (diff)

Fix formatting on traceback

comment:2 Changed 11 years ago by Blackhex

  • Status changed from new to assigned

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 11 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 11 years ago by Blackhex

I had this issue some time ago too. See http://projects.edgewall.com/trac/wiki/TracUpgrade.

comment:5 Changed 11 years ago by trimblmc

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: forum.id" 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 11 years ago by Blackhex

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

comment:7 follow-up: Changed 11 years ago by Blackhex

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

comment:8 in reply to: ↑ 7 Changed 11 years ago by trimblmc

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 11 years ago by Blackhex

  • Resolution set to invalid
  • Status changed from assigned to closed

So that means that it's invalid.

Add Comment

Modify Ticket

Action
as closed The owner will remain Blackhex.
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.