WebFaction
Community site: login faq

when i am trying to migrate askbot this error happens please help

[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_autoadd_field_thread_added_atadd_field_thread_score__add_field_rep.

askbot:0032_autodel_field_badgedata_multipledel_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_autodel_field_badgedata_multipledel_field_badgedata_descriptiond 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_autodel_field_badgedata_multipledel_field_badgedata_descriptiond.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]$

asked 09 Apr '12, 04:08

Pramvir Rath...
721117
accept rate: 0%

see full commands i run

Using username "pramvir". pramvir@pramvir.webfactional.com's password: Last login: Mon Apr 9 03:57:15 2012 from 42.108.188.226 [pramvir@web322 ~]$ cd ~/webapps/0to9to0/forum [pramvir@web322 forum]$ python manage.py syncdb /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 Syncing... Creating tables ... Installing custom SQL ... Installing indexes ... No fixtures found.

Synced:

django.contrib.auth django.contrib.contenttypes django.contrib.sessions django.contrib.sites django.contrib.staticfiles django.contrib.admin django.contrib.sitemaps south askbot.deps.livesettings keyedcache robots django_countries djcelery djkombu followit

Not synced (use migrations): - askbot.deps.django_authopenid - askbot (use ./manage.py migrate to migrate these) [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_autoadd_field_thread_added_atadd_field_thread_score__add_field_rep.

askbot:0032_autodel_field_badgedata_multipledel_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_autodel_field_badgedata_multipledel_field_badgedata_descriptiond 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_autodel_field_badgedata_multipledel_field_badgedata_descriptiond.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]$ ^C [pramvir@web322 forum]$

(09 Apr '12, 04:12) Pramvir Rath...

Hi,

Please submit a support ticket, so we can take a look at your configuration and try to help you fix it.

permanent link

answered 09 Apr '12, 04:46

todork
1.2k5
accept rate: 34%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×17

question asked: 09 Apr '12, 04:08

question was seen: 2,635 times

last updated: 09 Apr '12, 04:46

                              
WEBFACTION
REACH US
SUPPORT
LEGAL
© COPYRIGHT 2003-2021 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM