I removed double quotes in table name but I still got the same error. On Fri, Nov 11, 2016 at 3:53 PM, Jani Tiainen <[email protected]> wrote:
> 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 <[email protected]> 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 <[email protected]> >> wrote: >> >>> Do you applied your migrations? >>> >>> Charly Román >>> Software Developer >>> http://croman.mx >>> >>> 2016-11-09 19:08 GMT-06:00 jeffreyequizuvero < >>> [email protected]>: >>> >>>> *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 >>>> [email protected]. To post to this group, send >>>> email to [email protected]. Visit this group at >>>> https://groups.google.com/group/django-users. To view this discussion >>>> on the web visit https://groups.google.com/d/ms >>>> gid/django-users/107cce9c-9795-40b9-ba74-194eb440b2bc%40goog >>>> legroups.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. >>> >>> -- 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 >>> [email protected]. To post to this group, send >>> email to [email protected]. Visit this group at >>> https://groups.google.com/group/django-users. >>> To view this discussion on the web visit https://groups.google.com/d/ms >>> gid/django-users/CABeWMUYkPcww6AcDu4CXJ%3DDjtOe3wL%3DT1uTEFY >>> cuSWu4oH__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. >>> >> -- >> >> *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 <[email protected]>[email protected] / >> [email protected] >> -- 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+unsubscribe@googl >> egroups.com. To post to this group, send email to >> [email protected]. Visit this group at >> https://groups.google.com/group/django-users. To view this discussion on >> the web visit https://groups.google.com/d/ms >> gid/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. >> >> -- >> 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+unsubscribe@googl >> egroups.com. To post to this group, send email to >> [email protected]. Visit this group at >> https://groups.google.com/group/django-users. To view this discussion on >> the web visit https://groups.google.com/d/ms >> gid/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. >> > -- > > *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 <[email protected]>[email protected] / > [email protected] > -- 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+unsubscribe@ > googlegroups.com. To post to this group, send email to > [email protected]. 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 [email protected]. > To post to this group, send email to [email protected]. > 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 > <https://groups.google.com/d/msgid/django-users/5d2c0c9a-8b2b-7810-ed8c-05e2881581f2%40gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit 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 <[email protected]>[email protected] / [email protected] -- 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 [email protected]. To post to this group, send email to [email protected]. 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/CAEtSeGtzu9_BLEcLb5EzV22YDwfbmUtjiHv0gNU9ocTRufx_Jw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
