Re: 4.x code problem.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34257
interpreted = N
texte = Any chance that you're using aliases on a macintosh server? There seems tobe an issue with webcatalog 4.x opening the database multiple times for eachaliases, thus leaving some of the db's out of sync until they're flushedfrom memory. Also a problem because of the extra ram it uses to store everyinstance of the db. We're not using 4.x on the macintosh for this reason, OSX Server has always had this limitation, but the macOS version worked fineuntil 4.x.I posted to the beta list and emailed support, but haven't heard anythingyet on whether this is now the way it will be or whether this is somethingthat will get fixed and is considered a bug.-Jason Tylerwww.3ip.net> Below is code that worked like a charm with 3.0.7 but when we upgraded to> 4.0.1 today took a powder.> > Specifically this code updated 2 databases, sent an email and then> redirected to a page. In the old world as soon as the append occurred the> record was available via a standard search (on another page). As soon as we> went to 4.0.1 the _only_ way to get the search setup to see the new post is> with a flushdatabase command. (bad).> > > Now since this is MISSION critical I had to go back to 3.0.7 and testing> this under 4.x is going to be a real pain until I can get a test machine> setup for this.> > Any obvious thoughts from the tried and battle scarred 4.x testers?> > AJM> > > > > [showif [action]=Appendtask]> [replace > db=forums.db&eqMessageIDdatarq=[_tk_SKU]&append=T]messageid=[url][_tk_sku][/> url]&Forum=[LOOKUP> db=project.db&value=[P_SKU_pass]&lookInField=P_SKU&returnField=P_Sku¬Foun> d=]&PostTime=[url][Time %I:%M %p][/url]&PostDate=[url][Date> %m-%d-%Y][/url]&Name=[url][_TK_AUTHOR][/url]&Email=[url][Email][/url]&replyt> o=NewTopic&Topic=[url][_TK_Task][/url]&Message=[url][_TK_COMMENT][/url]&IPAd> dress=[IPAddress][/replace]> [commitdatabase db=forums.db]> [replace > db=task.db&eqTK_SKUdatarq=[url][_TK_SKU][/url]&append=T][formvariables> name=_&exact=F][getchars> start=2][name][/getchars]=[url][value][/url]&[/formvariables][/replace]>
Record Added> [commitdatabase db=task.db]> [SendMail to=members@newworldmedia.com&subject=New Task for [projectname]> assigned to [LOOKUP> db=staff.db&value=[_TK_Owner]&lookInField=S_SKU&returnField=S_First_Name¬> Found=] - NWM FORUMS&from=managetool@newworldmedia.com]> Forum: [ProjectName]> Task: [_TK_Task]> Owner: [LOOKUP> db=staff.db&value=[_TK_Owner]&lookInField=S_SKU&returnField=S_First_Name¬> Found=]> Author: [LOOKUP> db=staff.db&value=[_TK_Author]&lookInField=S_SKU&returnField=S_First_Name&no> tFound=]> > PostTime: [_TK_Modification_Time]> PostDate: [_TK_MODHISTORY]> Message: > -------------> [_TK_COMMENT]> -------------> [/SendMail]> [redirect forum.nmpl?forum=[_TK_projectid]&skunum=[_TK_projectid]]> [/showif]> -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Any chance that you're using aliases on a macintosh server? There seems tobe an issue with webcatalog 4.x opening the database multiple times for eachaliases, thus leaving some of the db's out of sync until they're flushedfrom memory. Also a problem because of the extra ram it uses to store everyinstance of the db. We're not using 4.x on the macintosh for this reason, OSX Server has always had this limitation, but the macOS version worked fineuntil 4.x.I posted to the beta list and emailed support, but haven't heard anythingyet on whether this is now the way it will be or whether this is somethingthat will get fixed and is considered a bug.-Jason Tylerwww.3ip.net> Below is code that worked like a charm with 3.0.7 but when we upgraded to> 4.0.1 today took a powder.> > Specifically this code updated 2 databases, sent an email and then> redirected to a page. In the old world as soon as the append occurred the> record was available via a standard search (on another page). As soon as we> went to 4.0.1 the _only_ way to get the search setup to see the new post is> with a flushdatabase command. (bad).> > > Now since this is MISSION critical I had to go back to 3.0.7 and testing> this under 4.x is going to be a real pain until I can get a test machine> setup for this.> > Any obvious thoughts from the tried and battle scarred 4.x testers?> > AJM> > > > > [showif [action]=Appendtask]> [replace > db=forums.db&eqMessageIDdatarq=[_tk_SKU]&append=T]messageid=[url][_tk_sku][/> url]&Forum=[LOOKUP> db=project.db&value=[P_SKU_pass]&lookInField=P_SKU&returnField=P_Sku¬Foun> d=]&PostTime=[url][Time %I:%M %p][/url]&PostDate=[url][Date> %m-%d-%Y][/url]&Name=[url][_TK_AUTHOR][/url]&Email=[url][Email][/url]&replyt> o=NewTopic&Topic=[url][_TK_Task][/url]&Message=[url][_TK_COMMENT][/url]&IPAd> dress=[ipaddress][/replace]> [commitdatabase db=forums.db]> [replace > db=task.db&eqTK_SKUdatarq=[url][_TK_SKU][/url]&append=T][formvariables> name=_&exact=F][getchars> start=2][name][/getchars]=[url][value][/url]&[/formvariables][/replace]> Record Added
> [commitdatabase db=task.db]> [SendMail to=members@newworldmedia.com&subject=New Task for [projectname]> assigned to [LOOKUP> db=staff.db&value=[_TK_Owner]&lookInField=S_SKU&returnField=S_First_Name¬> Found=] - NWM FORUMS&from=managetool@newworldmedia.com]> Forum: [ProjectName]> Task: [_TK_Task]> Owner: [LOOKUP> db=staff.db&value=[_TK_Owner]&lookInField=S_SKU&returnField=S_First_Name¬> Found=]> Author: [LOOKUP> db=staff.db&value=[_TK_Author]&lookInField=S_SKU&returnField=S_First_Name&no> tFound=]> > PostTime: [_TK_Modification_Time]> PostDate: [_TK_MODHISTORY]> Message: > -------------> [_TK_COMMENT]> -------------> [/SendMail]> [redirect forum.nmpl?forum=[_TK_projectid]&skunum=[_TK_projectid]]> [/showif]> -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Jason Tyler
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:
Frames and WebCat (1997)
Emailer file formats (1998)
How can I record purchases to a database? (1998)
Quiestion (1997)
Just Testing (1997)
Re1000001: Setting up shop (1997)
All choices on IE different than Netscape (1997)
Emailer help....! (1997)
OT-JS why it does not run on Mac (2001)
2 questions (2000)
format_to_days on NT (1997)
[shownext] not displaying anything but first indices found (2000)
[WriteFile] problems (1997)
LIstFiles - filnames are cart numbers. (2000)
Grep -- remove extra returns first (2003)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
[WebDNA] [OT] WebDNA Server Beta (2013)
I need hosting (2003)
RAM problems, [appendfile] problems (1998)
Funny Chars (1999)