Opened 6 years ago

Closed 5 years 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


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

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\", line 497, in _dispatch_request
  File "c:\docume~1\admini~1\locals~1\temp\easy_install-qrpgjw\Trac-1.0-py2.7-win32.egg.tmp\trac\web\", 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\", line 125, in process_request
  File "build\bdist.win32\egg\simplemultiproject\", line 69, in render_admin_panel
    projects_rows  = self.__SmpModel.get_all_projects()
  File "build\bdist.win32\egg\simplemultiproject\", line 84, in get_all_projects
  File "c:\docume~1\admini~1\locals~1\temp\easy_install-qrpgjw\Trac-1.0-py2.7-win32.egg.tmp\trac\db\", 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\", 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\", 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\", 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 5 years ago by falkb

Owner: changed from Christopher Paredes to falkb
Severity: normalcritical
Status: newassigned

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 5 years ago by falkb

Resolution: worksforme
Status: assignedclosed


Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain falkb.
The resolution will be deleted.

Add Comment

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

Note: See TracTickets for help on using tickets.