[Django]-Django with django-nose: two identical settings files with different behavior in running test command

Is your database NAME set to a relative path for the sqlite DB?

If so, you may simply need to syncdb with your settings file in test_settings.

DatabaseError: no such table: django_content_type means one of the django specific tables isn’t found, which sounds like an issue with the DB itself, not your app or the settings file itself.