Modify

Opened 8 years ago

Closed 8 years ago

#515 closed defect (fixed)

Discussion add-in do not work - Database Error

Reported by: franck.boisson@… Owned by: Blackhex
Priority: high Component: DiscussionPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.9

Description

I have instaled and enabled the Discussion plugin (fllowing ALL instructions) and now, when I try to access it, I have an error :

"Trac detected an internal error: no such column: forum_group.id"

My logs are:
{{{13:03:07 Trac[api] DEBUG: SELECT id, name, description, (SELECT COUNT(id) FROM forum f WHERE f.forum_group = forum_group.id) FROM forum_group
13:03:07 Trac[main] ERROR: no such column: forum_group.id
Traceback (most recent call last): File "C:\Program Files\Python23\Lib\site-packages\trac\web\standalone.py", line 303, in _do_trac_req dispatch_request(path_info, req, env)
File "C:\Program Files\Python23\Lib\site-packages\trac\web\main.py", line 139, in dispatch_request dispatcher.dispatch(req)
File "C:\Program Files\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 158, in process_request
File "build\bdist.win32\egg\tracdiscussion\api.py", line 125, in get_groups
File "C:\PROGRA~1\Python23\Lib\site-packages\sqlite\main.py", line 244, in execute self.rs = self.con.db.execute(SQL)
DatabaseError: no such column: forum_group.id}}}

Notice that I use a SQLite database and when I edit it with an explorer, I have all Discussion tables available and I can execute the last query printed on the log.

Attachments (0)

Change History (2)

comment:1 Changed 8 years ago by Blackhex

  • Status changed from new to assigned

I checked code and there is nothing obviously wrong. Looks like there was some unexpected error when creating forum_group table during environment upgrade. Please try remove all discussion plugin tables (forum_group, forum, topic, message) and delete discussion_version line from system table. Then upgrade environment again. If error occurs again, please post me part of output of command .schema (in sqlite command prompt) about mentioned tables. You can post info about sqlite and trac version too.

comment:2 Changed 8 years ago by franck.boisson@…

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

After having check various plugins versions, it appears that my pysql component was not the latest one... I have Upgraded it and it works now fine.

Thanks for your help.

Add Comment

Modify Ticket

Action
as closed .
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.