Opened 18 years ago
Closed 18 years ago
#402 closed defect (invalid)
no such column: forum.id
Reported by: | Mike | Owned by: | Radek Bartoň |
---|---|---|---|
Priority: | high | Component: | DiscussionPlugin |
Severity: | blocker | Keywords: | |
Cc: | Trac Release: | 0.9 |
Description (last modified by )
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 18 years ago by
Description: | modified (diff) |
---|
comment:2 Changed 18 years ago by
Status: | new → 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 18 years ago by
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 18 years ago by
I had this issue some time ago too. See http://projects.edgewall.com/trac/wiki/TracUpgrade.
comment:5 Changed 18 years ago by
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 18 years ago by
Yes it is. Perhaps your sqlite.exe is version 2 and your database is version 3.
comment:7 follow-up: 8 Changed 18 years ago by
Could you please evoke this error with 836 and post cut from debug log?
comment:8 Changed 18 years ago by
comment:9 Changed 18 years ago by
Resolution: | → invalid |
---|---|
Status: | assigned → closed |
So that means that it's invalid.
Fix formatting on traceback