First time here? Check out the FAQ!
0

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

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)

gorge's avatar
21
gorge
asked 2013-03-21 03:07:14 -0500
Evgeny's avatar
13.2k
Evgeny
updated 2013-03-21 23:50:00 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

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.

Evgeny's avatar
13.2k
Evgeny
answered 2013-03-21 23:48:50 -0500, updated 2013-03-21 23:51:10 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments