Ask Your Question
0

can not migrate askbot please help

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

Pramvir gravatar image

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]$

edit retag flag offensive close delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2012-04-09 10:20:53 -0500

Hi

Askbot does not support Django 1.4 release so please use Django 1.3 we're working with django's 1.4 support.

And I guess you are using Mysql as a database currently there is a bug in south that breaks delete_unique method so please install south from their repository More info on this subject here

edit flag offensive delete publish link more

Comments

when I remove south I can't sign in :-(

Pramvir ( 2012-04-09 14:46:27 -0500 )edit

askbot install but can not sign in

Pramvir ( 2012-04-09 14:47:05 -0500 )edit

@Pramvir Need some info: django version, database server and database driver you're using

Fitoria ( 2012-04-09 14:58:52 -0500 )edit

django 1.3, psql,

I don't know what is driver. I posted a ticket to my hosting company about installing they successfully installed it in sqlite3 but for psql they said askbot is not compatible with latest psql and thus this migration error happening..

Pramvir ( 2012-04-09 15:13:12 -0500 )edit

see this is installation with sqlite3 http://test.pramvir.webfactional.com

can I officially use askbot with sqlite or I must use psql ???

Pramvir ( 2012-04-09 15:17:44 -0500 )edit

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

Add answer

[hide preview]

Reliable Askbot Hosting

Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.

create your Q&A site
30 days free trial

Stats

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

Seen: 225 times

Last updated: Apr 09 '12