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

[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.

[Cinc-th]

See related ​mailing list thread.

[Ryan J Ollos]

Untested patch, based on mailing list discussion.

[Cinc-th]

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