Re: in conversions.db crashes unix webcat

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25623
interpreted = N
texte = See replies to several questions below. :-) -JohnKenneth Grome wrote:> >I just figured out... Here's what was causing webcat on Linux to crash- > > > >a template with this- > >[convertchars db=MyConversions.db][Title][/convertchars] > > > >where the title field may contain a character, depending on the record found. > > > >and the contents of 'MyConversions.db' are: > >fromto > >" > > > >If I replace that mark in the from field in that solo record with anything else, > >even an &, then it does not crash. > > > >Does this seem like normal behaviour? Could someone try it on a mac and/or NT, and > >someone also try it on unix and tell me if you get the same results. > > Where in your template are you using your convertchars context?inside a [founditems] that finds all the records in the product.db> > In the web page itself? Or inside an append or replace context?in the HTML itself to make sure any marks (and other chars when they come up later) are converted to " before being sent as source HTML.> > Or in a form field that needs to be surrounded by quotes?no, then I use [input], as you told me a while back ;-)> > How was the value added to the db in the first place?via pass-protected admin template (form), where she adds/edits all the products> > By an [append] or [replace] with [url] surrounding the value?yes, exactly; a [replace... &append=T]...title=[URL][title]...[/URL][/replace]> > Or by exporting the data from a desktop db program? > > Can post the actual code for this template? > If so, maybe someone will see an obvious solution ...Here is the template-********* [include file=FGinc-protect.txt&raw=F&groups=ADMIN] catalog listing [showif [URL][add-mod_submitted][/URL]=T] [hideif [URL][SKU][/URL]^%] [!]------------------------START WebmstrE-Note SENDMAIL------------------------------[/!] [showif [URL][AlertWebmstr][/URL]=yes] [sendmail to=[WebmstrE-Addy]&from=Geri@foo.com&Subject=[date]- Check on product# [SKU]] __________________ [WebmstrE-Note] __________________ http://www.foo.com/1test/ProductCatalog.tmpl http://www.foo.com/1test/ProductAdd-Mod.tmpl?SKU=[interpret][UnURL][SKEW][/UnURL][/interpret]&prodmod=T[/sendmail] [/showif] [!]------------------------END WebmstrE-Note SENDMAIL--------------------------------[/!] [!]------------------------START replace/append product record--------------------------------[/!] [showif [URL][add-mod_submitted][/URL]=T] [Replace db=products.db&eqSKUdatarq=[SKU]&Append=T]SKU=[SKU]&DayAdded=[DayAdded]&MainDept=[MainDept]&Title=[URL][Title][/URL]&Manufactorer=[Manufactorer]&Popularity=[Popularity]&ArticleType=[ArticleType]&RetailPrice=[RetailPrice]&price1=[price1]&price2=[price2]&price3=[price3]&price4=[price4]&price5=[price5]&price6=[price6]&price7=[price7]&price8=[price8]&WhsalePrice=[WhsalePrice]&MomsPrice=[MomsPrice]&NumInStock=[NumInStock]&ShipExpect=[URL][ShipExpect][/URL]&Material=[URL][Material][/URL]&AgeUse=[AgeUse]&SexUse=[SexUse]&hasSizes=[hasSizes]&sizeHTML=[sizeHTML]&hasColors=[hasColors]&colorHTML=[colorHTML]&Dimensions=[URL][Dimensions][/URL]&taxable=[taxable]&canEmail=[canEmail]&UnitShipCost=[UnitShipCost]&UnitShipWght=[UnitShipWght]&HasThumb1=[HasThumb1]&HasDetail1=[HasDetail1]&HasDetail2=[HasDetail2]&Thumb1Name=[Thumb1Name]&Detail1Name=[Detail1Name]&Detail2Name=[Detail2Name]&Thumb1Width=[Thumb1Width]&Thumb1Height=[Thumb1Height]&Detail1Width=[Detail1Width]&Detail1Hght=[Detail1Hght]&Detail2Width=[Detail2Width]&Detail2Hght=[Detail2Hght]&Specials=[Specials]&SpclImgName=[SpclImgName]&SpecialWidth=[SpecialWidth]&SpecialHght=[SpecialHght]&SpclAltTag=[SpclAltTag]&SpclDescript=[URL][SpclDescript][/URL]&ShortDescrip=[URL][ShortDescrip][/URL]&LongDescrip=[URL][LongDescrip][/URL]&Description3=[URL][Description3][/URL]&Category1=[Category1]&Category2=[Category2]&Category3=[Category3]&Category4=[Category4]&Category5=[Category5]&Category6=[Category6]&Category7=[Category7]&HasItemOpt1=[HasItemOpt1]&HasItemOpt2=[HasItemOpt2]&HasItemOpt3=[HasItemOpt3]&ItemOpt1HTML=[ItemOpt1HTML]&ItemOpt2HTML=[ItemOpt2HTML]&ItemOpt3HTML=[ItemOpt3HTML]&HasTestimony=[HasTestimony]&TestimonHTML=[URL][TestimonHTML][/URL]&HasWarranty=[HasWarranty]&Warranty=[URL][Warranty][/URL]&ProductNotes=[URL][ProductNotes][/URL]&NeedsWebmstr=[NeedsWebmstr]&WebmstrE-Note=[URL][WebmstrE-Note][/URL][/Replace][/showif] [!]------------------------END replace/append product record--------------------------------[/!] [/hideif] [showif [URL][SKU][/URL]^%]

