Ask Your Question
0

What may cause error "Table 'forum1.livesettings_setting' doesn't exist"?

asked 2013-03-21 03:07:14 -0500

gorge gravatar image

updated 2013-03-21 23:50:00 -0500

Evgeny gravatar image

I copied the askbot directory into my project root added settings according to directions given by console. but showing errors.

No handlers could be found for logger "keyedcache" WARNING!!! You are using a 'locmem' (local memory) caching backend, which is OK for a low volume site running on a single-process server. For a multi-process configuration it is neccessary to have a production cache system, such as redis or memcached.

With local memory caching and multi-process setup you might intermittently see outdated content on your site.

Traceback (most recent call last): File "/opt/lampp/htdocs/django/newforum/askbot/deps/livesettings/values.py", line 311, in _value val = self.setting.value File "/opt/lampp/htdocs/django/newforum/askbot/deps/livesettings/values.py", line 293, in _setting return find_setting(self.group.key, self.key) File "/opt/lampp/htdocs/django/newforum/askbot/deps/livesettings/models.py", line 48, in find_setting setting = Setting.objects.get(site__id__exact=siteid, key__exact=key, group__exact=group) File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line 131, in get return self.get_query_set().get(args, *kwargs) File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 361, in get num = len(clone) File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 85, in __len__ self._result_cache = list(self.iterator()) File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 291, in iterator for row in compiler.results_iter(): File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 763, in results_iter for rows in self.execute_sql(MULTI): File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 818, in execute_sql cursor.execute(sql, params) File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 40, in execute return self.cursor.execute(sql, params) File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 114, in execute return self.cursor.execute(query, args) File "/usr/local/lib/python2.7/dist-packages/MySQL_python-1.2.4b4-py2.7-linux-i686.egg/MySQLdb/cursors.py", line 202, in execute self.errorhandler(self, exc, value) File "/usr/local/lib/python2.7/dist-packages/MySQL_python-1.2.4b4-py2.7-linux-i686.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue DatabaseError: (1146, "Table 'forum1.livesettings_setting' doesn't exist") ("Startup error, couldn't load EXTERNAL_KEYS.RECAPTCHA_SECRET", None) Traceback (most recent call last): File "/opt/lampp/htdocs/django/newforum/askbot/deps/livesettings/values.py", line 311, in _value val = self.setting.value File "/opt/lampp/htdocs/django/newforum/askbot/deps/livesettings/values.py", line 293, in _setting return find_setting(self.group.key, self.key) File "/opt/lampp/htdocs/django/newforum/askbot/deps/livesettings/models.py", line 48, in find_setting setting = Setting.objects.get(site__id__exact=siteid, key__exact=key, group__exact=group) File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line 131, in get return self.get_query_set().get(args, *kwargs) File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 361, in get num ... (more)

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2013-03-21 23:48:50 -0500

Evgeny gravatar image

updated 2013-03-21 23:51:10 -0500

Table 'forum1.livesettings_setting' doesn't exist". This tells that the database is not properly initialized. Missing tables usually suggest that "syncdb" or "migrate" failed (syncdb in this case.)

This may be happening for a variety of reasons: 1) missing library dependencies; 2) unreachable cache; 3) the database you are using is poorly supported (very possibly - we still have bugs with MySQL, we use and recommend PostgreSQL for the production).

For example you might have configured Askbot to use Redis cache, but redis server is unreachable. In that case you will have errors like "Startup error, couldn't load EXTERNAL_KEYS.RECAPTCHA_SECRET".

Failing cache might cause syncdb to fail.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2013-03-21 03:07:14 -0500

Seen: 635 times

Last updated: Mar 21 '13