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

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.

On 14.11.2016 02:32, Jeffrey Uvero wrote:

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 <redetin@gmail.com> 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 <redetin@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 <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.
--   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-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.
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/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-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/5d2c0c9a-8b2b-7810-ed8c-05e2881581f2%40gmail.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/CAEtSeGtzu9_BLEcLb5EzV22YDwfbmUtjiHv0gNU9ocTRufx_Jw%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

Sunday, November 13, 2016

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

DatabaseError at /login/

No comments:

Post a Comment