Issues installing

99 views
Skip to first unread message

Joseph Curtin

unread,
Mar 31, 2010, 8:41:25 PM3/31/10
to django-cms
Hey all,
On a fresh database, I have getting this error from time to time.
__________________________________________________________________
Running migrations for text:
- Migrating forwards to 0005_publisher2.
> cms:0001_initial
> cms:0002_auto_start
> cms:0003_remove_placeholder
> cms:0004_textobjects
> cms:0005_mptt_added_to_plugins
> text:0001_initial
> text:0002_freeze
> cms:0006_apphook
> cms:0007_apphook_longer
> cms:0008_redirects
> cms:0009_added_meta_fields
> cms:0010_5char_language
> cms:0011_title_overwrites
> cms:0012_publisher
> text:0003_publisher
> link:0001_initial
> link:0002_link_rename
> link:0003_page_link
> link:0004_larger_link_names
> link:0005_publisher
> file:0001_initial
> file:0002_freeze
> file:0003_publisher
> snippet:0001_initial
> snippet:0002_publisher
> googlemap:0001_initial
> flash:0001_initial
> flash:0002_freeze
> flash:0003_publisher
> cms:0013_site_copy
> cms:0014_sites_removed
> cms:0015_modified_by_added
> cms:0016_author_copy
> cms:0017_author_removed
> cms:0018_site_permissions
> picture:0001_initial
> picture:0002_link_rename
> picture:0003_freeze
> picture:0004_publisher
> cms:0019_public_table_renames
> text:0004_table_rename
> text:0005_publisher2
Traceback (most recent call last):
File "manage.py", line 11, in <module>
execute_manager(settings)
File "/usr/lib/pymodules/python2.6/django/core/management/
__init__.py", line 362, in execute_manager
utility.execute()
File "/usr/lib/pymodules/python2.6/django/core/management/
__init__.py", line 303, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
line 195, in run_from_argv
self.execute(*args, **options.__dict__)
File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
line 222, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python2.6/dist-packages/South-0.7_rc1-py2.6.egg/
south/management/commands/migrate.py", line 102, in handle
delete_ghosts = delete_ghosts,
File "/usr/local/lib/python2.6/dist-packages/South-0.7_rc1-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_rc1-py2.6.egg/
south/migration/migrators.py", line 215, in migrate_many
result = migrator.__class__.migrate_many(migrator, target,
migrations, database)
File "/usr/local/lib/python2.6/dist-packages/South-0.7_rc1-py2.6.egg/
south/migration/migrators.py", line 289, in migrate_many
south.db.db.send_pending_create_signals()
File "/usr/local/lib/python2.6/dist-packages/South-0.7_rc1-py2.6.egg/
south/db/generic.py", line 773, in send_pending_create_signals
self.really_send_create_signal(app_label, list(set(model_names)))
File "/usr/local/lib/python2.6/dist-packages/South-0.7_rc1-py2.6.egg/
south/db/generic.py", line 831, in really_send_create_signal
interactive=interactive,
File "/usr/lib/pymodules/python2.6/django/dispatch/dispatcher.py",
line 166, in send
response = receiver(signal=self, sender=sender, **named)
File "/usr/local/lib/python2.6/dist-packages/reversion/management/
__init__.py", line 40, in create_initial_revisions
all_ids = frozenset(unicode(id) for id in
model_class._default_manager.values_list("pk", flat=True).iterator())
File "/usr/local/lib/python2.6/dist-packages/reversion/management/
__init__.py", line 40, in <genexpr>
all_ids = frozenset(unicode(id) for id in
model_class._default_manager.values_list("pk", flat=True).iterator())
File "/usr/lib/pymodules/python2.6/django/db/models/query.py", line
856, in iterator
for row in self.query.results_iter():
File "/usr/lib/pymodules/python2.6/django/db/models/sql/query.py",
line 287, in results_iter
for rows in self.execute_sql(MULTI):
File "/usr/lib/pymodules/python2.6/django/db/models/sql/query.py",
line 2369, in execute_sql
cursor.execute(sql, params)
File "/usr/lib/pymodules/python2.6/django/db/backends/util.py", line
19, in execute
return self.cursor.execute(sql, params)
File "/usr/lib/pymodules/python2.6/django/db/backends/mysql/
base.py", line 84, 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.ProgrammingError: (1146, "Table
'cmsemailstwo.cmsplugin_link' doesn't exist")

