Opened 8 months ago

Closed 7 months ago

#13955 closed defect (fixed)

Create new project, undefinedTable: relation "smp_project_id_seq" does not exist

Reported by: Massimo Owned by: Cinc-th
Priority: normal Component: SimpleMultiProjectPlugin
Severity: major Keywords:
Cc: Trac Release: 1.4

Description (last modified by Massimo)

Adding a new project via /admin/projects/projects fails with

UndefinedTable: relation "smp_project_id_seq" does not exist
LINE 1: SELECT CURRVAL('"smp_project_id_seq"')
File "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/web/", line 639, in dispatch_request          
File "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/web/", line 250, in dispatch          
  resp = chosen_handler.process_request(req)
File "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/admin/", line 104, in process_request          
  resp = provider.render_admin_panel(req, cat_id, panel_id, path_info)
File "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/simplemultiproject/", line 85, in render_admin_panel          
  self.smp_project.add(name, summary, description, None, 'YES' if restricted else None)
File "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/simplemultiproject/", line 213, in add          
  prj_id = db.get_last_id(cursor, 'smp_project')
File "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/db/", line 372, in get_last_id          
  (self.quote(self._sequence_name(table, column)),))
File "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/db/", line 73, in execute          
  return self.cursor.execute(sql_escape_percent(sql), args)

We have installed TracSimpleMultiProject-0.7.2.dev0 via pip from svn+ and have done an trac-admin upgrade afterwards.

Attachments (1)

t13935.diff (2.9 KB) - added by Ryan J Ollos 7 months ago.

Download all attachments as: .zip

Change History (5)

comment:1 Changed 8 months ago by Massimo

Description: modified (diff)

comment:2 Changed 8 months ago by Cinc-th

See related mailing list thread.

Changed 7 months ago by Ryan J Ollos

Attachment: t13935.diff added

comment:3 Changed 7 months ago by Ryan J Ollos

Untested patch, based on mailing list discussion.

comment:4 Changed 7 months ago by Cinc-th

Resolution: fixed
Status: newclosed

In 18092:

SimpleMultiProjectPlugin: fix for error with postgres when trying to get the id of the last created project from the database right after insertion of the record.

Closes #13955

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Cinc-th.
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.