Ticket #402 (closed defect: invalid)

Opened 7 years ago

Last modified 7 years ago

no such column: forum.id

Reported by: mike@trimbles.net Assigned to: 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

Change History

05/31/06 19:51:11 changed by coderanger

  • description changed.

Fix formatting on traceback

06/02/06 13:41:19 changed 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.

06/02/06 15:28:19 changed 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.

06/02/06 15:33:17 changed by Blackhex

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

06/02/06 15:53:28 changed by mike@trimbles.net

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?

06/02/06 15:59:51 changed by Blackhex

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

(follow-up: ↓ 8 ) 06/08/06 18:09:54 changed by Blackhex

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

(in reply to: ↑ 7 ) 06/09/06 15:24:38 changed 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.

06/11/06 12:20:13 changed by Blackhex

  • status changed from assigned to closed.
  • resolution set to invalid.

So that means that it's invalid.

Add/Change #402 (no such column: forum.id)




Change Properties
Action