Re: [WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105180
interpreted = N
texte = I am seeing the DB error using the following code:[flushdatabases][shell]chmod 664 /var/www/html/sitename/data.db[/shell]
[listfields db=3D/var/www/html/sitename/data.db] [fieldname] [/listfields]
The file perms show up as 664. The folder all the way down are 755.This means any user should be able to get to the folder and read thedatabase. Failed even when I changed the file perms to 777. I cannotchange the folder to be that permissive.Works fine if I use just the filename to the webdna script, i.e../data.db. Seems unlikely to be a permissions issue.Any thoughts on why this doesn't work?BillOn Wed, Oct 15, 2008 at 11:12 AM, Patrick McCormick
wrote:> The first thing that comes to mind is to verify proper permissions on the> db.> Make sure that you [flushdatabases] first because changing permissions wh=en> the databases is loaded in RAM has no effect. You need to unload it, chan=ge> the permissions, then re-load it.> Pat>> On Oct 15, 2008, at 10:06 AM, Michael A. DeLorenzo wrote:>> I=92m getting the following error:>> Fields in database c:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.=db:> An unknown error occurred:> DBError> c:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.db> Database file could not be found or opened>> It happens when I use this code from the 6.0 docs:>> [ListDatabases]> Fields in database [name]:
> [ListFields db=3D[name]]> Fieldname: [FieldName]
> [/ListFields]>
> [/ListDatabases]>> The funny thing is that the code above lists the system databases perfect=ly.>> Also, this code works just fine if I want to list the fields from a> specified db:>> [ListFields db=3Doldecarriage.db]> [FieldName]
> [/ListFields]>>> Which leads me to believe there is something buggy with the [ListDatabase=s]> tag.>> Anyone else having the same problem?>>>> Michael A. DeLorenzo> Broker - Associate> General Manager> Web Master / Systems Engineer/ Network Administrator/ Graphic Designer/> Director of Advertising/ Director of Marketing/ Mr. Fix It/ Problem Solve=r/> Head of you name it I do it Department> Olde Carriage Realty, Inc.> 92 Charlotte St.> St. Augustine,=A0FL=A032084> Phone: 904-824-4500> Mobile: 904-377-5582> Fax: 904-824-6866> Toll-Free: 800-555-6138> Web:=A0www.oldecarriage.com>>>>>
Associated Messages, from the most recent to the oldest:
I am seeing the DB error using the following code:[flushdatabases][shell]chmod 664 /var/www/html/sitename/data.db[/shell] [listfields db=3D/var/www/html/sitename/data.db] [fieldname] [/listfields]
The file perms show up as 664. The folder all the way down are 755.This means any user should be able to get to the folder and read thedatabase. Failed even when I changed the file perms to 777. I cannotchange the folder to be that permissive.Works fine if I use just the filename to the webdna script, i.e../data.db. Seems unlikely to be a permissions issue.Any thoughts on why this doesn't work?BillOn Wed, Oct 15, 2008 at 11:12 AM, Patrick McCormick wrote:> The first thing that comes to mind is to verify proper permissions on the> db.> Make sure that you [flushdatabases] first because changing permissions wh=en> the databases is loaded in RAM has no effect. You need to unload it, chan=ge> the permissions, then re-load it.> Pat>> On Oct 15, 2008, at 10:06 AM, Michael A. DeLorenzo wrote:>> I=92m getting the following error:>> Fields in database c:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.=db:> An unknown error occurred:> DBError> c:\inetpub\wwwroot\oldecarriage_live\dbs\oldecarriage.db> Database file could not be found or opened>> It happens when I use this code from the 6.0 docs:>> [listdatabases]> Fields in database [name]:
> [ListFields db=3D[name]]> Fieldname: [FieldName]
> [/ListFields]>
> [/ListDatabases]>> The funny thing is that the code above lists the system databases perfect=ly.>> Also, this code works just fine if I want to list the fields from a> specified db:>> [ListFields db=3Doldecarriage.db]> [FieldName]
> [/ListFields]>>> Which leads me to believe there is something buggy with the [ListDatabase=s]> tag.>> Anyone else having the same problem?>>>> Michael A. DeLorenzo> Broker - Associate> General Manager> Web Master / Systems Engineer/ Network Administrator/ Graphic Designer/> Director of Advertising/ Director of Marketing/ Mr. Fix It/ Problem Solve=r/> Head of you name it I do it Department> Olde Carriage Realty, Inc.> 92 Charlotte St.> St. Augustine,=A0FL=A032084> Phone: 904-824-4500> Mobile: 904-377-5582> Fax: 904-824-6866> Toll-Free: 800-555-6138> Web:=A0www.oldecarriage.com>>>>>
William DeVaul
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[SearchString] usage (1997)
Server crash (1997)
Dates! (1998)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
[WebDNA] Re:BCC and/or Character limit [sendmail] (2010)
Server Jumping and Web-networking (2000)
Graphical display of sales volume (2003)
sorting question... (2001)
Emailer Error 572 (2000)
Ampersands in database fields? (1998)
Trouble with formula.db (1997)
Change Subtotal (2000)
[OT] HTML EMAIL program wanted (1999)
no global [username] or [password] displayed ... (1997)
Search returns all, not 20 (1997)
[math] show=F exists? (1997)
SiteEdit Pro Update Announcement (1997)
Encrypted links ... (2000)
Expiration of Carts (1997)
Email Spam a bit of Hell (2004)