Re: [WebDNA] Error 500 with SUMM=T

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113793
interpreted = N
texte = 1388 --Apple-Mail=_90D0FFCA-5F57-43E7-9182-54927FC27F70 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 The =E2=80=9Cmaximum found items=E2=80=9D preference only effects the = search COMMAND (which nobody should be using), not the search CONTEXT, = so it has no bearing here. That said, in my simple testing I have not been able to recreate the = problem. Perhaps there is some particular data in the database that = WebDNA is not handling properly. My approach at debugging this would be to try the same approach on a = different database. =46rom there, isolate the differences in situations = that work vs. ones that don=E2=80=99t and eliminate the differences one = at a time until the problem is found. - Brian Fries > On Dec 11, 2017, at 3:56 PM, Stuart Tremain = wrote: >=20 > Have you set the maximum found items in WebDNA to accomodate your = expected results ? >=20 >=20 >=20 > >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >=20 >> On 12 Dec 2017, at 02:10, Lawrence Banahan > wrote: >>=20 >> Hi, >> Since I upgraded to WDna8.5 I have a strange situation. >>=20 >> I make a search through a db that have about 15 000 entries >>=20 >> This line works >> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL] Total emails = avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text = show=3Dt]nb-av=3D[numfound][/text][/search] >>=20 >> 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] >>=20 >> "Internal Server Error >> The server encountered an internal error or misconfiguration and was = unable to complete your request." >>=20 >> I haven't purchase a licence for 8.5 is that the reason? >>=20 >>=20 >> 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 Reporting: = 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 Reporting: = support@webdna.us --Apple-Mail=_90D0FFCA-5F57-43E7-9182-54927FC27F70 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
The =E2=80=9Cmaximum found items=E2=80=9D = preference only effects the search COMMAND (which nobody should be = using), not the search CONTEXT, so it has no bearing here.

That said, in my simple testing I have not been = able to recreate the problem. Perhaps there is some particular data in = the database that WebDNA is not handling properly.

My approach at = debugging this would be to try the same approach on a different = database. =46rom there, isolate the differences in situations that work = vs. ones that don=E2=80=99t and eliminate the differences one at a time = until the problem is found.

- Brian Fries

On Dec 11, 2017, at 3:56 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Have you set the maximum found items in WebDNA = to accomodate your expected results ?



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



Kind regards

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






On 12 Dec 2017, at 02:10, Lawrence Banahan <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/_temp.db&ne_emaildata=3DFIND_AL= L] Total  emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[te= xt 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 Reporting: 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 Reporting: 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 Reporting: support@webdna.us --Apple-Mail=_90D0FFCA-5F57-43E7-9182-54927FC27F70-- . 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)
1388 --Apple-Mail=_90D0FFCA-5F57-43E7-9182-54927FC27F70 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 The =E2=80=9Cmaximum found items=E2=80=9D preference only effects the = search COMMAND (which nobody should be using), not the search CONTEXT, = so it has no bearing here. That said, in my simple testing I have not been able to recreate the = problem. Perhaps there is some particular data in the database that = WebDNA is not handling properly. My approach at debugging this would be to try the same approach on a = different database. =46rom there, isolate the differences in situations = that work vs. ones that don=E2=80=99t and eliminate the differences one = at a time until the problem is found. - Brian Fries > On Dec 11, 2017, at 3:56 PM, Stuart Tremain = wrote: >=20 > Have you set the maximum found items in WebDNA to accomodate your = expected results ? >=20 >=20 >=20 > >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >=20 >> On 12 Dec 2017, at 02:10, Lawrence Banahan > wrote: >>=20 >> Hi, >> Since I upgraded to WDna8.5 I have a strange situation. >>=20 >> I make a search through a db that have about 15 000 entries >>=20 >> This line works >> [search db=3Dbases/_temp.db&ne_emaildata=3DFIND_ALL] Total emails = avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[text = show=3Dt]nb-av=3D[numfound][/text][/search] >>=20 >> 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] >>=20 >> "Internal Server Error >> The server encountered an internal error or misconfiguration and was = unable to complete your request." >>=20 >> I haven't purchase a licence for 8.5 is that the reason? >>=20 >>=20 >> 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 Reporting: = 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 Reporting: = support@webdna.us --Apple-Mail=_90D0FFCA-5F57-43E7-9182-54927FC27F70 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
The =E2=80=9Cmaximum found items=E2=80=9D = preference only effects the search COMMAND (which nobody should be = using), not the search CONTEXT, so it has no bearing here.

That said, in my simple testing I have not been = able to recreate the problem. Perhaps there is some particular data in = the database that WebDNA is not handling properly.

My approach at = debugging this would be to try the same approach on a different = database. =46rom there, isolate the differences in situations that work = vs. ones that don=E2=80=99t and eliminate the differences one at a time = until the problem is found.

- Brian Fries

On Dec 11, 2017, at 3:56 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Have you set the maximum found items in WebDNA = to accomodate your expected results ?



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



Kind regards

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






On 12 Dec 2017, at 02:10, Lawrence Banahan <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/_temp.db&ne_emaildata=3DFIND_AL= L] Total  emails avant suppr=C3=A9ssion des d=C3=A9inscriptions=3D[te= xt 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 Reporting: 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 Reporting: 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 Reporting: support@webdna.us --Apple-Mail=_90D0FFCA-5F57-43E7-9182-54927FC27F70-- . Brian Fries

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:

WebCat2.0 [format thousands .0f] no go (1997) For those of you not on the WebCatalog Beta... (1997) iTools WebDNA module keeps crashing (2006) the dreaded unitShipCost (2003) multi-paragraph fields (1997) Quit revisited (1997) Page-Execution-Timer...PHP vs WebDNA (2004) Help! WebCat2 bug (1997) pop up menu's (1998) Re[2]: [format] problems (2000) Generating Report Totals (1997) [WebDNA] securing passing info from php to webdna (2011) Ranking customers (2003) is [Bankres] an internal webcat variable? (1999) WebDelivery downloads alias, not original ? (1997) orderfile headers (was: 2nd Request for help/adviceonvariable pricing) (2000) unable to launch acgi in WebCat (1997) ITS FRIDAY (2004) how to determine the actual file format of an image file? (2002) ImageMagick (2005)