Product# [URL][SKU][/URL] has an illegal character in the SKU!! (see the "%xx"? - that's the culprit.) Please use only letters, numbers, hyphens, and underscores!! (NO spaces allowed!) Please hit the back button and correct that BEFORE proceeding!

[/showif] [/showif] [!]------------------------START Browser feed--------------------------------[/!] Modified 28 Nov 4:21 pm

Create a new product[Search db=products.db&neSKUdata=NadaAmingo&SKUsort=1&max=100]

We have [numFound] products in the store now.

[foundItems] [/foundItems]
SKUDepartmentDept. CategoryItemTypeTitleUnit Ship Weight$Price1Is a Special?EditManufactorerPopularityNeeds Webmaster?NumInStock setupRemove
[sku][MainDept][Category3][ArticleType][convertchars db=MyConversions.db][Title][/convertchars][UnitShipWght] oz.$[price1][Specials]Edit[Manufactorer][Popularity][hideif [URL][NeedsWebmstr][/URL]=[URL][raw][NeedsWebmstr][/raw][/URL]] [showif [URL][NeedsWebmstr][/URL]=yes][NeedsWebmstr] [showif [URL][WebmstrE-Note][/URL]=]
??? You fergot the note ???[/showif] [showif [URL][WebmstrE-Note][/URL]=%5bWebmstrE-Note%5d]
??? You forgot the note ???[/showif] [/showif] [showif [URL][NeedsWebmstr][/URL]=no][NeedsWebmstr][/showif] [/hideif]		setup [showif [URL][hasSizes][/URL]=T][showif [URL][sizeHTML][/URL]=] Sizes?[/showif][/showif] [showif [URL][hasSizes][/URL]=F][hideif [URL][sizeHTML][/URL]=] Sizes?[/hideif][/showif] [showif [URL][hasSizes][/URL]=] Sizes?[/showif] [showif [URL][hasSizes][/URL]=[URL][raw][hasSizes][/raw][/URL]] Sizes?[/showif]
adjust [showif [URL][hasColors][/URL]=T][showif [URL][colorHTML][/URL]=] Colors?[/showif][/showif] [showif [URL][hasColors][/URL]=F][hideif [URL][colorHTML][/URL]=] Colors?[/hideif][/showif] [showif [URL][hasColors][/URL]=] Colors?[/showif] [showif [URL][hasColors][/URL]=[URL][raw][hasColors][/raw][/URL]] Colors?[/showif]		Delete
[/Search]

Create a new product

Back to switchboard

[COMMITDATABASE products.db]************ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  2. Re: in conversions.db crashes unix webcat (Anup Setty 1999)
  3. Re: in conversions.db crashes unix webcat (Anup Setty 1999)
  4. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  5. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  6. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  7. Re: in conversions.db crashes unix webcat (John Butler 1999)
  8. Re: in conversions.db crashes unix webcat (John Butler 1999)
  9. Re: in conversions.db crashes unix webcat (John Butler 1999)
  10. Re: in conversions.db crashes unix webcat (Kenneth Grome 1999)
  11. in conversions.db crashes unix webcat (John Butler 1999)
