First time here? Check out the FAQ!

running test error


Postgres 9.3.

When i try to run python test, I got the following error: Could somebody help me? Thanks.

Creating test database for alias 'default'...
Traceback (most recent call last):
  File "", line 11, in <module>
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/core/management/", line 459, in execute_manager
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/core/management/", line 382, in execute
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/core/management/commands/", line 49, in run_from_argv
    super(Command, self).run_from_argv(argv)
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/core/management/", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/core/management/", line 232, in execute
    output = self.handle(*args, **options)
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/South-0.8.4-py2.6.egg/south/management/commands/", line 8, in handle
    super(Command, self).handle(*args, **kwargs)
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/core/management/commands/", line 72, in handle
    failures = test_runner.run_tests(test_labels)
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/test/", line 381, in run_tests
    old_config = self.setup_databases()
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/test/", line 317, in setup_databases
    self.verbosity, autoclobber=not self.interactive)
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/db/backends/", line 256, in create_test_db
    self._create_test_db(verbosity, autoclobber)
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/db/backends/", line 312, in _create_test_db
    suffix = self.sql_table_creation_suffix()
  File "/home/ec2-user/teachqa/lib/python2.6/site-packages/django/db/backends/postgresql_psycopg2/", line 38, in sql_table_creation_suffix
    assert self.connection.settings_dict['TEST_COLLATION'] is None, "PostgreSQL does not support collation setting at database creation time."
AssertionError: PostgreSQL does not support collation setting at database creation time.
Lidya's avatar
asked 2014-04-07 21:56:01 -0500
Evgeny's avatar
updated 2014-04-07 22:08:42 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


Try commenting out the TEST_COLLATION line in the

Also, it might help to specify the apps to run the tests for, otherwise you'll be running all the django test cases and all other apps.

Evgeny's avatar
answered 2014-04-07 22:09:26 -0500, updated 2014-04-07 22:10:25 -0500
edit flag offensive 0 remove flag delete link


Hello, It works Thx! You are so helpful. Further to that, running the test askbot, there is 1 failure at: FAIL: test_thread_summary_locmem_cache (askbot.tests.post_model_tests.ThreadRenderLowLevelCachingTests) Traceback (most recent call last): File "/home/ec2-user/teachqasite/askbot/tests/", line 370, in test_thread_summary_locmem_cache self.assertTrue(thread.summary_html_cached()) AssertionError: False is not True --- I setup and used memchaced. was that test above for the locmem cache? If so, should i just ignore it since i use memcached? #setup memcached for production use! #see for details #CACHE_BACKEND = 'locmem://' #CACHE_BACKEND = 'memcached://' CACHES = { 'default': { 'BACKEND': 'django.core.cache.backends.memcached.MemcachedCache', 'LOCATION': '', 'TIMEOUT': 18000, 'KEY_PREFIX': 'askbot', } } Thanks again in advance!

Lidya's avatar Lidya (2014-04-07 22:33:39 -0500) edit
add a comment see more comments