____________________________________________

Naturally, I run the migrate command again and it works. At that time
I have a running installation.

I add a page, publish it and view it.

However, when I try to add a plugin. Such as text or video. I get this
error:

________________________________________________

Request URL:
http://localhost:8000/admin/cms/page/2/add-plugin/
Exception Type:
OperationalError
Exception Value:
Unknown column: cmsplugin_googlemap.address

____________________________________________

I didn't know I was playing with google maps while trying to add some
text. :P

Other times, I can add text without issue. It's really a roll of the
dice. Normally once this happens, I have to drop the tables and start
anew. Any thoughts?

Thanks,
-Joe

Patrick Lauber

unread,
Apr 7, 2010, 5:45:39 PM4/7/10
to djang...@googlegroups.com
mysql? postgres?

> --
> You received this message because you are subscribed to the Google Groups "django-cms" group.
> To post to this group, send email to djang...@googlegroups.com.
> To unsubscribe from this group, send email to django-cms+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/django-cms?hl=en.
>

Jonas Obrist

unread,
Apr 7, 2010, 5:49:34 PM4/7/10
to djang...@googlegroups.com
Use this instead:

python manage.py syncdb --all
python manage.py migrate --all --fake

Joseph Curtin

unread,
Apr 7, 2010, 9:02:58 PM4/7/10
to djang...@googlegroups.com
MySQL.

 I'll update you all again after I try the --all --fake command.
--
-Joe Curtin
http://www.jbcurtin.com

bydesign

unread,
Apr 9, 2010, 3:34:58 PM4/9/10
to django-cms
I had this same problem, and the --fake on the migrate command seemed
to work for me. But I assume this means that south is working
correctly? Will this prevent future upgrades?

> >>> django-cms+...@googlegroups.com<django-cms%2Bunsubscribe@googlegrou ps.com>


> >>> .
> >>> For more options, visit this group at
> >>>http://groups.google.com/group/django-cms?hl=en.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "django-cms" group.
> > To post to this group, send email to djang...@googlegroups.com.
> > To unsubscribe from this group, send email to

> > django-cms+...@googlegroups.com<django-cms%2Bunsubscribe@googlegrou ps.com>

bydesign

unread,
Apr 12, 2010, 9:51:13 AM4/12/10
to django-cms
Now I'm getting the following:

Running migrations for cms:
- Migrating forwards to 0027_added_width_to_placeholder.
> cms:0001_initial
> flash:0001_initial
> flash:0002_freeze


> cms:0002_auto_start
> cms:0003_remove_placeholder
> cms:0004_textobjects
> cms:0005_mptt_added_to_plugins

> cms:0006_apphook
> cms:0007_apphook_longer
> cms:0008_redirects
> cms:0009_added_meta_fields
> cms:0010_5char_language
> cms:0011_title_overwrites
> cms:0012_publisher

> flash:0003_publisher


> file:0001_initial
> file:0002_freeze
> file:0003_publisher

> googlemap:0001_initial


> cms:0013_site_copy
> cms:0014_sites_removed
> cms:0015_modified_by_added
> cms:0016_author_copy
> cms:0017_author_removed
> cms:0018_site_permissions

> snippet:0001_initial
> snippet:0002_publisher


> picture:0001_initial
> picture:0002_link_rename
> picture:0003_freeze
> picture:0004_publisher

> link:0001_initial
> link:0002_link_rename
> link:0003_page_link
> link:0004_larger_link_names
> link:0005_publisher

