Ok, since your model is not managed it doesn't create migrations either.

If table name is written in uppercase, you can remove double quotes, Oracle is by default uppercase and quoted format is only required for tables or fields that are written in mixed or lowercase.

Are you sure that problem is really your model?

On 11.11.2016 02:03, Jeffrey Uvero wrote:
Jani Tiainen, Thank you for your response .

Yes, I am using legacy database , that's why I can't control the naming of columns and tables

On Thu, Nov 10, 2016 at 4:16 PM, Jani Tiainen <rede...@gmail.com <mailto:rede...@gmail.com>> wrote:

    Oracle migrations are problematic due that fact that Oracle DDL is
    not transactioned. So if something goes wrong you can't rollback
    to previous state, your database ends up in broken state (in
    theory django could clean it up).

    Also try to avoid double quotes around table and column names. You
    only need them if you're working with legacy database where table
    names are written in lower case. Better yet, let Django to take
    care of table names all together.



    On 10.11.2016 03:45, Jeffrey Uvero wrote:
    Thank you for your response ,,

    Yes. I applied migration, when I applying for that, another error
    comes out

     return self.cursor.execute(query, self._param_generator(params))
    django.db.utils.DatabaseError: ORA-00955: name is already used by
    an existing object

    On Thu, Nov 10, 2016 at 9:26 AM, Charly Román
    <chack14r...@gmail.com <mailto:chack14r...@gmail.com>> wrote:

        Do you applied your migrations?

        Charly Román
        Software Developer
        http://croman.mx <http://croman.mx/>

        2016-11-09 19:08 GMT-06:00 jeffreyequizuvero
        <jeffreyequizuv...@gmail.com
        <mailto:jeffreyequizuv...@gmail.com>>:

            /Hi everyone./
            /
            /
            /I am new in Django Development and I encountered this
            problem, please help/
            /
            /
            /TIA/
            /
            /
            /Jeffrey E. Uvero /


              DatabaseError at /login/

            ORA-00942: table or view does not exist


            Request Method:     POST
            Request URL:        http://127.0.0.1:8000/login/
            Django Version:     1.10.1
            Exception Type:     DatabaseError
            Exception Value:    

            ORA-00942: table or view does not exist

            *(This is ny model)*

            class TblUser(models.Model): id =
            models.IntegerField(primary_key=True) # AutoField?
            user_code = models.CharField(max_length=50,
            default=user_code_key) full_name =
            models.CharField(max_length=50, blank=True, null=True)
            firstname = models.CharField(max_length=50, blank=True,
            null=True) middlename = models.CharField(max_length=50,
            blank=True, null=True) lastname =
            models.CharField(max_length=50, blank=True, null=True)
            username = models.CharField(max_length=50, blank=True,
            null=True) password = models.CharField(max_length=150,
            blank=True, null=True) user_level =
            models.CharField(max_length=50, default='user')
            designation = models.CharField(max_length=50, blank=True,
            null=True) email_address =
            models.CharField(max_length=50, blank=True, null=True)
            date_registered = models.CharField(max_length=50,
            default=datetime.now()) last_logged =
            models.CharField(max_length=50, blank=True, null=True)
            account_status = models.CharField(max_length=50,
            default='ACTIVE') verification =
            models.CharField(max_length=50, default='1') sys_code =
            models.CharField(max_length=50, default=sys_code_key)
            class Meta: managed = False db_table = '"TBLUSER"'

            -- You received this message because you are subscribed
            to the Google Groups "Django users" group. To unsubscribe
            from this group and stop receiving emails from it, send
            an email to django-users+unsubscr...@googlegroups.com
            <mailto:django-users+unsubscr...@googlegroups.com>. To
            post to this group, send email to
            django-users@googlegroups.com
            <mailto:django-users@googlegroups.com>. Visit this group
            at https://groups.google.com/group/django-users
            <https://groups.google.com/group/django-users>. To view
            this discussion on the web visit
            
https://groups.google.com/d/msgid/django-users/107cce9c-9795-40b9-ba74-194eb440b2bc%40googlegroups.com
            
<https://groups.google.com/d/msgid/django-users/107cce9c-9795-40b9-ba74-194eb440b2bc%40googlegroups.com?utm_medium=email&utm_source=footer>.
            For more options, visit
            https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
        -- You received this message because you are subscribed to
        the Google Groups "Django users" group. To unsubscribe from
        this group and stop receiving emails from it, send an email
        to django-users+unsubscr...@googlegroups.com
        <mailto:django-users+unsubscr...@googlegroups.com>. To post
        to this group, send email to django-users@googlegroups.com
        <mailto:django-users@googlegroups.com>. Visit this group at
        https://groups.google.com/group/django-users
        <https://groups.google.com/group/django-users>.
        To view this discussion on the web visit
        
