Re: [WebDNA] Error 500 with SUMM=T

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113813
interpreted = N
texte = 1408 --089e082da2ccc162e0056022bcd4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable remember years ago came to this talklist and had dir=3D and looked at that string 100 times and found out I missed the "s" sdir=3D minimize the search to the most basic, once working build it up... temp.db&neemaildata=3D[BLANK]&max=3D5] [showif [numfound]>0]Yahooo![/Show= if][ /search] On Tue, Dec 12, 2017 at 10:59 AM, Brian Harrington wrote: > sorry... removed the summ but not the field name... below correct > > > > temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&max=3D10][sh= owif > [numfound]>0]Yahooo![/Showif][/search] > > On Tue, Dec 12, 2017 at 10:57 AM, Brian Harrington > wrote: > >> 12 years doing webdna never used a "FIND_ALL" but the first thing I >> would do is remove the summ, then re tab the database... do a copy, re >> paste on the tabs in the header! >> >> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email&max= =3D10][showif >> [numfound]>0]Yahooo![/Showif][/search] >> >> On Tue, Dec 12, 2017 at 10:47 AM, Brian Harrington < >> autoglasswny@gmail.com> wrote: >> >>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM= =3DT&max=3D10][showif >>> [numfound]>0]Yahooo![/Showif][/search] >>> >>> On Tue, Dec 12, 2017 at 10:44 AM, Brian Harrington < >>> autoglasswny@gmail.com> wrote: >>> >>>> add a max to see if u get a hit... >>>> >>>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email >>>> SUMM=3DT&max=3D10] >>>> >>>> On Tue, Dec 12, 2017 at 10:42 AM, Brian Harrington < >>>> autoglasswny@gmail.com> wrote: >>>> >>>>> also... why sort=3D1 but then no order? >>>>> >>>>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUM= M=3DT] >>>>> >>>>> On Tue, Dec 12, 2017 at 10:38 AM, Brian Harrington < >>>>> autoglasswny@gmail.com> wrote: >>>>> >>>>>> emp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailSUMM=3DT] >>>>>> >>>>>> >>>>>> On Tue, Dec 12, 2017 at 10:34 AM, Brian Harrington < >>>>>> autoglasswny@gmail.com> wrote: >>>>>> >>>>>>> have been following briefly but why the "NE_" ??? >>>>>>> >>>>>>> On Tue, Dec 12, 2017 at 8:00 AM, >>>>>>> wrote: >>>>>>> >>>>>>>> Just curiosity=E2=80=A6 try [search db=3Dbases/_temp.db&ne_emailda= ta >>>>>>>> =3DFIND_ALL&_emailSORT=3D1&_emailSUMM=3DT] >>>>>>>> >>>>>>>> - chris >>>>>>>> >>>>>>>> On Dec 12, 2017, at 10:39, Lawrence Banahan >>>>>>>> wrote: >>>>>>>> >>>>>>>> Hi Brian, tht's what I did with remove code down and down until I >>>>>>>> arrived to this issuu, and there are only one column of email data= .... >>>>>>>> The script was working perfectly for 3 years befor switching to 8.= 5 >>>>>>>> >>>>>>>> >>>>>>>> 2017-12-12 8:37 GMT+01:00 Lawrence Banahan : >>>>>>>> >>>>>>>>> My first thought... 5000000 it should be good lol >>>>>>>>> even it shouldn't create a server error... >>>>>>>>> >>>>>>>>> 2017-12-12 0:56 GMT+01:00 Stuart Tremain : >>>>>>>>> >>>>>>>>>> Have you set the *maximum found items* in WebDNA to accomodate >>>>>>>>>> your expected results ? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Kind regards >>>>>>>>>> >>>>>>>>>> Stuart Tremain >>>>>>>>>> Pharoah Lane Software >>>>>>>>>> AUSTRALIA >>>>>>>>>> webdna@idfk.com.au >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On 12 Dec 2017, at 02:10, Lawrence Banahan >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> Since I upgraded to WDna8.5 I have a strange situation. >>>>>>>>>> >>>>>>>>>> I make a search through a db that have about 15 000 entries >>>>>>>>>> >>>>>>>>>> This line works >>>>>>>>>> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL] Total emai= ls >>>>>>>>>> avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text show=3Dt]= nb-av=3D[numfound][/text] >>>>>>>>>> [/search] >>>>>>>>>> >>>>>>>>>> This one makes me a Error 500 >>>>>>>>>> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL&_emailSUMM= =3DT] >>>>>>>>>> Total emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[= text >>>>>>>>>> show=3Dt]nb-av=3D[numfound][/text][/search] >>>>>>>>>> >>>>>>>>>> "Internal Server Error >>>>>>>>>> The server encountered an internal error or misconfiguration and >>>>>>>>>> was unable to complete your request." >>>>>>>>>> >>>>>>>>>> I haven't purchase a licence for 8.5 is that the reason? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Thanks >>>>>>>>>> Lawrence >>>>>>>>>> --------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reportin= g: >>>>>>>>>> support@webdna.us >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> --------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reportin= g: >>>>>>>>>> support@webdna.us >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> --------------------------------------------------------- This >>>>>>>> message is sent to you because you are subscribed to the mailing l= ist >>>>>>>> talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us >>>>>>>> archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: >>>>>>>> support@webdna.us >>>>>>>> >>>>>>>> >>>>>>>> --------------------------------------------------------- This >>>>>>>> message is sent to you because you are subscribed to the mailing l= ist >>>>>>>> talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us >>>>>>>> archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: >>>>>>>> support@webdna.us >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> > --089e082da2ccc162e0056022bcd4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
remember years ago came to this talklist and had dir=3D an= d looked at that string 100 times and found out I missed the "s" = sdir=3D

minimize the search to the most basic, once work= ing build it up...

temp.db&neemaildata=3D[BLANK]&max=3D5] =C2=A0=C2=A0[showif [numfound]>0]Yahooo![/= Showif][/search]

On Tue, Dec 12, 2017 a= t 10:59 AM, Brian Harrington <autoglasswny@gmail.com> w= rote:
sorry... removed t= he summ but not the field name... below correct



temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&= ;emailsdir=3Das&max=3D10][showif [numfound]>0]Yahooo![/Showif][= /search]

On Tue, Dec 12, = 2017 at 10:57 AM, Brian Harrington <autoglasswny@gmail.com> wrote:
12 years doi= ng webdna never used a "FIND_ALL" but the first thing I would do is remove the summ, then = re tab the database... do a copy, re paste on the tabs in the header!

temp.db&neemaildatarq=3D[BLANK]&= emailSORT=3D1= &emailsdir=3Das&email&max=3D10][showif [numfound]>0]Yah= ooo![/Showif][/search]
=

On Tue, Dec 12, 2017 at 10:47 AM, Brian Harrington <autoglasswny@gmail.com> wrote:
temp.db&neema= ildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT&max= =3D10][showif [numfound]>0]Yahooo![/Showif][/search]

On Tue, Dec 12, 2017 at 10:44 AM, Brian H= arrington <autoglasswny@gmail.com> wrote:
add a max to see if u get a hit...
temp.db&= amp;neemaildatarq= =3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT&max=3D10]

On Tue, Dec 12, 2017 at 10:42 AM, Brian Harrington <autoglasswny@gmail.com> wrote:
also... why sort=3D1 but then no order?

temp.db&neemaildatarq=3D[BLANK]= &emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT]

On Tue, Dec 12, 2017 at 10:38 AM, = Brian Harrington <autoglasswny@gmail.com> wrote:
emp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailSUMM=3DT]

<= div class=3D"m_2661154935313327431m_2138688216279191240m_-62407708743711108= 06m_-7824140254676505453m_752876735546011180HOEnZb">

On Tue, Dec 12, 2017 at 10:34 AM, Brian Harrington <autoglas= swny@gmail.com> wrote:
have been following briefly but why the "NE_" ???
<= div class=3D"gmail_extra">
On Tue, Dec 12, 20= 17 at 8:00 AM, <christophe.billiottet@webdna.us>= ; wrote:
Just curiosity=E2=80=A6 try=C2=A0[s= earch db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL&_emailSORT= =3D1&_emailSUMM=3DT]

- chris

On Dec 12, 2017, at 10:39, Lawrence Banahan = <banahan.l@gmai= l.com> wrote:

Hi Brian, tht's wha= t I did with remove code down and down until I arrived to this issuu, and t= here are only one column of email data...
The script was working = perfectly for 3 years befor switching to 8.5


2017-12-12 8:37 GMT+0= 1:00 Lawrence Banahan <banahan.l@gmail.com>:
My first thought...= 5000000 it should be good lol
even it shouldn't create a serv= er error...

