ORA-00942: table or view does not exist

[jeffreyequizuvero]

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

[Charly Román]

Do you applied your migrations?

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

--
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...@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.

[Jeffrey Uvero]

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

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: jeffreyeq...@gmail.com / jeffe...@gmail.com

[Jani Tiainen]

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.

-- 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...@googlegroups.com. To post to this group, send email to django...@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.

-- 
Jani Tiainen

[Jeffrey Uvero]

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

Email: jeffreyequizuvero@gmail.com / jeffe...@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...@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.

-- 
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@googlegroups.com.
To post to this group, send email to django...@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.

For more options, visit https://groups.google.com/d/optout.

[Jani Tiainen]

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?

-- 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...@googlegroups.com. To post to this group, send email to django...@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.

-- 
Jani Tiainen

[Jeffrey Uvero]

I removed double quotes in table name but I still got the same error. 

-- 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...@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.

-- 
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@googlegroups.com.
To post to this group, send email to django...@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.

[Jani Tiainen]

Are you sure that Django is complaing about that particula model? Have you tried to debug what model table is actually missing?

You could also popup in Django IRC channel on Freenode to get more realtime debugging help and feedback.

-- 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...@googlegroups.com. To post to this group, send email to django...@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/CAEtSeGtzu9_BLEcLb5EzV22YDwfbmUtjiHv0gNU9ocTRufx_Jw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.

-- 
Jani Tiainen