Django talk: Re: ORA-00942: table or view does not exist

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 <chack14rock@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 <jeffreyequizuvero@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+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/107cce9c-9795-40b9-ba74-194eb440b2bc%40googlegroups.com. 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@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/CABeWMUYkPcww6AcDu4CXJ%3DDjtOe3wL%3DT1uTEFYcuSWu4oH__vQ%40mail.gmail.com.
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 effreyequizuvero@gmail.com / jeffeuwork@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. For more options, visit https://groups.google.com/d/optout.

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"'

--   Jani Tiainen

Django talk

Thursday, November 10, 2016

Re: ORA-00942: table or view does not exist

DatabaseError at /login/

No comments:

Post a Comment