See replies to several questions below. :-) -JohnKenneth Grome wrote:> >I just figured out... Here's what was causing webcat on Linux to crash- > > > >a template with this- > >[convertchars db=MyConversions.db][Title][/convertchars] > > > >where the title field may contain a character, depending on the record found. > > > >and the contents of 'MyConversions.db' are: > >fromto > >" > > > >If I replace that mark in the from field in that solo record with anything else, > >even an &, then it does not crash. > > > >Does this seem like normal behaviour? Could someone try it on a mac and/or NT, and > >someone also try it on unix and tell me if you get the same results. > > Where in your template are you using your convertchars context?inside a [founditems] that finds all the records in the product.db> > In the web page itself? Or inside an append or replace context?in the HTML itself to make sure any marks (and other chars when they come up later) are converted to " before being sent as source HTML.> > Or in a form field that needs to be surrounded by quotes?no, then I use [input], as you told me a while back ;-)> > How was the value added to the db in the first place?via pass-protected admin template (form), where she adds/edits all the products> > By an [append] or [replace] with [url] surrounding the value?yes, exactly; a [replace... &append=T]...title=[url][title]...[/URL][/replace]> > Or by exporting the data from a desktop db program? > > Can post the actual code for this template? > If so, maybe someone will see an obvious solution ...Here is the template-********* [include file=FGinc-protect.txt&raw=F&groups=ADMIN] catalog listing [showif [url][add-mod_submitted][/URL]=T] [hideif [url][SKU][/URL]^%] [!]------------------------START WebmstrE-Note SENDMAIL------------------------------[/!] [showif [url][AlertWebmstr][/URL]=yes] [sendmail to=[WebmstrE-Addy]&from=Geri@foo.com&Subject=[date]- Check on product# [SKU]] __________________ [WebmstrE-Note] __________________ http://www.foo.com/1test/ProductCatalog.tmpl http://www.foo.com/1test/ProductAdd-Mod.tmpl?SKU=[interpret][unurl][SKEW][/UnURL][/interpret]&prodmod=T[/sendmail] [/showif] [!]------------------------END WebmstrE-Note SENDMAIL--------------------------------[/!] [!]------------------------START replace/append product record--------------------------------[/!] [showif [url][add-mod_submitted][/URL]=T] [Replace db=products.db&eqSKUdatarq=[SKU]&Append=T]SKU=[SKU]&DayAdded=[DayAdded]&MainDept=[MainDept]&Title=[url][Title][/URL]&Manufactorer=[Manufactorer]&Popularity=[Popularity]&ArticleType=[ArticleType]&RetailPrice=[RetailPrice]&price1=[price1]&price2=[price2]&price3=[price3]&price4=[price4]&price5=[price5]&price6=[price6]&price7=[price7]&price8=[price8]&WhsalePrice=[WhsalePrice]&MomsPrice=[MomsPrice]&NumInStock=[NumInStock]&ShipExpect=[url][ShipExpect][/URL]&Material=[url][Material][/URL]&AgeUse=[AgeUse]&SexUse=[SexUse]&hasSizes=[hasSizes]&sizeHTML=[sizeHTML]&hasColors=[hasColors]&colorHTML=[colorHTML]&Dimensions=[url][Dimensions][/URL]&taxable=[taxable]&canEmail=[canEmail]&UnitShipCost=[UnitShipCost]&UnitShipWght=[UnitShipWght]&HasThumb1=[HasThumb1]&HasDetail1=[HasDetail1]&HasDetail2=[HasDetail2]&Thumb1Name=[Thumb1Name]&Detail1Name=[Detail1Name]&Detail2Name=[Detail2Name]&Thumb1Width=[Thumb1Width]&Thumb1Height=[Thumb1Height]&Detail1Width=[Detail1Width]&Detail1Hght=[Detail1Hght]&Detail2Width=[Detail2Width]&Detail2Hght=[Detail2Hght]&Specials=[Specials]&SpclImgName=[SpclImgName]&SpecialWidth=[SpecialWidth]&SpecialHght=[SpecialHght]&SpclAltTag=[SpclAltTag]&SpclDescript=[url][SpclDescript][/URL]&ShortDescrip=[url][ShortDescrip][/URL]&LongDescrip=[url][LongDescrip][/URL]&Description3=[url][Description3][/URL]&Category1=[Category1]&Category2=[Category2]&Category3=[Category3]&Category4=[Category4]&Category5=[Category5]&Category6=[Category6]&Category7=[Category7]&HasItemOpt1=[HasItemOpt1]&HasItemOpt2=[HasItemOpt2]&HasItemOpt3=[HasItemOpt3]&ItemOpt1HTML=[ItemOpt1HTML]&ItemOpt2HTML=[ItemOpt2HTML]&ItemOpt3HTML=[ItemOpt3HTML]&HasTestimony=[HasTestimony]&TestimonHTML=[url][TestimonHTML][/URL]&HasWarranty=[HasWarranty]&Warranty=[url][Warranty][/URL]&ProductNotes=[url][ProductNotes][/URL]&NeedsWebmstr=[NeedsWebmstr]&WebmstrE-Note=[url][WebmstrE-Note][/URL][/Replace][/showif] [!]------------------------END replace/append product record--------------------------------[/!] [/hideif] [showif [url][SKU][/URL]^%]

