Yes, I run syncdb before running the migration. I have ever tried running the migration without running syncdb first and it gave completely different error messages.
Regards, Gavin Au ----- Message from Andrew Colin Kissa <[email protected]> on Fri, 13 Jan 2012 07:21:32 +0200 ----- To: Baruwa users list <[email protected]> Subject: Re: [Baruwa] Schema-altering problem of Baruwa upgrade Hi Did you run syncdb before running the migration ? On 13 Jan 2012, at 7:13 AM, [email protected] wrote: > Hi, > > I am trying to upgrade Baruwa from version 1.0.2 to 1.1.1. I followed the steps from the documentation at http://www.baruwa.org/docs/upgrade.html#id1 but I encountered the following error when I run actual migration for all the modules. Is there any solution for this schema-altering problem? > > Running migrations for status: > - Migrating forwards to 0002_auto. > > status:0002_auto > ! 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: = DROP INDEX `mailq_direction` ON `mailq` [] > > ! The South developers regret this has happened, and would > ! like to gently persuade you to consider a slightly > ! easier-to-deal-with DBMS. > ! NOTE: The error which caused the migration to fail is further up. > Traceback (most recent call last): > File "/usr/bin/baruwa-admin", line 11, in ? > execute_manager(settings) > File "/usr/lib/python2.4/site-packages/django/core/management/__init__.py", line 438, in execute_manager > utility.execute() > File "/usr/lib/python2.4/site-packages/django/core/management/__init__.py", line 379, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File "/usr/lib/python2.4/site-packages/django/core/management/base.py", line 191, in run_from_argv > self.execute(*args, **options.__dict__) > File "/usr/lib/python2.4/site-packages/django/core/management/base.py", line 220, in execute > output = self.handle(*args, **options) > File "/usr/lib/python2.4/site-packages/south/management/commands/migrate.py", line 105, in handle > ignore_ghosts = ignore_ghosts, > File "/usr/lib/python2.4/site-packages/south/migration/__init__.py", line 191, in migrate_app > success = migrator.migrate_many(target, workplan, database) > File "/usr/lib/python2.4/site-packages/south/migration/migrators.py", line 221, in migrate_many > result = migrator.__class__.migrate_many(migrator, target, migrations, database) > File "/usr/lib/python2.4/site-packages/south/migration/migrators.py", line 292, in migrate_many > result = self.migrate(migration, database) > File "/usr/lib/python2.4/site-packages/south/migration/migrators.py", line 125, in migrate > result = self.run(migration) > File "/usr/lib/python2.4/site-packages/south/migration/migrators.py", line 99, in run > return self.run_migration(migration) > File "/usr/lib/python2.4/site-packages/south/migration/migrators.py", line 81, in run_migration > migration_function() > File "/usr/lib/python2.4/site-packages/south/migration/migrators.py", line 57, in <lambda> > return (lambda: direction(orm)) > File "/usr/lib/python2.4/site-packages/baruwa/status/migrations/0002_auto.py", line 12, in forwards > db.create_index(u'mailq', ['direction']) > File "/usr/lib/python2.4/site-packages/south/db/generic.py", line 673, in create_index > self.execute(sql) > File "/usr/lib/python2.4/site-packages/south/db/generic.py", line 150, in execute > cursor.execute(sql, params) > File "/usr/lib/python2.4/site-packages/django/db/backends/mysql/base.py", line 86, in execute > return self.cursor.execute(query, args) > File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 166, in execute > self.errorhandler(self, exc, value) > File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler > raise errorclass, errorvalue > django.db.utils.DatabaseError: (1146, "Table 'baruwa.mailq' doesn't exist") > > Regards, > Gavin Au > ********************************************************************************************* > Only an individual or entity who is intended to be a recipient of this e-mail may access or use the information contained in this e-mail or any of its attachments. Opinions contained in this e-mail or any of its attachments do not necessarily reflect the opinions of Queensland Treasury. > > The contents of this e-mail and any attachments are confidential and may be legally privileged and the subject of copyright. If you have received this e-mail in error, please notify Queensland Treasury immediately and erase all copies of the e-mail and the attachments. Queensland Treasury uses virus scanning software. However, it is not liable for viruses present in this e-mail or in any attachment. > *************************************************************************************************** > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
