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]
<mailto:[email protected]>> wrote:
Do you applied your migrations?
Charly Román
Software Developer
http://croman.mx <http://croman.mx/>
2016-11-09 19:08 GMT-06:00 jeffreyequizuvero
<[email protected] <mailto:[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]
<mailto:[email protected]>. To post to
this group, send email to [email protected]
<mailto:[email protected]>. Visit this group at
https://groups.google.com/group/django-users
<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
<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
<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
[email protected]
<mailto:[email protected]>. To post to
this group, send email to [email protected]
<mailto:[email protected]>. Visit this group at
https://groups.google.com/group/django-users
<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
<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
<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 <mailto:[email protected]>[email protected]
<mailto:[email protected]> / [email protected]
<mailto:[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]
<mailto:[email protected]>. To post to this
group, send email to [email protected]
<mailto:[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.
For more options, visit https://groups.google.com/d/optout.
