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> 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> > wrote: > >> Do you applied your migrations? >> >> Charly Román >> Software Developer >> http://croman.mx >> >> 2016-11-09 19:08 GMT-06:00 jeffreyequizuvero <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. 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/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 >> 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/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 <ca...@jeonsoft.com>effreyequizuv...@gmail.com / > 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+unsubscribe@ > 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/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+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/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 <ca...@jeonsoft.com>effreyequizuv...@gmail.com / 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. 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/CAEtSeGtzf24X66vrJF%2BQp-%2Bu4YYb5CfiiuOCi5A6whU%2B1Omk6w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