2017-12-12 0:56 GMT+01:00 Stuart Tremain <webdna= @idfk.com.au>:
Have you = set the maximum found items in WebDNA to ac= comodate your expected results ?



<Screen Shot 2017-12-12 at 10.55.02.png>



Kind regards

Stua= rt Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au



<= /div>


On 12 Dec 2017, at 02:10, Lawrence Banahan &= lt;banahan.l@gmail= ..com> wrote:

Hi,
Since I upgraded to WDna8.5 = I have a strange situation.

I make a search through a db that = have about 15 000 entries

This line works
[search db=3Dbases/_tem= p.db&ne_emaildata=3DFIND_ALL] Total=C2=A0 emails avant suppr=C3=A9= ssion des d=C3=A9inscriptions=3D[text show=3Dt]nb-av=3D[numfound][/text][/search]

This one makes me a Error 500
[search db=3Dbase= s/_temp.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] Total=C2=A0= emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text show=3Dt]nb-= av=3D[numfound][/text][/search]

"Interna= l Server Error
The server encountered an internal error or mi= sconfiguration and was unable to complete your request."

I haven't purchase a licence for 8.5 is that the reason?
=

Thanks
Lawrence
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us








--------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --089e082da2ccc162e0056022bcd4-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  2. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  3. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  4. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  5. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  6. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  7. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  8. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  9. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  10. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  11. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  12. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  13. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  14. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  15. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  16. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  17. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  18. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  19. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  20. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  21. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  22. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  23. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  24. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  25. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  26. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  27. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  28. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  29. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  30. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  31. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  32. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  33. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  34. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  35. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  36. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  37. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  38. [BULK] Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  39. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  40. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  41. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  42. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  43. Re: [WebDNA] Error 500 with SUMM=T ("Lawrence Banahan - Author's Image" 2017)
  44. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  45. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  46. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  47. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  48. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  49. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  50. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  51. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  52. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  53. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  54. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  55. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  56. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  57. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  58. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  59. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  60. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  61. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  62. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  63. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  64. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  65. Re: [WebDNA] Error 500 with SUMM=T (christophe.billiottet@webdna.us 2017)
  66. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  67. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  68. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  69. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  70. [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
1408 --089e082da2ccc162e0056022bcd4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable remember years ago came to this talklist and had dir=3D and looked at that string 100 times and found out I missed the "s" sdir=3D minimize the search to the most basic, once working build it up... temp.db&neemaildata=3D[BLANK]&max=3D5] [showif [numfound]>0]Yahooo![/Show= if][ /search] On Tue, Dec 12, 2017 at 10:59 AM, Brian Harrington wrote: > sorry... removed the summ but not the field name... below correct > > > > temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&max=3D10][sh= owif > [numfound]>0]Yahooo![/Showif][/search] > > On Tue, Dec 12, 2017 at 10:57 AM, Brian Harrington > wrote: > >> 12 years doing webdna never used a "FIND_ALL" but the first thing I >> would do is remove the summ, then re tab the database... do a copy, re >> paste on the tabs in the header! >> >> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email&max= =3D10][showif >> [numfound]>0]Yahooo![/Showif][/search] >> >> On Tue, Dec 12, 2017 at 10:47 AM, Brian Harrington < >> autoglasswny@gmail.com> wrote: >> >>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM= =3DT&max=3D10][showif >>> [numfound]>0]Yahooo![/Showif][/search] >>> >>> On Tue, Dec 12, 2017 at 10:44 AM, Brian Harrington < >>> autoglasswny@gmail.com> wrote: >>> >>>> add a max to see if u get a hit... >>>> >>>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&email >>>> SUMM=3DT&max=3D10] >>>> >>>> On Tue, Dec 12, 2017 at 10:42 AM, Brian Harrington < >>>> autoglasswny@gmail.com> wrote: >>>> >>>>> also... why sort=3D1 but then no order? >>>>> >>>>> temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUM= M=3DT] >>>>> >>>>> On Tue, Dec 12, 2017 at 10:38 AM, Brian Harrington < >>>>> autoglasswny@gmail.com> wrote: >>>>> >>>>>> emp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailSUMM=3DT] >>>>>> >>>>>> >>>>>> On Tue, Dec 12, 2017 at 10:34 AM, Brian Harrington < >>>>>> autoglasswny@gmail.com> wrote: >>>>>> >>>>>>> have been following briefly but why the "NE_" ??? >>>>>>> >>>>>>> On Tue, Dec 12, 2017 at 8:00 AM, >>>>>>> wrote: >>>>>>> >>>>>>>> Just curiosity=E2=80=A6 try [search db=3Dbases/_temp.db&ne_emailda= ta >>>>>>>> =3DFIND_ALL&_emailSORT=3D1&_emailSUMM=3DT] >>>>>>>> >>>>>>>> - chris >>>>>>>> >>>>>>>> On Dec 12, 2017, at 10:39, Lawrence Banahan >>>>>>>> wrote: >>>>>>>> >>>>>>>> Hi Brian, tht's what I did with remove code down and down until I >>>>>>>> arrived to this issuu, and there are only one column of email data= .... >>>>>>>> The script was working perfectly for 3 years befor switching to 8.= 5 >>>>>>>> >>>>>>>> >>>>>>>> 2017-12-12 8:37 GMT+01:00 Lawrence Banahan : >>>>>>>> >>>>>>>>> My first thought... 5000000 it should be good lol >>>>>>>>> even it shouldn't create a server error... >>>>>>>>> >>>>>>>>> 2017-12-12 0:56 GMT+01:00 Stuart Tremain : >>>>>>>>> >>>>>>>>>> Have you set the *maximum found items* in WebDNA to accomodate >>>>>>>>>> your expected results ? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Kind regards >>>>>>>>>> >>>>>>>>>> Stuart Tremain >>>>>>>>>> Pharoah Lane Software >>>>>>>>>> AUSTRALIA >>>>>>>>>> webdna@idfk.com.au >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On 12 Dec 2017, at 02:10, Lawrence Banahan >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> Since I upgraded to WDna8.5 I have a strange situation. >>>>>>>>>> >>>>>>>>>> I make a search through a db that have about 15 000 entries >>>>>>>>>> >>>>>>>>>> This line works >>>>>>>>>> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL] Total emai= ls >>>>>>>>>> avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text show=3Dt]= nb-av=3D[numfound][/text] >>>>>>>>>> [/search] >>>>>>>>>> >>>>>>>>>> This one makes me a Error 500 >>>>>>>>>> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL&_emailSUMM= =3DT] >>>>>>>>>> Total emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[= text >>>>>>>>>> show=3Dt]nb-av=3D[numfound][/text][/search] >>>>>>>>>> >>>>>>>>>> "Internal Server Error >>>>>>>>>> The server encountered an internal error or misconfiguration and >>>>>>>>>> was unable to complete your request." >>>>>>>>>> >>>>>>>>>> I haven't purchase a licence for 8.5 is that the reason? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Thanks >>>>>>>>>> Lawrence >>>>>>>>>> --------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reportin= g: >>>>>>>>>> support@webdna.us >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> --------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reportin= g: >>>>>>>>>> support@webdna.us >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> --------------------------------------------------------- This >>>>>>>> message is sent to you because you are subscribed to the mailing l= ist >>>>>>>> talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us >>>>>>>> archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: >>>>>>>> support@webdna.us >>>>>>>> >>>>>>>> >>>>>>>> --------------------------------------------------------- This >>>>>>>> message is sent to you because you are subscribed to the mailing l= ist >>>>>>>> talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us >>>>>>>> archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: >>>>>>>> support@webdna.us >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> > --089e082da2ccc162e0056022bcd4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
remember years ago came to this talklist and had dir=3D an= d looked at that string 100 times and found out I missed the "s" = sdir=3D

