Yes, I am using sqlite. And I'm using web2py straight out of the box
(so to speak) -- just a straight download and unzip. And the problem is
more pervasive then originally mentioned: Any attempt to insert a
record into any table that has a reference Field results in the
error. I've checked all the file permissions as created by the unzip
and I've also explicitly set all the file permissions, but either way, I
get the same behavior.
I'm beginning to suspect that it's the machine's problem (virtual
machine, since it's in the cloud) and not web2py or even the database.
Is there an easy way, outside of web2py to test the database for correct
functioning?
On 07/15/2011 03:00 PM, Massimo Di Pierro wrote:
OperationalErrors originate from database, not web2py. Are you using
sqlite? It could be a file permission issue.
On Jul 15, 12:23 pm, Gary Herron<gher...@digipen.edu> wrote:
Has anyone seen this error, or know what it means? Any advice,
workaround or solution would be greatly appreciated.
On a machine (somewhere in the cloud), I'm trying to get a small web2py
site working and I'm running into a persistent reproducible bug that's
killing me.
The error I get is:
OperationalError: unable to open database file
This eventually occurs on any application I try to create, but I've been
able to reproduce it several times with the following set of actions:
Download a fresh copy of web2py for windows, extract, and run
Create a new application named test
In test's admin interface create two auth_user's and one auth_group
Attempt to create a auth_membership -- instead of the form I get the
above error.
The system I'm running on is a Microsoft Windows Server 2003 R2
On both a Linux/Ubuntu and a Windows XP machine everything works well.
Thanks for any help
--
Gary Herron, PhD.
Department of Computer Science
DigiPen Institute of Technology
(425) 895-4418
--
Gary Herron, PhD.
Department of Computer Science
DigiPen Institute of Technology
(425) 895-4418