Re: OperationalError: unable to open database file, when saving existing object

[pigmalione]

For what it's worth, I found some kind of solution.

Apparently, running under a user administrator account in Windows
causes this kind of permissioning issue. If I enable the windows
hidden administrator and work under that account, this issue
disappears. A bit annoying.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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
-~--~~~~--~~--~--~---

Re: OperationalError: unable to open database file, when saving existing object

[pigmalione]

Hi, Wim -
Thanks a lot for the reply.

I'm doing everything through code, since accessing the admin interface
is itself plagued with issues. And as far as I can tell, I am the same
user as the owner of the db-file (since I can also change privileges
on the file at will).

These are some more symptoms:
- when I issue "python manage.py createsuperuser" to create a
superuser I get an "unable to open database file" error again, still
the user is created on the db. However, it's created with attribute
is_superuser set to false.
- I can import objects from the db, delete objects from the db and
save new objects through the django python shell without a single
issue. Still if I import one of the saved objects, attempt to amend it
and then save() again, I get an error similar to the one above.

I'm not sure how to proceed. I've since come across some remedies on
the web which haven't proven very successful.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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
-~--~~~~--~~--~--~---

Re: OperationalError: unable to open database file, when saving existing object

[Wim Feijen]

So, if I understand correctly, creating new objects and saving them to
the database works correctly, and updating objects fails. Is that
correct? Is it an update from the admin interface or from code written
by you?

If the former, it might have something to do with db privileges. Which
back-end are you using, sqlite? In that case, are you running the
project while being the same user as the owner of the sqlite db-file?
If the back-end is another database, did you edit and modify write
privileges?

Wim


On Sep 27, 3:28 pm, pigmalione  wrote:
> Hello,
>
> When I attempt to save an existing db object I get the following
> error:
>
>   File "", line 1, in 
>   File "/usr/lib/python2.5/site-packages/django/db/models/base.py",
> line 410, in
>  save
>     self.save_base(force_insert=force_insert,
> force_update=force_update)
>   File "/usr/lib/python2.5/site-packages/django/db/models/base.py",
> line 474, in
>  save_base
>     rows = manager.filter(pk=pk_val)._update(values)
>   File "/usr/lib/python2.5/site-packages/django/db/models/query.py",
> line 444, i
> n _update
>     return query.execute_sql(None)
>   File "/usr/lib/python2.5/site-packages/django/db/models/sql/
> subqueries.py", li
> ne 120, in execute_sql
>     cursor = super(UpdateQuery, self).execute_sql(result_type)
>   File "/usr/lib/python2.5/site-packages/django/db/models/sql/
> query.py", line 23
> 69, in execute_sql
>     cursor.execute(sql, params)
>   File "/usr/lib/python2.5/site-packages/django/db/backends/util.py",
> line 19, i
> n execute
>     return self.cursor.execute(sql, params)
>   File "/usr/lib/python2.5/site-packages/django/db/backends/sqlite3/
> base.py", li
> ne 193, in execute
>     return Database.Cursor.execute(self, query, params)
> OperationalError: unable to open database file
>
> I can keep saving new objects, but once I edit an attribute and
> attempt to save, I get the above message.
>
> Can someone suggest something?
>
> Thanks a lot.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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
-~--~~~~--~~--~--~---

OperationalError: unable to open database file, when saving existing object

[pigmalione]

Hello,

When I attempt to save an existing db object I get the following
error:

  File "", line 1, in 
  File "/usr/lib/python2.5/site-packages/django/db/models/base.py",
line 410, in
 save
self.save_base(force_insert=force_insert,
force_update=force_update)
  File "/usr/lib/python2.5/site-packages/django/db/models/base.py",
line 474, in
 save_base
rows = manager.filter(pk=pk_val)._update(values)
  File "/usr/lib/python2.5/site-packages/django/db/models/query.py",
line 444, i
n _update
return query.execute_sql(None)
  File "/usr/lib/python2.5/site-packages/django/db/models/sql/
subqueries.py", li
ne 120, in execute_sql
cursor = super(UpdateQuery, self).execute_sql(result_type)
  File "/usr/lib/python2.5/site-packages/django/db/models/sql/
query.py", line 23
69, in execute_sql
cursor.execute(sql, params)
  File "/usr/lib/python2.5/site-packages/django/db/backends/util.py",
line 19, i
n execute
return self.cursor.execute(sql, params)
  File "/usr/lib/python2.5/site-packages/django/db/backends/sqlite3/
base.py", li
ne 193, in execute
return Database.Cursor.execute(self, query, params)
OperationalError: unable to open database file

I can keep saving new objects, but once I edit an attribute and
attempt to save, I get the above message.

Can someone suggest something?

Thanks a lot.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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
-~--~~~~--~~--~--~---