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 = 108151
interpreted = N
texte = --Apple-Mail=_E20AFB9E-275A-4253-B63C-13D9DC41006C Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Chris, 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)... ---- And the results... Variables Text Variables - Set an increasing # into a text variable 10000 times 00:00:05 Let's do some math: sin(x), 0 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 #----------------------- RewriteEngine on RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] #----------------------- 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 #----------------------- RewriteEngine on RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] #----------------------- On 21/01/2012, at 22.05, christophe.billiottet@webdna.us wrote: > 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 --Apple-Mail=_E20AFB9E-275A-4253-B63C-13D9DC41006C Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Hi Chris,

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)...


----


And the = results...

Variables
Text Variables - Set an increasing # into a text variable 10000 = times
00:00:05
Let's do some math: sin(x), 0<x<51, 10000 = times.
00:00:00
 
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

------
=




Name= VirtualHost *:80

<VirtualHost = *:80>
    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

#-----------------------
<IfM= odule mod_rewrite.c>
RewriteEngine on
RewriteRule = .* - = [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L]
</IfModule&g= t;
#-----------------------

</Virtua= lHost>

<VirtualHost = *:80>
    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

#-----------------------
<IfM= odule mod_rewrite.c>
RewriteEngine on
RewriteRule = .* - = [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L]
</IfModule&g= t;
#-----------------------

</Virtua= lHost>




On 21/01/2012, at 22.05, christophe.billiottet@webd= na.us wrote:

Hi Palle! does WebDNA returns an error message? are = your paths correct? is the folder that contains your database has proper = permissions?

Try to run this small speed = test

<stressfull.dna>

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.

- = chris

On Jan 21, 2012, at 16:36, Palle Bo Nielsen = wrote:

Ho = all,

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.

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 !!!

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).

Any help or = push in a right direction would be sooooo nice right = now...

By the way. = WebDNA databases and my own databases has the same = rights...

/Palle------------------------------------------------------= ---
This message is sent to = you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/l= ist/talk@webdna.us
Bug = Reporting: support@webdna.us

= --Apple-Mail=_E20AFB9E-275A-4253-B63C-13D9DC41006C-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  2. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  3. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  4. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  5. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  6. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Govinda 2012)
  7. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  8. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  9. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  10. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  11. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  12. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  13. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Govinda 2012)
  14. [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
--Apple-Mail=_E20AFB9E-275A-4253-B63C-13D9DC41006C Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Chris, 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)... ---- And the results... Variables Text Variables - Set an increasing # into a text variable 10000 times 00:00:05 Let's do some math: sin(x), 0[lookup]00:00:02 10000 searches with [search]00:00:18 Delete the records00:00:06 ------ NameVirtualHost *:80 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 #----------------------- RewriteEngine on RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] #----------------------- 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 #----------------------- RewriteEngine on RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] #----------------------- On 21/01/2012, at 22.05, christophe.billiottet@webdna.us wrote: > 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 --Apple-Mail=_E20AFB9E-275A-4253-B63C-13D9DC41006C Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Hi Chris,

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)...


----


And the = results...

Variables
Text Variables - Set an increasing # into a text variable 10000 = times
00:00:05
Let's do some math: sin(x), 0<x<51, 10000 = times.
00:00:00
 
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

------
=




Name= VirtualHost *:80

<VirtualHost = *:80>
    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

#-----------------------
<IfM= odule mod_rewrite.c>
RewriteEngine on
RewriteRule = .* - = [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L]
</IfModule&g= t;
#-----------------------

</Virtua= lHost>

<VirtualHost = *:80>
    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

#-----------------------
<IfM= odule mod_rewrite.c>
RewriteEngine on
RewriteRule = .* - = [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L]
</IfModule&g= t;
#-----------------------

</Virtua= lHost>




On 21/01/2012, at 22.05, christophe.billiottet@webd= na.us wrote:

Hi Palle! does WebDNA returns an error message? are = your paths correct? is the folder that contains your database has proper = permissions?

Try to run this small speed = test

<stressfull.dna>

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.

- = chris

On Jan 21, 2012, at 16:36, Palle Bo Nielsen = wrote:

Ho = all,

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.

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 !!!

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).

Any help or = push in a right direction would be sooooo nice right = now...

By the way. = WebDNA databases and my own databases has the same = rights...

/Palle------------------------------------------------------= ---
This message is sent to = you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/l= ist/talk@webdna.us
Bug = Reporting: support@webdna.us

= --Apple-Mail=_E20AFB9E-275A-4253-B63C-13D9DC41006C-- Palle Bo Nielsen

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:

Quickie question on the email templates (1997) [ShowIf] and empty fields (1997) writefiles (1999) Proper file locations (1997) Re:Emailer setup (1997) Auto conversion of URLs? (1998) First postarg not taking in $Commands (1997) FIXED: Showing Results Alphabetically in Columns (top tobottom) (2002) [OT] Bookmarking code (2003) autocommit problem (1998) More on [purchase] (1998) French characters in variables (2001) How to delete all files in a folder? (2001) FlushDatabase Suggestion (1998) Pager notification of completed orders (1998) Multiple Merchant Accounts? (1997) Strange intermittent WebDNA problems (2008) Upload and WebCat (1998) Location of Browser Info.txt file (1997) WebCat b13 CGI -shownext- (1997)