Product# [url][SKU][/URL] has an illegal character in the SKU!! (see the "%xx"? - that's the culprit.) Please use only letters, numbers, hyphens, and underscores!! (NO spaces allowed!) Please hit the back button and correct that BEFORE proceeding!

[/showif] [/showif] [!]------------------------START Browser feed--------------------------------[/!] Modified 28 Nov 4:21 pm

Create a new product[Search db=products.db&neSKUdata=NadaAmingo&SKUsort=1&max=100]

We have [numFound] products in the store now.

[founditems] [/foundItems]
SKUDepartmentDept. CategoryItemTypeTitleUnit Ship Weight$Price1Is a Special?EditManufactorerPopularityNeeds Webmaster?NumInStock setupRemove
[sku][MainDept][Category3][ArticleType][convertchars db=MyConversions.db][Title][/convertchars][UnitShipWght] oz.$[price1][Specials][url][SKU][/url]&prodmod=T>Edit[Manufactorer][Popularity][hideif [url][NeedsWebmstr][/URL]=[url][raw][NeedsWebmstr][/raw][/URL]] [showif [url][NeedsWebmstr][/URL]=yes][NeedsWebmstr] [showif [url][WebmstrE-Note][/URL]=]
??? You fergot the note ???[/showif] [showif [url][WebmstrE-Note][/URL]=%5bWebmstrE-Note%5d]
??? You forgot the note ???[/showif] [/showif] [showif [url][NeedsWebmstr][/URL]=no][NeedsWebmstr][/showif] [/hideif]		[url][SKU][/url]>setup [showif [url][hasSizes][/URL]=T][showif [url][sizeHTML][/URL]=] Sizes?[/showif][/showif] [showif [url][hasSizes][/URL]=F][hideif [url][sizeHTML][/URL]=] Sizes?[/hideif][/showif] [showif [url][hasSizes][/URL]=] Sizes?[/showif] [showif [url][hasSizes][/URL]=[url][raw][hasSizes][/raw][/URL]] Sizes?[/showif]
adjust [showif [url][hasColors][/URL]=T][showif [url][colorHTML][/URL]=] Colors?[/showif][/showif] [showif [url][hasColors][/URL]=F][hideif [url][colorHTML][/URL]=] Colors?[/hideif][/showif] [showif [url][hasColors][/URL]=] Colors?[/showif] [showif [url][hasColors][/URL]=[url][raw][hasColors][/raw][/URL]] Colors?[/showif]		[url][SKU][/url]>Delete
[/Search]

Create a new product

Back to switchboard

[COMMITDATABASE products.db]************ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 John Butler

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:

webcat- multiple selection in input field (1997) [format 40s]text[/format] doesn't work (1997) Emailer setup (1997) Separate SSL Server (1997) DDE feature in webcat (1998) [sendmail] on NT? (1997) Problem (1997) [WebDNA] Putting '&search' into URL killing all search contexts (2010) Password problems with WebCat 4.01 (2000) Email encryption (1998) Can't Search field (1998) MATH PROBLEM (1997) Setting up WebCatalog with Retail Pro data (1996) OT: Unix Guru Needed (2003) Webstar 1.3.1 PPC (1997) How to search for fields with 10 or more characters? (2004) Multi-processor Mac info ... (1997) Mixed databases (1998) Passing WebCat data to SSL server (1997) Announce: WebMerchant 3.0 for Mac shipping now (1998)