OperationalError: no such table: wikisync

[Franz]

When installing TracWikiSyncPlugin and clicking on Tab "Wiki Sync" it throws error OperationalError: no such table: wikisync (see full stacktrace below).

My environment is: Python 2.7, Windows 7, SQLite

Workaround / Fix

When I change following lines, the plugin could create the necessary table:

C:/Projekte/Trac/TracWikiSync/wikisync/

@@ -81 +81 @@
     
     implements(IEnvironmentSetupParticipant, IWikiChangeListener)
     
-    # Component cannot be turn off
-    required = True
-    
     # IEnvironmentSetupParticipant
     def environment_created(self):
         pass

Full Stacktrace

2015-09-14 09:51:44,948 Trac[main] ERROR: Internal Server Error: 
Traceback (most recent call last):
  File "C:\Projekte\Trac\TracCore\trac\web\main.py", line 587, in _dispatch_request
    dispatcher.dispatch(req)
  File "C:\Projekte\Trac\TracCore\trac\web\main.py", line 246, in dispatch
    resp = chosen_handler.process_request(req)
  File "build\bdist.win32\egg\wikisync\plugin.py", line 301, in process_request
    return self._process_main(req)
  File "build\bdist.win32\egg\wikisync\plugin.py", line 307, in _process_main
    "collection": [o for o in dao.all()],
  File "build\bdist.win32\egg\wikisync\model.py", line 119, in all
    cursor.execute(sql)
  File "C:\Projekte\Trac\TracCore\trac\db\util.py", line 73, in execute
    return self.cursor.execute(sql)
  File "C:\Projekte\Trac\TracCore\trac\db\sqlite_backend.py", line 87, in execute
    result = PyFormatCursor.execute(self, *args)
  File "C:\Projekte\Trac\TracCore\trac\db\sqlite_backend.py", line 63, in execute
    args or [])
  File "C:\Projekte\Trac\TracCore\trac\db\sqlite_backend.py", line 54, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such table: wikisync

[Franz]

I forgot: my Trac version is 1.1.6

[Jun Omae]

Please report bugs on ​https://github.com/ivanchoo/TracWikiSync/issues. See TracWikiSyncPlugin#BugsFeatureRequests.

[Franz]

Replying to jun66j5:

Please report bugs on ​https://github.com/ivanchoo/TracWikiSync/issues. See TracWikiSyncPlugin#BugsFeatureRequests.

I know this project is hosted at GitHub, but I don't have an GitHub account. Furthermore Ryan questioned ivanchoo a few months ago, if he/she wants to move to trac-hacks, see ​https://github.com/ivanchoo/TracWikiSync/issues/4.

[Jun Omae]

Replying to framay:

I know this project is hosted at GitHub, but I don't have an GitHub account. Furthermore Ryan questioned ivanchoo a few months ago, if he/she wants to move to trac-hacks, see ​https://github.com/ivanchoo/TracWikiSync/issues/4.

It seems that Ryan asked about joining the trac-hacks organization on GitHub, not trac-hacks (here).

Anyway, I think TracWikiSyncPlugin's issues should be reported on github after creating an account since the author says please use github in the TracWikiSyncPlugin page.

[Ryan J Ollos]

If you really want to get this fixed it might be worthwhile to contact the plugin author by email. We can fork the plugin to the trac-hacks organization on GitHub, but I like to exhaust efforts in contacting the author before doing that.