Re: [web2py] Re: Getting a reproducible web2py internal error
On 17.7.2011 6:08, pbreit wrote: What sort of server are you on? Is it shared hosting or do you control your own server? Linux or Unix? In Garys first mail and last sentence Gary wrote: 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. Kenneth
Re: [web2py] Re: Getting a reproducible web2py internal error
You should probably check permissions and ACLs all the way up the directory tree to the root of the drive. It is possible to apply an ACL in an upper level directory and with a check box option cause that permission to apply recursively to the whole file tree below.
Re: [web2py] Re: Getting a reproducible web2py internal error
i'm not a sqlite junkie, so i don't know the exact syntax, but ssh in to the box and launch the sqlite interactive console, connect it to the database file created by web2py and see if you can view/update/delete records by writing raw SQL statements. perhaps the errors in the console will be more easier to understand than the web2py wrapped errors. cfh
[web2py] Re: Getting a reproducible web2py internal error
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
Re: [web2py] Re: Getting a reproducible web2py internal error
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 Herrongher...@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
