Revision history  [back]

Edit 2 (After Update to 0.7.46):

I still get Error emails everytime a user searches on my askbot

I get the following by using the command: python manage.py migrate

Running migrations for longerusername:
- Nothing to migrate.
 - Loading initial data for longerusername.
No fixtures found.
Running migrations for django_authopenid:
- Nothing to migrate.
 - Loading initial data for django_authopenid.
No fixtures found.
Running migrations for askbot:
 - Migrating forwards to 0158_add_title_search_indices_for_postgresql_and_mysql.
 > askbot:0158_add_title_search_indices_for_postgresql_and_mysql
Error in migration: askbot:0158_add_title_search_indices_for_postgresql_and_mysq
l
Traceback (most recent call last):
  File "manage.py", line 11, in <module>
    execute_manager(settings)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/Django-1.3
.1-py2.7.egg/django/core/management/__init__.py", line 438, in execute_manager
    utility.execute()
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/Django-1.3
.1-py2.7.egg/django/core/management/__init__.py", line 379, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/Django-1.3
.1-py2.7.egg/django/core/management/base.py", line 191, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/Django-1.3
.1-py2.7.egg/django/core/management/base.py", line 220, in execute
    output = self.handle(*args, **options)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/management/commands/migrate.py", line 108, in handle
    ignore_ghosts = ignore_ghosts,
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/migration/__init__.py", line 213, in migrate_app
    success = migrator.migrate_many(target, workplan, database)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/migration/migrators.py", line 235, in migrate_many
    result = migrator.__class__.migrate_many(migrator, target, migrations, datab
ase)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/migration/migrators.py", line 310, in migrate_many
    result = self.migrate(migration, database)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/migration/migrators.py", line 133, in migrate
    result = self.run(migration)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/migration/migrators.py", line 107, in run
    return self.run_migration(migration)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/migration/migrators.py", line 81, in run_migration
    migration_function()
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/migration/migrators.py", line 57, in <lambda>
    return (lambda: direction(orm))
  File "/srv/themegasupersite.com/node1/askbot/migrations/0158_add_title_search_indices_
for_postgresql_and_mysql.py", line 33, in forwards
    postgresql.setup_full_text_search(script_path)
  File "/srv/themegasupersite.com/node1/askbot/search/postgresql/__init__.py", line 19,
in setup_full_text_search
    cursor.execute(fts_init_query)
  File "/srv/themegasupersite.com/node1/env/local/lib/python2.7/site-packages/Django-1.3
.1-py2.7.egg/django/db/backends/postgresql_psycopg2/base.py", line 44, in execut
e
    return self.cursor.execute(query, args)
django.db.utils.DatabaseError: cannot ALTER TABLE "askbot_thread" because it has
 pending trigger events
CONTEXT:  SQL statement "ALTER TABLE askbot_thread ADD COLUMN title_search_vecto
r tsvector"
PL/pgSQL function "add_tsvector_column" line 7 at EXECUTE statement

EDIT:

I get the following by using the command: python manage.py migrate But I don't really know what that means

No fixtures found.
Running migrations for django_authopenid:
- Nothing to migrate.
 - Loading initial data for django_authopenid.
No fixtures found.
Running migrations for askbot:
 ! Migration askbot:0157_auto__del_field_anonymousquestion_summary__del_field_an
onymousanswer_s should not have been applied before askbot:0157_add_title_search
_indices_for_postgresql_and_mysql but was.
Traceback (most recent call last):
  File "manage.py", line 11, in <module>
    execute_manager(settings)
  File "/srv/themegasupersite.come/node1/env/local/lib/python2.7/site-packages/Django-1.3
.1-py2.7.egg/django/core/management/__init__.py", line 438, in execute_manager
    utility.execute()
  File "/srv/themegasupersite.come/node1/env/local/lib/python2.7/site-packages/Django-1.3
.1-py2.7.egg/django/core/management/__init__.py", line 379, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/srv/themegasupersite.come/node1/env/local/lib/python2.7/site-packages/Django-1.3
.1-py2.7.egg/django/core/management/base.py", line 191, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/srv/themegasupersite.come/node1/env/local/lib/python2.7/site-packages/Django-1.3
.1-py2.7.egg/django/core/management/base.py", line 220, in execute
    output = self.handle(*args, **options)
  File "/srv/themegasupersite.come/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/management/commands/migrate.py", line 108, in handle
    ignore_ghosts = ignore_ghosts,
  File "/srv/themegasupersite.come/node1/env/local/lib/python2.7/site-packages/South-0.7.
6-py2.7.egg/south/migration/__init__.py", line 207, in migrate_app
    raise exceptions.InconsistentMigrationHistory(problems)
south.exceptions.InconsistentMigrationHistory: Inconsistent migration history
The following options are available:
    --merge: will just attempt the migration ignoring any potential dependency c
onflicts.

...

Traceback (most recent call last):

  File "/srv/themegasupersite.com/node1/env/lib/python2.7/site-packages/Django-1.3.1-py2.7.egg/django/core/handlers/base.py", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)

  File "/srv/themegasupersite.com/node1/askbot/utils/decorators.py", line 65, in wrapper
    return view_func(request, *args, **kwargs)

  File "/srv/themegasupersite.com/node1/askbot/views/commands.py", line 718, in title_search
    for thread in threads:#todo: this is a temp hack until thread model is fixed

  File "/srv/themegasupersite.com/node1/env/lib/python2.7/site-packages/Django-1.3.1-py2.7.egg/django/db/models/query.py", line 107, in _result_iter
    self._fill_cache()

  File "/srv/themegasupersite.com/node1/env/lib/python2.7/site-packages/Django-1.3.1-py2.7.egg/django/db/models/query.py", line 772, in _fill_cache
    self._result_cache.append(self._iter.next())

  File "/srv/themegasupersite.com/node1/env/lib/python2.7/site-packages/Django-1.3.1-py2.7.egg/django/db/models/query.py", line 273, in iterator
    for row in compiler.results_iter():

  File "/srv/themegasupersite.com/node1/env/lib/python2.7/site-packages/Django-1.3.1-py2.7.egg/django/db/models/sql/compiler.py", line 680, in results_iter
    for rows in self.execute_sql(MULTI):

  File "/srv/themegasupersite.com/node1/env/lib/python2.7/site-packages/Django-1.3.1-py2.7.egg/django/db/models/sql/compiler.py", line 735, in execute_sql
    cursor.execute(sql, params)

  File "/srv/themegasupersite.com/node1/env/lib/python2.7/site-packages/Django-1.3.1-py2.7.egg/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute
     return self.cursor.execute(query, args)
 
args)

DatabaseError: column askbot_thread.title_search_vector does not exist
LINE 1: SELECT DISTINCT (ts_rank(askbot_thread.title_search_vector, ...
                                 ^
 <WSGIRequest
GET:<QueryDict: {u'query_text': [u'question'], u'_': [u'1355356141482']}>,
POST:<QueryDict: {}>,
COOKIES:{'__utma': '268136331.1476228459.1353848276.1355350963.1355353120.122',
 '__utmb': '268136331.16.10.1355353120',
 
Bug?