OperationalError: no such table: smp_project

[chengang]

How to Reproduce

While doing a GET operation on /admin/projects/simplemultiproject, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'cat_id': u'projects', 'panel_id': u'simplemultiproject', 'path_info': None}

User agent: Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.12 (KHTML, like Gecko) Maxthon/3.0 Chrome/18.0.966.0 Safari/535.12

System Information

Trac	1.0
Trac	1.0
Babel	0.9.5
CustomFieldAdmin	0.2.6
Genshi	0.6 (without speedups)
mod_wsgi	3.3 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})
Pygments	1.5
pysqlite	2.6.0
Python	2.7.1 (r271:86832, Nov 27 2010, 18:30:46) [MSC v.1500 32 bit (Intel)]
Python	2.7.1 (r271:86832, Nov 27 2010, 18:30:46) [MSC v.1500 32 bit (Intel)]
pytz	2012h
pytz	2012h
setuptools	0.6c11
setuptools	0.6c11
SQLite	3.6.21
Subversion	1.6.15 (r1038135)
jQuery	1.7.2

Enabled Plugins

advancedticketworkflowplugin	0.11dev
backlinksmacro	7.0dev
changelogmacro	0.2
Color	Rev
graphviz	0.6.11dev
gridmodify	0.1.6dev
groupticketfields	0.0.1dev
iniadmin	0.3
moviemacro	0.2dev
navadd	0.1
navigation-plugin	0.1.0
restrictownertolist	0.1.0
simplemultiproject	0.0.3dev
table-sorter-plugin	1.0
trac-jsgantt	0.10
trac-userpicturesplugin	0.1.1
tracaccountmanager	0.4dev
traccustomfieldadmin	0.2.6
tracdatefield	3.0.0dev
tracganttcalendarplugin	0.6.2-r817
tracincludemacro	3.0.0dev
trackeywordsplugin	0.3dev
trackeywordsuggest	0.5.0dev
tracpermredirect	2.0
tracpoll	0.3.0dev
tracsql	0.3
tracsubcomponents	1.2.0
tracusermanagerplugin	0.5dev
tracwikiextras	0.13.1
tracworkflowadmin	0.12.0.2
tracwysiwyg	0.12.0.4

Python Traceback

Traceback (most recent call last):
  File "c:\docume~1\admini~1\locals~1\temp\easy_install-qrpgjw\Trac-1.0-py2.7-win32.egg.tmp\trac\web\main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "c:\docume~1\admini~1\locals~1\temp\easy_install-qrpgjw\Trac-1.0-py2.7-win32.egg.tmp\trac\web\main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "c:\docume~1\admini~1\locals~1\temp\easy_install-qrpgjw\Trac-1.0-py2.7-win32.egg.tmp\trac\admin\web_ui.py", line 125, in process_request
    path_info)
  File "build\bdist.win32\egg\simplemultiproject\admin.py", line 69, in render_admin_panel
    projects_rows  = self.__SmpModel.get_all_projects()
  File "build\bdist.win32\egg\simplemultiproject\model.py", line 84, in get_all_projects
    cursor.execute(query)
  File "c:\docume~1\admini~1\locals~1\temp\easy_install-qrpgjw\Trac-1.0-py2.7-win32.egg.tmp\trac\db\util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "c:\docume~1\admini~1\locals~1\temp\easy_install-qrpgjw\Trac-1.0-py2.7-win32.egg.tmp\trac\db\sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "c:\docume~1\admini~1\locals~1\temp\easy_install-qrpgjw\Trac-1.0-py2.7-win32.egg.tmp\trac\db\sqlite_backend.py", line 56, in execute
    args or [])
  File "c:\docume~1\admini~1\locals~1\temp\easy_install-qrpgjw\Trac-1.0-py2.7-win32.egg.tmp\trac\db\sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such table: smp_project

[falkb]

That table should automatically be created on first run of the plugin. Strange that it has failed. Could you please edit your trac.db (with e.g. SQLite Database Browser) and remove all tables again where its name starts with smp_ ? Then try again and report back.

[falkb]

timeout