can not migrate askbot please help

asked 2012-04-09 04:07:02 -0500

Pramvir
199 ● 10 ● 2 ● 11

updated 2012-04-09 04:14:36 -0500

when i am trying to migrate askbot this error happens

[pramvir@web322 forum]$ python manage.py migrate askbot

/home/pramvir/webapps/0to9to0/lib/python2.6/django/db/__init__.py:19: DeprecationWarning: settings.DATABASE_* is deprecated; use settings.DATABASES instead. DeprecationWarning /home/pramvir/webapps/0to9to0/lib/python2.6/django/db/__init__.py:60: DeprecationWarning: Short names for ENGINE in database configurations are deprecated. Prepend default.ENGINE with 'django.db.backends.' DeprecationWarning Running migrations for askbot: - Migrating forwards to 0113_auto__add_field_thread_added_at__add_field_thread_score__add_field_rep.

askbot:0032_auto__del_field_badgedata_multiple__del_field_badgedata_description__d ! Error found during real run of migration! Aborting.

! Since you have a database that does not support running ! schema-altering statements in transactions, we have had ! to leave it in an interim state between migrations.

! You might be able to recover with: = ALTER TABLE askbot_badgedata ADD COLUMN multiple bool NOT NULL DEFAULT False; [] - no dry run output for alter_column() due to dynamic DDL, sorry = ALTER TABLE askbot_badgedata ADD COLUMN description varchar(300) NOT NULL DEFAULT ''; [] - no dry run output for alter_column() due to dynamic DDL, sorry = ALTER TABLE askbot_badgedata ADD COLUMN type smallint NOT NULL DEFAULT 3; [] - no dry run output for alter_column() due to dynamic DDL, sorry = ALTER TABLE askbot_badgedata ADD COLUMN name varchar(50) NOT NULL DEFAULT ''; [] - no dry run output for alter_column() due to dynamic DDL, sorry - no dry run output for alter_column() due to dynamic DDL, sorry - no dry run output for delete_unique_column() due to dynamic DDL, sorry

! The South developers regret this has happened, and would ! like to gently persuade you to consider a slightly ! easier-to-deal-with DBMS (one that supports DDL transactions) ! NOTE: The error which caused the migration to fail is further up. Error in migration: askbot:0032_auto__del_field_badgedata_multiple__del_field_badgedata_description__d Traceback (most recent call last): File "manage.py", line 11, in <module> execute_manager(settings) File "/home/pramvir/webapps/0to9to0/lib/python2.6/django/core/management/__init__.py", line 438, in execute_manager utility.execute() File "/home/pramvir/webapps/0to9to0/lib/python2.6/django/core/management/__init__.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/home/pramvir/webapps/0to9to0/lib/python2.6/django/core/management/base.py", line 191, in run_from_argv self.execute(args, *options.__dict__) File "/home/pramvir/webapps/0to9to0/lib/python2.6/django/core/management/base.py", line 220, in execute output = self.handle(args, *options) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/management/commands/migrate.py", line 107, in handle ignore_ghosts = ignore_ghosts, File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/migration/__init__.py", line 219, in migrate_app success = migrator.migrate_many(target, workplan, database) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/migration/migrators.py", line 235, in migrate_many result = migrator.__class__.migrate_many(migrator, target, migrations, database) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/migration/migrators.py", line 310, in migrate_many result = self.migrate(migration, database) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/migration/migrators.py", line 133, in migrate result = self.run(migration) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/migration/migrators.py", line 107, in run return self.run_migration(migration) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/migration/migrators.py", line 81, in run_migration migration_function() File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/migration/migrators.py", line 57, in <lambda> return (lambda: direction(orm)) File "/home/pramvir/lib/python2.6/askbot-0.7.40-py2.6.egg/askbot/migrations/0032_auto__del_field_badgedata_multiple__del_field_badgedata_description__d.py", line 15, in forwards db.delete_column('askbot_badgedata', 'multiple') File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/db/mysql.py", line 30, in _column_rm return func(self, table_name, column_name, args, *opts) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/db/mysql.py", line 216, in delete_column super(DatabaseOperations, self).delete_column(table_name, name) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/db/generic.py", line 52, in _column_rm return func(self, table, column, args, *opts) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/db/generic.py", line 887, in delete_column self.execute(self.delete_column_string % params, []) File "/home/pramvir/lib/python2.6/South-0.7.4-py2.6.egg/south/db/generic.py", line 264, in execute cursor.execute(sql, params) File "/home/pramvir/webapps/0to9to0/lib/python2.6/django/db/backends/util.py", line 34, in execute return self.cursor.execute(sql, params) File "/home/pramvir/webapps/0to9to0/lib/python2.6/django/db/backends/mysql/base.py", line 86, in execute return self.cursor.execute(query, args) File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (1091, "Can't DROP 'multiple'; check that column/key exists") [pramvir@web322 forum]$