Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108152
interpreted = N
texte = If the test works, it means you can write files inside your directory, =so, no permission problems (at least for this directory)I understand you use full path from your server root to link your =databases. This is most probably the problem. You should link your =databases from the file that requests access to them.About the test, your total is 33 seconds. A Mac Mini core i7 takes 20s =with "Only commit databases to disk when instructed" and 25s with ="Automatically commit databases to disk after modification"- chrisOn Jan 21, 2012, at 19:26, Palle Bo Nielsen wrote:> Hi Chris,>=20> No error messages from WebDNA and I am quite sure my paths are =correct. The only place where I could be a bit unsure is my virtual =config... anyone care to validate (code below form my =httpd-vhosts.conf)...>=20>=20> ---->=20>=20> And the results...>=20> Variables> Text Variables - Set an increasing # into a text variable 10000 times> 00:00:05> Let's do some math: sin(x), 0
00:00:00> =20> Database Manipulation> Open a database (2 fields), append 10000 records00:00:02> Now 40000 searches with [lookup]00:00:02> 10000 searches with [search]00:00:18> Delete the records00:00:06>=20> ------>=20>=20>=20>=20> NameVirtualHost *:80>=20> > ServerAdmin xxx@xxx.dk> DocumentRoot /Library/WebServer/Documents/www.macnyt.dk> ServerName macnyt.dk> ServerAlias www.macnyt.dk> DirectoryIndex index.html index.dna index.tpl default.tpl> ErrorLog /private/var/log/apache2/a.macnyt-error_log> CustomLog /private/var/log/apache2/a.macnyt-access_log common>=20> #-----------------------> > RewriteEngine on> RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L]> > #----------------------->=20> >=20> > ServerAdmin xxx@xxx.dk> DocumentRoot /Library/WebServer/Documents/b.qt.dk> ServerName qt.dk> ServerAlias b.qt.dk> DirectoryIndex index.html index.dna index.tpl> ErrorLog /private/var/log/apache2/b.qt.dk-error_log> CustomLog /private/var/log/apache2/b.qt-access_log common>=20> #-----------------------> > RewriteEngine on> RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L]> > #----------------------->=20> >=20>=20>=20>=20> On 21/01/2012, at 22.05, christophe.billiottet@webdna.us wrote:>=20>> Hi Palle! does WebDNA returns an error message? are your paths =correct? is the folder that contains your database has proper =permissions?>>=20>> Try to run this small speed test>>=20>> >>=20>> It writes a new database, appends 10,000 records and search it via =lookup and search, then deletes the records. Play with the preferences ="Only commit databases to disk when instructed" and "Automatically =commit databases to disk after modification" to see the differences.>>=20>> - chris>>=20>> On Jan 21, 2012, at 16:36, Palle Bo Nielsen wrote:>>=20>>> Ho all,>>>=20>>> I have just migrated a site from a v6.2 server to a v7 server. Until =now everything seems to work just fine and that positive.>>>=20>>> When I use ...webdna/Admin/AdminPrefs.dna and change setting within =WebDNA, the DB's are changes accordingly. But when I change any of my =own DB's with my site code nothing happens; at all !!!>>>=20>>> Could this be a misconfiguration of some kind like within the =http-vhost.conf or any where else? I am a bit puzzled and a bit tired =(read: confused).>>>=20>>> Any help or push in a right direction would be sooooo nice right =now...>>>=20>>> By the way. WebDNA databases and my own databases has the same =rights...>>>=20>>> /Palle--------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us>>> Bug Reporting: support@webdna.us>>=20>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us
Associated Messages, from the most recent to the oldest:
If the test works, it means you can write files inside your directory, =so, no permission problems (at least for this directory)I understand you use full path from your server root to link your =databases. This is most probably the problem. You should link your =databases from the file that requests access to them.About the test, your total is 33 seconds. A Mac Mini core i7 takes 20s =with "Only commit databases to disk when instructed" and 25s with ="Automatically commit databases to disk after modification"- chrisOn Jan 21, 2012, at 19:26, Palle Bo Nielsen wrote:> Hi Chris,>=20> No error messages from WebDNA and I am quite sure my paths are =correct. The only place where I could be a bit unsure is my virtual =config... anyone care to validate (code below form my =httpd-vhosts.conf)...>=20>=20> ---->=20>=20> And the results...>=20> Variables> Text Variables - Set an increasing # into a text variable 10000 times> 00:00:05> Let's do some math: sin(x), 0 00:00:00> =20> Database Manipulation> Open a database (2 fields), append 10000 records00:00:02> Now 40000 searches with [lookup]00:00:02> 10000 searches with [search]00:00:18> Delete the records00:00:06>=20> ------>=20>=20>=20>=20> NameVirtualHost *:80>=20> > ServerAdmin xxx@xxx.dk> DocumentRoot /Library/WebServer/Documents/www.macnyt.dk> ServerName macnyt.dk> ServerAlias www.macnyt.dk> DirectoryIndex index.html index.dna index.tpl default.tpl> ErrorLog /private/var/log/apache2/a.macnyt-error_log> CustomLog /private/var/log/apache2/a.macnyt-access_log common>=20> #-----------------------> > RewriteEngine on> RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L]> > #----------------------->=20> >=20> > ServerAdmin xxx@xxx.dk> DocumentRoot /Library/WebServer/Documents/b.qt.dk> ServerName qt.dk> ServerAlias b.qt.dk> DirectoryIndex index.html index.dna index.tpl> ErrorLog /private/var/log/apache2/b.qt.dk-error_log> CustomLog /private/var/log/apache2/b.qt-access_log common>=20> #-----------------------> > RewriteEngine on> RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L]> > #----------------------->=20> >=20>=20>=20>=20> On 21/01/2012, at 22.05, christophe.billiottet@webdna.us wrote:>=20>> Hi Palle! does WebDNA returns an error message? are your paths =correct? is the folder that contains your database has proper =permissions?>>=20>> Try to run this small speed test>>=20>> >>=20>> It writes a new database, appends 10,000 records and search it via =lookup and search, then deletes the records. Play with the preferences ="Only commit databases to disk when instructed" and "Automatically =commit databases to disk after modification" to see the differences.>>=20>> - chris>>=20>> On Jan 21, 2012, at 16:36, Palle Bo Nielsen wrote:>>=20>>> Ho all,>>>=20>>> I have just migrated a site from a v6.2 server to a v7 server. Until =now everything seems to work just fine and that positive.>>>=20>>> When I use ...webdna/Admin/AdminPrefs.dna and change setting within =WebDNA, the DB's are changes accordingly. But when I change any of my =own DB's with my site code nothing happens; at all !!!>>>=20>>> Could this be a misconfiguration of some kind like within the =http-vhost.conf or any where else? I am a bit puzzled and a bit tired =(read: confused).>>>=20>>> Any help or push in a right direction would be sooooo nice right =now...>>>=20>>> By the way. WebDNA databases and my own databases has the same =rights...>>>=20>>> /Palle--------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us>>> Bug Reporting: support@webdna.us>>=20>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list . To =unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us
christophe.billiottet@webdna.us
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:
[taxrate] question (1997)
Price written to db as scientific notation??? (1999)
triggers (2000)
can WC render sites out? (1997)
Remote delivery (1998)
WebCat2 - [format thousands] (1997)
[tcp connect]-dumb question? (1998)
Cumulative Shipping charge calculations - your help please. (1997)
WebCat 4.0 (2000)
Menu to select product variations (1997)
Multiple prices (1997)
Emailer again (1997)
Car Database (2002)
Sister-in-Law-Pimps beware... (2003)
Calculating multiple shipping... (1997)
[WebDNA] How to set up new hosting (2013)
Redirect (2003)
quantity limit (1998)
Another Newbie Q: template? (1999)
Bit off subject -- Faxing orders (1997)