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%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. >> >> -- 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/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. >> > -- > > *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/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 [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/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 [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/CAEtSeGtzf24X66vrJF%2BQp-%2Bu4YYb5CfiiuOCi5A6whU%2B1Omk6w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
