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:

using WC to create a DB online (2000) [WebDNA] Convertchars Weirdness (2014) Search in 2 or more catalogs (1997) Serving images from databases (1998) Fwd: search engine friendly URLS (Mac) (1998) Include a big block of text (1997) Close Databases Crash? (1998) WCS Newbie question (1997) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Triggers (2003) Cart # Starting at 1000 (2000) GREP for search - not replace (2004) variables in [addlineitem] (1998) WebDNA Expert Tools ... (2000) Setting up WebCatalog with Retail Pro data (1996) empty shopping cart message (1997) [searchString] (1997) Encyption mail was Suggestions for Topics ... (1998) Nav. 4 probs with cart - Serious problem (1997) searching multiple databases (1997)