ProgrammingError: (1146, "Table 'trac.fullblog_posts' doesn't exist")

[yxd]

How to Reproduce

While doing a GET operation on /blog, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'blog_path': ''}

User agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.82 Safari/537.36

System Information

Trac	0.12.5
Babel	0.9.6
Docutils	0.11
FullBlog	0.1.5
Genshi	0.6.1 (without speedups)
GIT	1.9.1
MySQL	server: "5.5.53-0ubuntu0.14.04.1", client: "5.5.53", thread-safe: 1
MySQLdb	1.2.3
Pygments	1.6
Python	2.7.6 (default, Jun 22 2015, 17:58:13) [GCC 4.8.2]
pytz	2012c
setuptools	3.3
Subversion	1.8.8 (r1568071)
jQuery	1.4.4

Enabled Plugins

TracAccountManager	0.4.3
TracFullBlogPlugin	0.1.5
TracGit	0.12.0.5dev

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 522, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 243, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.7/dist-packages/TracFullBlogPlugin-0.1.5-py2.7.egg/tracfullblog/web_ui.py", line 125, in process_request
    data['blog_about'] = BlogPost(self.env, 'about')
  File "/usr/local/lib/python2.7/dist-packages/TracFullBlogPlugin-0.1.5-py2.7.egg/tracfullblog/model.py", line 418, in __init__
    self._load_post(version)
  File "/usr/local/lib/python2.7/dist-packages/TracFullBlogPlugin-0.1.5-py2.7.egg/tracfullblog/model.py", line 574, in _load_post
    fields = self._fetch_fields(version)
  File "/usr/local/lib/python2.7/dist-packages/TracFullBlogPlugin-0.1.5-py2.7.egg/tracfullblog/model.py", line 539, in _fetch_fields
    self.versions = self.get_versions()
  File "/usr/local/lib/python2.7/dist-packages/TracFullBlogPlugin-0.1.5-py2.7.egg/tracfullblog/model.py", line 519, in get_versions
    cursor.execute(sql, args)
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'trac.fullblog_posts' doesn't exist")

[Ryan J Ollos]

This appears to be an ​InstallationIssue.

Did you just recently install the plugin? Does the table fullblog_comments exist?

You could delete fullblog_comments, if existing, and also fullblog_version from the system table, and you'll be prompted to upgrade the environment again. The tables should be created on environment upgrade.