minimize the search to the most basic, once work= ing build it up...

temp.db&neemaildata=3D[BLANK]&max=3D5] =C2=A0=C2=A0[showif [numfound]>0]Yahooo![/= Showif][/search]

On Tue, Dec 12, 2017 a= t 10:59 AM, Brian Harrington <autoglasswny@gmail.com> w= rote:
sorry... removed t= he summ but not the field name... below correct



temp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&= ;emailsdir=3Das&max=3D10][showif [numfound]>0]Yahooo![/Showif][= /search]

On Tue, Dec 12, = 2017 at 10:57 AM, Brian Harrington <autoglasswny@gmail.com> wrote:
12 years doi= ng webdna never used a "FIND_ALL" but the first thing I would do is remove the summ, then = re tab the database... do a copy, re paste on the tabs in the header!

temp.db&neemaildatarq=3D[BLANK]&= emailSORT=3D1= &emailsdir=3Das&email&max=3D10][showif [numfound]>0]Yah= ooo![/Showif][/search]
=

On Tue, Dec 12, 2017 at 10:47 AM, Brian Harrington <autoglasswny@gmail.com> wrote:
temp.db&neema= ildatarq=3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT&max= =3D10][showif [numfound]>0]Yahooo![/Showif][/search]

On Tue, Dec 12, 2017 at 10:44 AM, Brian H= arrington <autoglasswny@gmail.com> wrote:
add a max to see if u get a hit...
temp.db&= amp;neemaildatarq= =3D[BLANK]&emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT&max=3D10]

