Modify

Opened 3 years ago

Closed 3 years 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/main.py", line 639, in dispatch_request          
  dispatcher.dispatch(req)
File "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/web/main.py", line 250, in dispatch          
  resp = chosen_handler.process_request(req)
File "/mnt/data/trac/virtualenv/lib/python2.7/site-packages/trac/admin/web_ui.py", 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/admin_project.py", 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/smp_model.py", 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/postgres_backend.py", 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/util.py", 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+https://trac-hacks.org/svn/simplemultiprojectplugin/trunk and have done an trac-admin upgrade afterwards.

Attachments (1)

t13935.diff (2.9 KB) - added by Ryan J Ollos 3 years ago.

Download all attachments as: .zip

Change History (5)

comment:1 Changed 3 years ago by Massimo

Description: modified (diff)

comment:2 Changed 3 years ago by Cinc-th

See related mailing list thread.

Changed 3 years ago by Ryan J Ollos

Attachment: t13935.diff added

comment:3 Changed 3 years ago by Ryan J Ollos

Untested patch, based on mailing list discussion.

comment:4 Changed 3 years 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
Action
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.