I've tried that as well
the first one did well:
for name in $(echo "accounts messages lists reports status config"); do
baruwa-admin migrate $name 0001 --fake;
done
but the second one produced a lot of errors:
for name in $(echo "accounts messages lists reports status fixups config"); do
baruwa-admin migrate $name;
done
The errors are below (since there are quite a few)
Rob
##Begin of Error messages:
Running migrations for accounts:
- Migrating forwards to 0003_fix_spam_scores.
> accounts:0003_fix_spam_scores
! 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:
! 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 <module>
execute_manager(settings)
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 438, in execute_manager
utility.execute()
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
191, in run_from_argv
self.execute(*args, **options.__dict__)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
220, in execute
output = self.handle(*args, **options)
File "/usr/lib/pymodules/python2.6/south/management/commands/migrate.py",
line 105, in handle
ignore_ghosts = ignore_ghosts,
File "/usr/lib/pymodules/python2.6/south/migration/__init__.py", line 191,
in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
221, in migrate_many
result = migrator.__class__.migrate_many(migrator, target, migrations,
database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
292, in migrate_many
result = self.migrate(migration, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
125, in migrate
result = self.run(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 99,
in run
return self.run_migration(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 81,
in run_migration
migration_function()
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 57,
in <lambda>
return (lambda: direction(orm))
File
"/usr/lib/pymodules/python2.6/baruwa/accounts/migrations/0003_fix_spam_scores.py",
line 12, in forwards
db.alter_column('profiles', 'sa_high_score', self.gf
('django.db.models.fields.FloatField')())
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 387, in
alter_column
self.execute("ALTER TABLE %s %s;" % (self.quote_name(table_name), sql),
values)
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 150, in
execute
cursor.execute(sql, params)
File "/usr/lib/pymodules/python2.6/django/db/backends/mysql/base.py", line
86, in execute
return self.cursor.execute(query, args)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in
defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.DatabaseError: (1146, "Table 'baruwa.profiles' doesn't
exist")
Running migrations for messages:
- Migrating forwards to 0004_auto__add_deliveryinfo.
> messages: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 `archive_date` ON
`archive` []
= DROP INDEX `messages_date` ON `messages` []
! 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 <module>
execute_manager(settings)
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 438, in execute_manager
utility.execute()
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
191, in run_from_argv
self.execute(*args, **options.__dict__)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
220, in execute
output = self.handle(*args, **options)
File "/usr/lib/pymodules/python2.6/south/management/commands/migrate.py",
line 105, in handle
ignore_ghosts = ignore_ghosts,
File "/usr/lib/pymodules/python2.6/south/migration/__init__.py", line 191,
in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
221, in migrate_many
result = migrator.__class__.migrate_many(migrator, target, migrations,
database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
292, in migrate_many
result = self.migrate(migration, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
125, in migrate
result = self.run(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 99,
in run
return self.run_migration(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 81,
in run_migration
migration_function()
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 57,
in <lambda>
return (lambda: direction(orm))
File
"/usr/lib/pymodules/python2.6/baruwa/messages/migrations/0002_auto.py", line
12, in forwards
db.create_index('messages', ['date'])
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 673, in
create_index
self.execute(sql)
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 150, in
execute
cursor.execute(sql, params)
File "/usr/lib/pymodules/python2.6/django/db/backends/mysql/base.py", line
86, in execute
return self.cursor.execute(query, args)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in
defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.DatabaseError: (1146, "Table 'baruwa.messages' doesn't
exist")
Running migrations for lists:
- Migrating forwards to 0002_initial_sql.
> lists:0002_initial_sql
! 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:
! 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 <module>
execute_manager(settings)
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 438, in execute_manager
utility.execute()
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
191, in run_from_argv
self.execute(*args, **options.__dict__)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
220, in execute
output = self.handle(*args, **options)
File "/usr/lib/pymodules/python2.6/south/management/commands/migrate.py",
line 105, in handle
ignore_ghosts = ignore_ghosts,
File "/usr/lib/pymodules/python2.6/south/migration/__init__.py", line 191,
in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
221, in migrate_many
result = migrator.__class__.migrate_many(migrator, target, migrations,
database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
292, in migrate_many
result = self.migrate(migration, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
125, in migrate
result = self.run(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 99,
in run
return self.run_migration(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 81,
in run_migration
migration_function()
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 57,
in <lambda>
return (lambda: direction(orm))
File
"/usr/lib/pymodules/python2.6/baruwa/lists/migrations/0002_initial_sql.py",
line 15, in forwards
db.execute_many(open(listsql).read())
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 168, in
execute_many
self.execute(st)
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 150, in
execute
cursor.execute(sql, params)
File "/usr/lib/pymodules/python2.6/django/db/backends/mysql/base.py", line
86, in execute
return self.cursor.execute(query, args)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in
defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.DatabaseError: (1146, "Table 'baruwa.lists' doesn't exist")
Running migrations for reports:
- Nothing to migrate.
- Loading initial data for reports.
No fixtures found.
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 <module>
execute_manager(settings)
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 438, in execute_manager
utility.execute()
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
191, in run_from_argv
self.execute(*args, **options.__dict__)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
220, in execute
output = self.handle(*args, **options)
File "/usr/lib/pymodules/python2.6/south/management/commands/migrate.py",
line 105, in handle
ignore_ghosts = ignore_ghosts,
File "/usr/lib/pymodules/python2.6/south/migration/__init__.py", line 191,
in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
221, in migrate_many
result = migrator.__class__.migrate_many(migrator, target, migrations,
database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
292, in migrate_many
result = self.migrate(migration, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
125, in migrate
result = self.run(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 99,
in run
return self.run_migration(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 81,
in run_migration
migration_function()
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 57,
in <lambda>
return (lambda: direction(orm))
File "/usr/lib/pymodules/python2.6/baruwa/status/migrations/0002_auto.py",
line 12, in forwards
db.create_index(u'mailq', ['direction'])
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 673, in
create_index
self.execute(sql)
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 150, in
execute
cursor.execute(sql, params)
File "/usr/lib/pymodules/python2.6/django/db/backends/mysql/base.py", line
86, in execute
return self.cursor.execute(query, args)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in
defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.DatabaseError: (1146, "Table 'baruwa.mailq' doesn't exist")
Running migrations for fixups:
- Nothing to migrate.
- Loading initial data for fixups.
No fixtures found.
Running migrations for config:
- Migrating forwards to 0003_initial_sql.
>
config:0002_auto__add_domainsignature__add_unique_domainsignature_useraddress_sign
! 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 TABLE `domain_signatures`
CASCADE; []
! 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 <module>
execute_manager(settings)
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 438, in execute_manager
utility.execute()
File "/usr/lib/pymodules/python2.6/django/core/management/__init__.py",
line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
191, in run_from_argv
self.execute(*args, **options.__dict__)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py", line
220, in execute
output = self.handle(*args, **options)
File "/usr/lib/pymodules/python2.6/south/management/commands/migrate.py",
line 105, in handle
ignore_ghosts = ignore_ghosts,
File "/usr/lib/pymodules/python2.6/south/migration/__init__.py", line 191,
in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
221, in migrate_many
result = migrator.__class__.migrate_many(migrator, target, migrations,
database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
292, in migrate_many
result = self.migrate(migration, database)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line
125, in migrate
result = self.run(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 99,
in run
return self.run_migration(migration)
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 81,
in run_migration
migration_function()
File "/usr/lib/pymodules/python2.6/south/migration/migrators.py", line 57,
in <lambda>
return (lambda: direction(orm))
File
"/usr/lib/pymodules/python2.6/baruwa/config/migrations/0002_auto__add_domainsignature__add_unique_domainsignature_useraddress_sign.py",
line 18, in forwards
('image', self.gf('django.db.models.fields.related.ForeignKey')(blank=True,
related_name='ds_si', null=True, to=orm['fixups.SignatureImg'])),
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 226, in
create_table
', '.join([col for col in columns if col]),
File "/usr/lib/pymodules/python2.6/south/db/generic.py", line 150, in
execute
cursor.execute(sql, params)
File "/usr/lib/pymodules/python2.6/django/db/backends/mysql/base.py", line
86, in execute
return self.cursor.execute(query, args)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in
defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1050, "Table 'domain_signatures'
already exists")
##End of error messages
2011/10/24 Andrew Colin Kissa <[email protected]>
>
> On 24 Oct 2011, at 2:48 PM, Rob Verduijn wrote:
>
> > It seems that baruwa-admin syncdb is unable to initialize a new 'empty'
> db.
>
> You need to run migrations as well, syncdb alone will not initialize all
> the tables.
>
> for name in $(echo "accounts messages lists reports status fixups
> config"); do
> baruwa-admin migrate $name;
> done
>
> --
> Baruwa - www.baruwa.org
>
> _______________________________________________
> Keep Baruwa FREE - http://pledgie.com/campaigns/12056
>
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
