Discussion add-in do not work - Database Error

[franck.boisson@…]

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.

[Radek Bartoň]

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.

[franck.boisson@…]

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.