On Tue, Dec 12, 2017 at 10:42 AM, Brian Harrington <autoglasswny@gmail.com> wrote:
also... why sort=3D1 but then no order?

temp.db&neemaildatarq=3D[BLANK]= &emailSORT=3D1&emailsdir=3Das&emailSUMM=3DT]

On Tue, Dec 12, 2017 at 10:38 AM, = Brian Harrington <autoglasswny@gmail.com> wrote:
emp.db&neemaildatarq=3D[BLANK]&emailSORT=3D1&emailSUMM=3DT]

<= div class=3D"m_2661154935313327431m_2138688216279191240m_-62407708743711108= 06m_-7824140254676505453m_752876735546011180HOEnZb">

On Tue, Dec 12, 2017 at 10:34 AM, Brian Harrington <autoglas= swny@gmail.com> wrote:
have been following briefly but why the "NE_" ???
<= div class=3D"gmail_extra">
On Tue, Dec 12, 20= 17 at 8:00 AM, <christophe.billiottet@webdna.us>= ; wrote:
Just curiosity=E2=80=A6 try=C2=A0[s= earch db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL&_emailSORT= =3D1&_emailSUMM=3DT]

- chris

On Dec 12, 2017, at 10:39, Lawrence Banahan = <banahan.l@gmai= l.com> wrote:

Hi Brian, tht's wha= t I did with remove code down and down until I arrived to this issuu, and t= here are only one column of email data...
The script was working = perfectly for 3 years befor switching to 8.5


2017-12-12 8:37 GMT+0= 1:00 Lawrence Banahan <banahan.l@gmail.com>:
My first thought...= 5000000 it should be good lol
even it shouldn't create a serv= er error...

2017-12-12 0:56 GMT+01:00 Stuart Tremain <webdna= @idfk.com.au>:
Have you = set the maximum found items in WebDNA to ac= comodate your expected results ?



<Screen Shot 2017-12-12 at 10.55.02.png>



Kind regards

Stua= rt Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au



<= /div>


On 12 Dec 2017, at 02:10, Lawrence Banahan &= lt;banahan.l@gmail= ..com> wrote:

Hi,
Since I upgraded to WDna8.5 = I have a strange situation.

I make a search through a db that = have about 15 000 entries

This line works
[search db=3Dbases/_tem= p.db&ne_emaildata=3DFIND_ALL] Total=C2=A0 emails avant suppr=C3=A9= ssion des d=C3=A9inscriptions=3D[text show=3Dt]nb-av=3D[numfound][/text][/search]

This one makes me a Error 500
[search db=3Dbase= s/_temp.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] Total=C2=A0= emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text show=3Dt]nb-= av=3D[numfound][/text][/search]

"Interna= l Server Error
The server encountered an internal error or mi= sconfiguration and was unable to complete your request."

I haven't purchase a licence for 8.5 is that the reason?
=

Thanks
Lawrence
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us








--------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --089e082da2ccc162e0056022bcd4-- . Brian Harrington

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:

Donovans Theorem (2003) SiteEdit Pro Update Announcement (1997) Running _every_ page through WebCat-error.html (1997) Corruption in images (2004) multi-paragraph fields (1997) Two prices in shoppingcart? (1997) Loss in Form (1998) browser info.txt and SSL (1997) Great product and great job ! (1997) Help! WebCat2 bug (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) WebCat2b15MacPlugin - showing [math] (1997) [lookup] speed sales pitch (2003) [WebDNA] CORRECTION: 60% failure rate using replace in a loop (2010) Browser Info.txt (1997) WCS Newbie question (1997) Image size & weight limit on upload (2002) SMSI -- a [notfound] context? (2002) (1998) Still More on EudoraPro Email (1998)