I&#39;m building a fairly simple application, research, in my Django project that uses Django-CMS.  (It&#39;s my first ground-up attempt at a project/application.)  Its main purpose is to store various intellectual assets (i.e article, book, etc. written by a researcher).  

The problem is that when I point the browser to `/research/` I get an error saying that the `table &#39;research_journal&#39; doesn&#39;t exist (&quot;no such table&quot;)`.

I&#39;m using Djnago 1.6.5 with a sqlite3 database.

Looking at `python manage.py sql research` yields:

    BEGIN;
    CREATE TABLE &quot;research_researchbase&quot; (
        &quot;id&quot; integer NOT NULL PRIMARY KEY,
        &quot;pub_date&quot; datetime NOT NULL,
        &quot;authors&quot; varchar(200) NOT NULL,
        &quot;year&quot; varchar(25) NOT NULL,
        &quot;title&quot; varchar(200) NOT NULL,
        &quot;subtitle&quot; varchar(200) NOT NULL,
        &quot;image_id&quot; integer NOT NULL REFERENCES &quot;filer_image&quot; (&quot;file_ptr_id&quot;),
        &quot;link&quot; varchar(200) NOT NULL
    )
    ;
    CREATE TABLE &quot;research_journal&quot; (
        &quot;researchbase_ptr_id&quot; integer NOT NULL PRIMARY KEY REFERENCES &quot;research_researchbase&quot; (&quot;id&quot;),
        &quot;journal&quot; varchar(200) NOT NULL,
        &quot;abstract&quot; text NOT NULL,
        &quot;citation&quot; varchar(200) NOT NULL
    )
    ;
    CREATE TABLE &quot;research_encyclopedia_chapter&quot; (
        &quot;researchbase_ptr_id&quot; integer NOT NULL PRIMARY KEY REFERENCES &quot;research_researchbase&quot; (&quot;id&quot;),
        &quot;encyclopedia&quot; varchar(200) NOT NULL,
        &quot;publisher&quot; varchar(200) NOT NULL,
        &quot;summary&quot; varchar(200) NOT NULL
    )
    ;
    CREATE TABLE &quot;research_book&quot; (
        &quot;researchbase_ptr_id&quot; integer NOT NULL PRIMARY KEY REFERENCES &quot;research_researchbase&quot; (&quot;id&quot;),
        &quot;publisher&quot; varchar(200) NOT NULL,
        &quot;summary&quot; varchar(200) NOT NULL
    )
    ;
    
    COMMIT;

I&#39;ve run `python manage.py migrate research` and get:

    /Users/XXX/Documents/repos/sfs/env/lib/python2.7/site-packages/app_data/fields.py:2: DeprecationWarning: django.utils.simplejson is deprecated; use json instead.
      from django.utils import simplejson as json
    
    Running migrations for research:
    - Nothing to migrate.
     - Loading initial data for research.
    Installed 0 object(s) from 0 fixture(s)

I&#39;ve run `python manage.py syncdb` and get the following:

    Syncing...
    Creating tables ...
    Installing custom SQL ...
    Installing indexes ...
    Installed 0 object(s) from 0 fixture(s)
    
    Synced:
     &gt; djangocms_admin_style
     &gt; django.contrib.auth
     &gt; django.contrib.contenttypes
     &gt; django.contrib.sessions
     &gt; django.contrib.admin
     &gt; django.contrib.sites
     &gt; django.contrib.sitemaps
     &gt; django.contrib.staticfiles
     &gt; django.contrib.messages
     &gt; mptt
     &gt; south
     &gt; sekizai
     &gt; django_select2
     &gt; hvad
    
    Not synced (use migrations):
     - djangocms_text_ckeditor
     - cms
     - menus
     - djangocms_style
     - djangocms_column
     - djangocms_file
     - djangocms_flash
     - djangocms_googlemap
     - djangocms_inherit
     - djangocms_link
     - djangocms_picture
     - djangocms_teaser
     - djangocms_video
     - reversion
     - polls
     - djangocms_polls
     - aldryn_blog
     - easy_thumbnails
     - filer
     - taggit
     - research
    (use ./manage.py migrate to migrate these)

