I figured this one out. When doing syncdb, I need to say --all. On Sep 27, 12:02 am, angad <[email protected]> wrote: > Hi, > > I locally cloned the large store of satchmo, and had everything > working fine. I need to change the database engine to mysql now, so I > created the database etc., but I got errors when I tried manage.py > syncdb. I was recommended to to manage.py migrate, but that didn't > help either. I searched for a solution, and it seems like a problem > with South, but just want to confirm from here. Also want to check if > there is a workaround or anything. > > Here's the error with syncdb: > ------------------------------------------------------ > Sun, 26 Sep 2010 23:15:05 root INFO Satchmo Started > Sun, 26 Sep 2010 23:15:05 root INFO Satchmo Started > Sun, 26 Sep 2010 23:15:05 tiered.config DEBUG loaded > Sun, 26 Sep 2010 23:15:05 tieredweight.config DEBUG loaded > Sun, 26 Sep 2010 23:15:05 shop.listeners DEBUG Added default shop > listeners > /usr/local/lib/python2.6/dist-packages/django_registration-0.7- > py2.6.egg/registration/models.py:4: DeprecationWarning: the sha module > is deprecated; use the hashlib module instead > Sun, 26 Sep 2010 23:15:05 product.modules.downloadable.listeners > DEBUG Added downnloadable product listeners > Sun, 26 Sep 2010 23:15:05 satchmo_toolbar DEBUG Satchmo toolbar > ready > Syncing... > Installing yaml fixture 'initial_data' from '/usr/local/lib/python2.6/ > dist-packages/Satchmo-0.9_2-py2.6.egg/satchmo_store/shop/fixtures'. > Problem installing fixture '/usr/local/lib/python2.6/dist-packages/ > Satchmo-0.9_2-py2.6.egg/satchmo_store/shop/fixtures/ > initial_data.yaml': Traceback (most recent call last): > File "/usr/local/lib/python2.6/dist-packages/django/core/management/ > commands/loaddata.py", line 169, in handle > obj.save(using=using) > File "/usr/local/lib/python2.6/dist-packages/django/core/serializers/ > base.py", line 165, in save > models.Model.save_base(self.object, using=using, raw=True) > File "/usr/local/lib/python2.6/dist-packages/django/db/models/ > base.py", line 497, in save_base > manager.using(using).filter(pk=pk_val).exists())): > File "/usr/local/lib/python2.6/dist-packages/django/db/models/ > query.py", line 496, in exists > return self.query.has_results(using=self.db) > File "/usr/local/lib/python2.6/dist-packages/django/db/models/sql/ > query.py", line 417, in has_results > return bool(compiler.execute_sql(SINGLE)) > File "/usr/local/lib/python2.6/dist-packages/django/db/models/sql/ > compiler.py", line 727, in execute_sql > cursor.execute(sql, params) > File "/usr/local/lib/python2.6/dist-packages/django/db/backends/ > util.py", line 15, in execute > return self.cursor.execute(sql, params) > File "/usr/local/lib/python2.6/dist-packages/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 > DatabaseError: (1146, "Table 'my_store.product_productimage' doesn't > exist") > > Synced: > > django.contrib.sites > > satchmo_store.shop > > django.contrib.admin > > django.contrib.admindocs > > django.contrib.auth > > django.contrib.contenttypes > > django.contrib.comments > > django.contrib.sessions > > registration > > sorl.thumbnail > > south > > keyedcache > > livesettings > > l10n > > satchmo_store.contact > > tax > > tax.modules.area > > tax.modules.percent > > shipping > > satchmo_store.contact.supplier > > shipping.modules.tiered > > shipping.modules.tieredweight > > satchmo_ext.recentlist > > satchmo_ext.product_feeds > > satchmo_ext.brand > > payment > > payment.modules.dummy > > payment.modules.authorizenet > > payment.modules.purchaseorder > > payment.modules.giftcertificate > > satchmo_ext.upsell > > satchmo_ext.productratings > > satchmo_ext.satchmo_toolbar > > satchmo_utils > > shipping.modules.tieredquantity > > satchmo_ext.tieredpricing > > app_plugins > > my_store.localsite > > django.contrib.flatpages > > satchmo_ext.wishlist > > satchmo_ext.newsletter > > Not synced (use migrations): > - product > - product.modules.configurable > - product.modules.custom > - product.modules.downloadable > (use ./manage.py migrate to migrate these) > ---------------------------------------------------------------- > > When I try migrate, I get this: > ---------------------------------------------------------------- > Mon, 27 Sep 2010 00:01:13 root INFO Satchmo Started > Mon, 27 Sep 2010 00:01:13 root INFO Satchmo Started > Mon, 27 Sep 2010 00:01:14 tiered.config DEBUG loaded > Mon, 27 Sep 2010 00:01:14 tieredweight.config DEBUG loaded > Mon, 27 Sep 2010 00:01:14 shop.listeners DEBUG Added default shop > listeners > /usr/local/lib/python2.6/dist-packages/django_registration-0.7- > py2.6.egg/registration/models.py:4: DeprecationWarning: the sha module > is deprecated; use the hashlib module instead > Mon, 27 Sep 2010 00:01:14 product.modules.downloadable.listeners > DEBUG Added downnloadable product listeners > Mon, 27 Sep 2010 00:01:14 satchmo_toolbar DEBUG Satchmo toolbar > ready > Running migrations for product: > - Migrating forwards to 0012_update_contenttypes. > > subscription:0001_split > Mon, 27 Sep 2010 00:01:14 south DEBUG south execute "RENAME > TABLE `product_subscriptionproduct` TO > `subscription_subscriptionproduct`;" with params "[]" > Mon, 27 Sep 2010 00:01:14 south DEBUG south execute "RENAME > TABLE `product_trial` TO `subscription_trial`;" with params "[]" > Mon, 27 Sep 2010 00:01:14 south DEBUG south execute "SET > FOREIGN_KEY_CHECKS=1;" with params "[]" > Mon, 27 Sep 2010 00:01:14 south DEBUG south execute "RENAME > TABLE `product_subscriptionproduct` TO > `subscription_subscriptionproduct`;" with params "[]" > Mon, 27 Sep 2010 00:01:14 south DEBUG south execute "RENAME > TABLE `subscription_subscriptionproduct` TO > `product_subscriptionproduct`;" with params "[]" > Mon, 27 Sep 2010 00:01:14 south DEBUG south execute "RENAME > TABLE `subscription_trial` TO `product_trial`;" with params "[]" > ! 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: = RENAME TABLE > `subscription_subscriptionproduct` TO `product_subscriptionproduct`; > [] > = RENAME TABLE `subscription_trial` TO `product_trial`; [] > > ! 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 "./manage.py", line 34, in <module> > execute_manager(settings) > File "/usr/local/lib/python2.6/dist-packages/django/core/management/ > __init__.py", line 438, in execute_manager > utility.execute() > File "/usr/local/lib/python2.6/dist-packages/django/core/management/ > __init__.py", line 379, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File "/usr/local/lib/python2.6/dist-packages/django/core/management/ > base.py", line 191, in run_from_argv > self.execute(*args, **options.__dict__) > File "/usr/local/lib/python2.6/dist-packages/django/core/management/ > base.py", line 218, in execute > output = self.handle(*args, **options) > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/management/commands/migrate.py", line 109, in handle > ignore_ghosts = ignore_ghosts, > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/migration/__init__.py", line 202, in migrate_app > success = migrator.migrate_many(target, workplan, database) > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/migration/migrators.py", line 220, in migrate_many > result = migrator.__class__.migrate_many(migrator, target, > migrations, database) > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/migration/migrators.py", line 291, in migrate_many > result = self.migrate(migration, database) > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/migration/migrators.py", line 125, in migrate > result = self.run(migration) > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/migration/migrators.py", line 99, in run > return self.run_migration(migration) > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/migration/migrators.py", line 81, in run_migration > migration_function() > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/migration/migrators.py", line 57, in <lambda> > return (lambda: direction(orm)) > File "/usr/local/lib/python2.6/dist-packages/Satchmo-0.9_2-py2.6.egg/ > product/modules/subscription/migrations/0001_split.py", line 8, in > forwards > db.rename_table('product_subscriptionproduct', > 'subscription_subscriptionproduct') > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/db/mysql.py", line 110, in rename_table > self.execute('RENAME TABLE %s TO %s;' % params) > File "/usr/local/lib/python2.6/dist-packages/South-0.7.1-py2.6.egg/ > south/db/generic.py", line 134, in execute > cursor.execute(sql, params) > File "/usr/local/lib/python2.6/dist-packages/django/db/backends/ > util.py", line 15, in execute > return self.cursor.execute(sql, params) > File "/usr/local/lib/python2.6/dist-packages/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: (1017, "Can't find file: './ > my_store/product_subscriptionproduct.frm' (errno: 2)") > ---------------------------------------------------------------- > > Any idea what's happening? Also, what is the fix for this? I'm using > 0.9.1. > > Thanks, > Angad
-- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
