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 to be an issue with webcatalog 4.x opening the database multiple times for each aliases, thus leaving some of the db's out of sync until they're flushed from memory. Also a problem because of the extra ram it uses to store every instance of the db. We're not using 4.x on the macintosh for this reason, OS X Server has always had this limitation, but the macOS version worked fine until 4.x.I posted to the beta list and emailed support, but haven't heard anything yet on whether this is now the way it will be or whether this is something that will get fixed and is considered a bug.-Jason Tyler www.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 to be an issue with webcatalog 4.x opening the database multiple times for each aliases, thus leaving some of the db's out of sync until they're flushed from memory. Also a problem because of the extra ram it uses to store every instance of the db. We're not using 4.x on the macintosh for this reason, OS X Server has always had this limitation, but the macOS version worked fine until 4.x.I posted to the beta list and emailed support, but haven't heard anything yet on whether this is now the way it will be or whether this is something that will get fixed and is considered a bug.-Jason Tyler www.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:
Not reading code (1997)
Security (2006)
SMSI (Scott) clues?? Bug fixes for next WebDNA release (2007)
Seattle based Webcatters? (2000)
Moving Files (2000)
(OT) Dual 2GHz G5 (2003)
select multiple (1997)
OT- OSX / OSX Server... (2004)
lookups or math? (1998)
PSC recommends what date format yr 2000??? (1997)
Two stores, one server (1998)
[WebDNA] Date error (2017)
'The List" (2006)
Cache headers - WebDNA 5 (2005)
Permission denied? (2004)
Database Options (1997)
WebCat2b15MacPlugin - showing [math] (1997)
[OT] Democratic Code (2002)
WebCat2b13MacPlugIn - More limits on [include] (1997)
formula??? (2000)