Here&#39;s the `models.py`:

    from django.db import models
    from django.utils import timezone
    from filer.fields.image import FilerImageField
    
    import datetime
    
    class ResearchBase(models.Model):
        pub_date = models.DateTimeField(&#39;date published&#39;)
        authors = models.CharField(max_length=200)
        year = models.CharField(max_length=25)
        title = models.CharField(max_length=200)
        subtitle = models.CharField(max_length=200, blank=True)
        image = FilerImageField()
        link = models.CharField(max_length=200, blank=True)
        
        def __unicode__(self):
            return self.title
        
        def was_published_recently(self):
            return self.pub_date &gt;= timezone.now() - datetime.timedelta(days=1)
            
    
    class Journal(ResearchBase):
        journal = models.CharField(max_length=200)
        abstract = models.TextField()
        citation = models.CharField(max_length=200)
        
        
    class Encyclopedia_Chapter(ResearchBase):
        encyclopedia = models.CharField(max_length=200)
        publisher = models.CharField(max_length=200)
        summary = models.CharField(max_length=200)
        
            
    class Book(ResearchBase):
        publisher = models.CharField(max_length=200)
        summary = models.CharField(max_length=200)

Here&#39;s my `views.py` (note that I am passing two objects through render, ignore the fact that I have yet to include the class Books in the whole deal):

    from django.shortcuts import render, get_object_or_404
    from django.http import HttpResponse, Http404
    from django.template import RequestContext, loader
    
    from research.models import Journal, Encyclopedia_Chapter, Book
    
    def research_index(request):
        latest_journal_list = Journal.objects.order_by(&#39;-pub_date&#39;)[:5]
        latest_chapter_list = Encyclopedia_Chapter.objects.order_by(&#39;-pub_date&#39;)[:5]
        
        context = {
            &#39;latest_journal_list&#39;: latest_journal_list,
            &#39;latest_chapter_list&#39;: latest_chapter_list
        }
        
        return render(request, &#39;research/index.html&#39;, context)
        
    def journal_detail(request, journal_id):
        journal = get_object_or_404(Journal, pk=journal_id)
        return render(request, &#39;research/journal_detail.html&#39;, {&#39;journal&#39;: journal})
        
    def chapter_detail(request, chapter_id):
        chapter = get_object_or_404(Encyclopedia_Chapter, pk=chapter_id)
        return render(request, &#39;research/chapter_detail.html&#39;, {&#39;chapter&#39;: chapter})

Here&#39;s the application&#39;s `url.py`:

    from django.conf.urls import patterns, url
    
    from research import views
    
    urlpatterns = patterns(&#39;&#39;,
        url(r&#39;^$&#39;, views.research_index, name=&#39;research&#39;),
        url(r&#39;^(?P&lt;journal_id&gt;\d+)/$&#39;, views.journal_detail, name=&#39;journal_detail&#39;),
        url(r&#39;^(?P&lt;chapter_id&gt;\d+)/$&#39;, views.chapter_detail, name=&#39;chapter_detail&#39;),
    )

Here&#39;s the `index.html` template:

    {% extends &#39;research/base.html&#39; %}
    
    {% block research_content %}
    
    &lt;div class=&quot;container&quot;&gt;
    	&lt;div class=&quot;row featurette&quot;&gt;
    		&lt;h3 id=&quot;research&quot;&gt;Peer-reviewed Journal Articles&lt;/h3&gt;
    		{% if latest_journal_list %}
    		    &lt;ul id=&quot;research&quot;&gt;
    		    {% for journal in latest_journal_list %}
    		        &lt;li id=&quot;research&quot;&gt;
    							&lt;img src=&quot;{{ journal.image.url }}&quot; id=&quot;research&quot;&gt;
    							&lt;h4&gt;{{ journal.journal }}&lt;/h4&gt;
    							&lt;h5&gt;{{ journal.title }}&lt;/h5&gt;
    							&lt;a href=&quot;{% url &#39;research:journal_detail&#39; journal.id %}&quot;&gt;Read More&lt;/a&gt;
    						&lt;/li&gt;
    		    {% endfor %}
    		    &lt;/ul&gt;
    		{% else %}
    		    &lt;p&gt;No journals are available.&lt;/p&gt;
    		{% endif %}
    	&lt;/div&gt;
    	
    	&lt;div class=&quot;row featurette&quot;&gt;
    		&lt;h3 id=&quot;research&quot;&gt;Encyclopedia Chapters&lt;/h3&gt;
    		{% if latest_chapter_list %}
    		    &lt;ul id=&quot;research&quot;&gt;
    		    {% for chapter in latest_chapter_list %}
    		        &lt;li id=&quot;research&quot;&gt;
    							&lt;img src=&quot;{{ chapter.image.url }}&quot; id=&quot;research&quot;&gt;
    							&lt;h4&gt;{{ chapter.journal }}&lt;/h4&gt;
    							&lt;h5&gt;{{ chapter.title }}&lt;/h5&gt;
    							&lt;a href=&quot;{% url &#39;research:chapter_detail&#39; chapter.id %}&quot;&gt;Read More&lt;/a&gt;
    						&lt;/li&gt;
    		    {% endfor %}
    		    &lt;/ul&gt;
    		{% else %}
    		    &lt;p&gt;No encyclopedia chapters are available.&lt;/p&gt;
    		{% endif %}
    	&lt;/div&gt;
    &lt;/div&gt;
    
    {% endblock %}

Just in case it matters, here&#39;s my `cms_app.py`:

    from cms.app_base import CMSApp
    from cms.apphook_pool import apphook_pool
    from django.utils.translation import ugettext_lazy as _
    
    
    class ResearchApp(CMSApp):
        name = _(&quot;Research App&quot;)
        urls = [&quot;research.urls&quot;]
        app_name = &quot;research&quot;
    
    apphook_pool.register(ResearchApp)



All Django Cms Solutions on Gang of Coders

Total of 1 Django Cms Solutions

Django: OperationalError No Such Table