Modify

Opened 11 years ago

Closed 11 years ago

#515 closed defect (fixed)

Discussion add-in do not work - Database Error

Reported by: franck.boisson@… Owned by: Radek Bartoň
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 11 years ago by Radek Bartoň

Status: newassigned

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 11 years ago by franck.boisson@…

Resolution: fixed
Status: assignedclosed

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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Radek Bartoň.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.