Hi,

I had a Django1.1 project that use a legacy MySQL db.
After importing the db to oracle 11g I'm getting:
DatabaseError: ORA-01830: date format picture ends before converting
entire input string

I've found several posts and tickets but havn't found a fix.

How can I find what is the part that causing this?

Any pointers what I can do?

Traceback (most recent call last):

  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
core/servers/basehttp.py", line 279, in run
    self.result = application(self.environ, self.start_response)


  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
core/servers/basehttp.py", line 651, in __call__
    return self.application(environ, start_response)

  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
core/handlers/wsgi.py", line 245, in __call__

    response = middleware_method(request, response)

  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
contrib/sessions/middleware.py", line 36, in process_response
    request.session.save()


  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
contrib/sessions/backends/db.py", line 58, in save
    obj.save(force_insert=must_create)

  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
db/models/base.py", line 410, in save

    self.save_base(force_insert=force_insert,
force_update=force_update)

  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
db/models/base.py", line 495, in save_base
    result = manager._insert(values, return_id=update_pk)


  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
db/models/manager.py", line 177, in _insert
    return insert_query(self.model, values, **kwargs)

  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
db/models/query.py", line 1087, in insert_query

    return query.execute_sql(return_id)

  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
db/models/sql/subqueries.py", line 320, in execute_sql
    cursor = super(InsertQuery, self).execute_sql(None)


  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
db/models/sql/query.py", line 2369, in execute_sql
    cursor.execute(sql, params)

  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
db/backends/util.py", line 19, in execute

    return self.cursor.execute(sql, params)

  File "/usr/lib/python2.4/site-packages/Django-1.1.1-py2.4.egg/django/
db/backends/oracle/base.py", line 443, in execute
    raise e

DatabaseError: ORA-01830: date format picture ends before converting
entire input string

Thanks

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to