Redirect add fails

[klebed]

Hi! I have a little problem with cms-redirect.

Installed cms-redirects from pip, added in INSTALLED_APPS, done manage.py migrate, but now getting strange error, while trying to add new redirect:

(1452, 'Cannot add or update a child row: a foreign key constraint fails (appname.cms_redirects_cmsredirect, CONSTRAINT site_id_refs_id_59d206086c6310a1 FOREIGN KEY (site_id) REFERENCES django_site (id))')

[andrewschoen]

Do you have django.contrib.sites in INSTALLED_APPS?

[klebed]

INSTALLED_APPS = (
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'django.contrib.messages',
'django.contrib.staticfiles',
# Uncomment the next line to enable the admin:
'django.contrib.admin',
'cms', #django CMS itself
'mptt', #utilities for implementing a modified pre-order traversal tree
'menus', #helper for model independent hierarchical website navigation
'south', #intelligent schema and data migrations
'sekizai', #for javascript and css management
'cms.plugins.file',
'cms.plugins.flash',
'cms.plugins.googlemap',
'cms.plugins.link',
'cms.plugins.picture',
'cms.plugins.snippet',
'cms.plugins.teaser',
'cms.plugins.text',
'cms.plugins.video',
'cms.plugins.twitter',
'tinymce',
'filebrowser',
'uploadify',
# Uncomment the next line to enable admin documentation:
# 'django.contrib.admindocs',
'cms_redirects',
)

[andrewschoen]

Maybe try a python manage.py syncdb before the migrate. Seems like for whatever reason the site table isn't being created.

If that doesn't work you might just try to include the project directly from the master branch here on github. We haven't pushed up to pypi in a bit.

[klebed]

Ok. I will try both ways.

[benjaoming]

Had the same error message with a different application.

It turned out, I had created django_sites at an earlier point in time, and it was MyISAM but needed to be InnoDB. Changing it fixed the error.