> text:0001_initial
> text:0002_freeze
> text:0003_publisher
> cms:0019_public_table_renames
> teaser:0001_initial
> picture:0005_table_rename
> picture:0006_float_added
> cms:0020_advanced_permissions
> cms:0021_publisher2
> cms:0022_login_required_added
> cms:0023_plugin_table_naming_function_changed
> cms:0024_added_placeholder_model
> cms:0025_placeholder_migration
- Migration 'cms:0025_placeholder_migration' is marked for no-dry-
run.
> cms:0026_finish_placeholder_migration
> cms:0027_added_width_to_placeholder


Traceback (most recent call last):

File "manage.py", line 13, in <module>
execute_manager(settings)
File "/Users/jleineweber/Downloads/Django-1.2/django/core/management/
__init__.py", line 438, in execute_manager
utility.execute()
File "/Users/jleineweber/Downloads/Django-1.2/django/core/management/
__init__.py", line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Users/jleineweber/Downloads/Django-1.2/django/core/management/


base.py", line 195, in run_from_argv
self.execute(*args, **options.__dict__)

File "/Users/jleineweber/Downloads/Django-1.2/django/core/management/


base.py", line 222, in execute
output = self.handle(*args, **options)

File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/south/management/commands/migrate.py", line


102, in handle
delete_ghosts = delete_ghosts,

File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/south/migration/__init__.py", line 202, in


migrate_app
success = migrator.migrate_many(target, workplan, database)

File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/south/migration/migrators.py", line 218, in


migrate_many
result = migrator.__class__.migrate_many(migrator, target,
migrations, database)

File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/south/migration/migrators.py", line 294, in
migrate_many
south.db.db.send_pending_create_signals()
File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/south/db/generic.py", line 773, in
send_pending_create_signals
self.really_send_create_signal(app_label, list(set(model_names)))
File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/south/db/generic.py", line 822, in
really_send_create_signal
db=self.db_alias,
File "/Users/jleineweber/Downloads/Django-1.2/django/dispatch/


dispatcher.py", line 166, in send
response = receiver(signal=self, sender=sender, **named)

File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/reversion/management/__init__.py", line 40, in


create_initial_revisions
all_ids = frozenset(unicode(id) for id in
model_class._default_manager.values_list("pk", flat=True).iterator())

File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/reversion/management/__init__.py", line 40, in


<genexpr>
all_ids = frozenset(unicode(id) for id in
model_class._default_manager.values_list("pk", flat=True).iterator())

File "/Users/jleineweber/Downloads/Django-1.2/django/db/models/
query.py", line 939, in iterator
for row in self.query.get_compiler(self.db).results_iter():
File "/Users/jleineweber/Downloads/Django-1.2/django/db/models/sql/
compiler.py", line 685, in results_iter
for rows in self.execute_sql(MULTI):
File "/Users/jleineweber/Downloads/Django-1.2/django/db/models/sql/
compiler.py", line 740, in execute_sql
cursor.execute(sql, params)
File "/Users/jleineweber/Downloads/Django-1.2/django/db/backends/


util.py", line 19, in execute
return self.cursor.execute(sql, params)

File "/Users/jleineweber/Downloads/Django-1.2/django/db/backends/
mysql/base.py", line 86, in execute
return self.cursor.execute(query, args)
File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/MySQL_python-1.2.3c1-py2.6-macosx-10.3-fat.egg/
MySQLdb/cursors.py", line 173, in execute
File "/Library/Frameworks/Python.framework/Versions/2.6/lib/
python2.6/site-packages/MySQL_python-1.2.3c1-py2.6-macosx-10.3-fat.egg/
MySQLdb/connections.py", line 36, in defaulterrorhandler
django.db.utils.DatabaseError: (1146, "Table 'cms.cmsplugin_flash'
doesn't exist")


So again, I can get it working by running the migrate --fake, but what
functionality do we lose by doing it this way?

Reply all
Reply to author
Forward
0 new messages