Modify

Opened 9 years ago

Closed 9 years ago

#402 closed defect (invalid)

no such column: forum.id

Reported by: mike@… 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 9 years ago by coderanger

  • Description modified (diff)

Fix formatting on traceback

comment:2 Changed 9 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 9 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 9 years ago by Blackhex

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

comment:5 Changed 9 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: 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 9 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 9 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 9 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 9 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.