https://groups.google.com/d/msgid/django-users/CABeWMUYkPcww6AcDu4CXJ%3DDjtOe3wL%3DT1uTEFYcuSWu4oH__vQ%40mail.gmail.com
        
<https://groups.google.com/d/msgid/django-users/CABeWMUYkPcww6AcDu4CXJ%3DDjtOe3wL%3DT1uTEFYcuSWu4oH__vQ%40mail.gmail.com?utm_medium=email&utm_source=footer>.
        For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>. --
    *Jeffrey E. Uvero*

    *Amellar Solution*

    3rd Floor, LGI Building, Ortigas Avenue

    Greenhills, San Juan City,

    Philippines 1500

    *Tel:*(+63) 9776824461 <tel:%28%2B63%29%209776824461>

    *SkypeID:* jeffrey.uvero

    *Email:*j <mailto:ca...@jeonsoft.com>effreyequizuv...@gmail.com
    <mailto:effreyequizuv...@gmail.com> / jeffeuw...@gmail.com
    <mailto:jeffeuw...@gmail.com>

    -- You received this message because you are subscribed to the
    Google Groups "Django users" group. To unsubscribe from this
    group and stop receiving emails from it, send an email to
    django-users+unsubscr...@googlegroups.com
    <mailto:django-users+unsubscr...@googlegroups.com>. To post to
    this group, send email to django-users@googlegroups.com
    <mailto:django-users@googlegroups.com>. Visit this group at
    https://groups.google.com/group/django-users
    <https://groups.google.com/group/django-users>. To view this
    discussion on the web visit
    
https://groups.google.com/d/msgid/django-users/CAEtSeGvm-qos2qReYNrffLStbRiwiKFHU%3DP73A9%2BCtea14epSg%40mail.gmail.com
    
<https://groups.google.com/d/msgid/django-users/CAEtSeGvm-qos2qReYNrffLStbRiwiKFHU%3DP73A9%2BCtea14epSg%40mail.gmail.com?utm_medium=email&utm_source=footer>.
    For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
-- Jani Tiainen

    -- You received this message because you are subscribed to the
    Google Groups "Django users" group. To unsubscribe from this group
    and stop receiving emails from it, send an email to
    django-users+unsubscr...@googlegroups.com
    <mailto:django-users+unsubscr...@googlegroups.com>. To post to
    this group, send email to django-users@googlegroups.com
    <mailto:django-users@googlegroups.com>. Visit this group at
    https://groups.google.com/group/django-users
    <https://groups.google.com/group/django-users>. To view this
    discussion on the web visit
    
https://groups.google.com/d/msgid/django-users/06512cb1-5ce2-efc2-41e3-2f4142bb70f6%40gmail.com
    
<https://groups.google.com/d/msgid/django-users/06512cb1-5ce2-efc2-41e3-2f4142bb70f6%40gmail.com?utm_medium=email&utm_source=footer>.
    For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--

*Jeffrey E. Uvero*

*Amellar Solution*

3rd Floor, LGI Building, Ortigas Avenue

Greenhills, San Juan City,

Philippines 1500

*Tel:* (+63) 9776824461

*SkypeID:* jeffrey.uvero

*Email:*j <mailto:ca...@jeonsoft.com>effreyequizuv...@gmail.com <mailto:effreyequizuv...@gmail.com> / jeffeuw...@gmail.com <mailto:jeffeuw...@gmail.com>

-- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com <mailto:django-users+unsubscr...@googlegroups.com>. To post to this group, send email to django-users@googlegroups.com <mailto:django-users@googlegroups.com>. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEtSeGtzf24X66vrJF%2BQp-%2Bu4YYb5CfiiuOCi5A6whU%2B1Omk6w%40mail.gmail.com <https://groups.google.com/d/msgid/django-users/CAEtSeGtzf24X66vrJF%2BQp-%2Bu4YYb5CfiiuOCi5A6whU%2B1Omk6w%40mail.gmail.com?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout.
--
Jani Tiainen

--
You received this message because you are subscribed to the Google Groups "Django 
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/5d2c0c9a-8b2b-7810-ed8c-05e2881581f2%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to