Modify

Opened 2 years ago

Closed 18 months ago

#10615 closed defect (worksforme)

OperationalError: no such table: smp_project

Reported by: chengang Owned by: falkb
Priority: normal Component: SimpleMultiProjectPlugin
Severity: critical Keywords: smp_project
Cc: Trac Release: 1.0

Description

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

Attachments (0)

Change History (2)

comment:1 Changed 23 months ago by falkb

  • Owner changed from crossroad to falkb
  • Severity changed from normal to critical
  • Status changed from new to assigned

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.

comment:2 Changed 18 months ago by falkb

  • Resolution set to worksforme
  • Status changed from assigned to closed

timeout

Add Comment

Modify Ticket

Action
as closed The owner will remain falkb.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.