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:

Re: 4.x code problem. (Alex McCombie 2000) 4.x code problem. (Alex McCombie 2000) Re: 4.x code problem. (Jason Tyler 2000)

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:

Help in Minneapolis (2000) PCS Frames-Default page is solution! (1997) Authenticate Checker - different versions ?? (1998) DNS Lookup 2 (2000) [OT] friday pics :-) (2005) Thanks for tips, more quest (1997) Number of cars in cart... (2004) LOOP and IF statements (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Search/sort in URL Was: GuestBook example (1997) Grouping fields problem (1998) Variables for chat (1997) [WebDNA] PayPal Instant Payment Notification Guide (2009) Req for code: upload and append to DB (2002) Serial Number Question (1997) errormessages.db (1997) Training Tapes Improved (1998) send mail problem? (1997) who are you people (1998) 2 databases problem (1997)