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.
