Thread: [phpesp-general] Error when cross tabulating

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

No virus found in this outgoing message.
Checked by AVG. 
Version: 8.0.100 / Virus Database: 270.4.0/1506 - Release Date: 2008/06/17 04:30 PM

On Wed, 18 Jun 2008 19:56:13 +0100
Renate Morgenstern <rmo...@iw...> wrote:

> Hi again,
> I tried to cross tabulate the results of a survey.  After selecting a 
> blue tab on one question, I selected a red one on another question.
> But then I get the following error message:
> *Notice*: Undefined index: phpesp_response_single_table in 
> */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *203*
> 
> *"Which of the following best describes your main role or function? 
> Select your response from the following drop-down list."vs "Are you 
> involved in the planning or creation of digital library collections?"*
> 
> *Notice*: Undefined offset: 0 in 
> */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *276*
> 
> *Notice*: Undefined offset: 2 in 
> */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *280*
> 
> Is there something wrong with my survey?
> 
> Please help.
> Renate
> 
> 

First of all: what is the version you're using?
Second of all: php notices are *not* errors, you see them on the screen
because your php.ini file is configured to do so, this has nothing to
do with phpESP. I agree, they shouldn't be there in the first place,
but first configure your php correctly for this (log them to apache
logfiles or so).

Franky

You may be technically correct that these are not "errors" but to the user if
the a) program fails to work as could be reasonably expected and b) you get
unexplained messages on the screen then those are "errors" so far as the user is
concerned.  You and I might appreciate the semantic distinction but the user
won't. 

It might be more useful to point them to places they can get a better
understanding of how to work with php (and that assumes the user is not on a
shared hosting arrangement where they have no control over php.ini).

--
-Rob

-----Original Message-----
From: Franky Van Liedekerke [mailto:lie...@te...] 
Sent: Wednesday, June 18, 2008 4:55 PM
To: Renate Morgenstern
Cc: php...@li...
Subject: Re: [phpesp-general] Error when cross tabulating

On Wed, 18 Jun 2008 19:56:13 +0100
Renate Morgenstern <rmo...@iw...> wrote:

> Hi again,
> I tried to cross tabulate the results of a survey.  After selecting a 
> blue tab on one question, I selected a red one on another question.
> But then I get the following error message:
> *Notice*: Undefined index: phpesp_response_single_table in 
> */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *203*
> 
> *"Which of the following best describes your main role or function? 
> Select your response from the following drop-down list."vs "Are you 
> involved in the planning or creation of digital library collections?"*
> 
> *Notice*: Undefined offset: 0 in 
> */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *276*
> 
> *Notice*: Undefined offset: 2 in 
> */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *280*
> 
> Is there something wrong with my survey?
> 
> Please help.
> Renate
> 
> 

First of all: what is the version you're using?
Second of all: php notices are *not* errors, you see them on the screen
because your php.ini file is configured to do so, this has nothing to
do with phpESP. I agree, they shouldn't be there in the first place,
but first configure your php correctly for this (log them to apache
logfiles or so).

Franky

Hi,

well, since they use php, I assume they have *some* knowledge about it, be
it enough to know the website to look for answers concerning php :-) And for
those who don't know: http://www.php.net and for the ini file:
http://www.php.net/manual/en/ini.php
But anyway, I did already agree on the fact that these errors shouldn't be
there, so that's why I asked about the version used as well ...

Franky

On 6/18/08, Rob de Santos <rde...@af...> wrote:
>
> You may be technically correct that these are not "errors" but to the user
> if
> the a) program fails to work as could be reasonably expected and b) you get
> unexplained messages on the screen then those are "errors" so far as the
> user is
> concerned.  You and I might appreciate the semantic distinction but the
> user
> won't.
>
> It might be more useful to point them to places they can get a better
> understanding of how to work with php (and that assumes the user is not on
> a
> shared hosting arrangement where they have no control over php.ini).
>
> --
> -Rob
>
> -----Original Message-----
> From: Franky Van Liedekerke [mailto:lie...@te...]
> Sent: Wednesday, June 18, 2008 4:55 PM
> To: Renate Morgenstern
> Cc: php...@li...
> Subject: Re: [phpesp-general] Error when cross tabulating
>
> On Wed, 18 Jun 2008 19:56:13 +0100
> Renate Morgenstern <rmo...@iw...> wrote:
>
> > Hi again,
> > I tried to cross tabulate the results of a survey.  After selecting a
> > blue tab on one question, I selected a red one on another question.
> > But then I get the following error message:
> > *Notice*: Undefined index: phpesp_response_single_table in
> > */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *203*
> >
> > *"Which of the following best describes your main role or function?
> > Select your response from the following drop-down list."vs "Are you
> > involved in the planning or creation of digital library collections?"*
> >
> > *Notice*: Undefined offset: 0 in
> > */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *276*
> >
> > *Notice*: Undefined offset: 2 in
> > */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *280*
> >
> > Is there something wrong with my survey?
> >
> > Please help.
> > Renate
> >
> >
>
> First of all: what is the version you're using?
> Second of all: php notices are *not* errors, you see them on the screen
> because your php.ini file is configured to do so, this has nothing to
> do with phpESP. I agree, they shouldn't be there in the first place,
> but first configure your php correctly for this (log them to apache
> logfiles or so).
>
> Franky
>
>
>
>

Hi,

please mail the version of phpESP you're using.

Franky

On 6/23/08, Renate Morgenstern <rmo...@un...> wrote:
>
> Hi,
>
> Sorry for the wrong words I used. I am a user of phpESP and not a
> programmer. ;-)
> I am using PHP version 4.2.2
> Before I upgraded to the latest phpESP the cross tabulation was working.
> Thanks
> Renate
>
>
>
>  > Hi again,
>> > I tried to cross tabulate the results of a survey.  After selecting a
>> > blue tab on one question, I selected a red one on another question.
>> > But then I get the following error message:
>> > *Notice*: Undefined index: phpesp_response_single_table in
>> > */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *203*
>> >
>> > *"Which of the following best describes your main role or function?
>> > Select your response from the following drop-down list."vs "Are you
>> > involved in the planning or creation of digital library collections?"*
>> >
>> > *Notice*: Undefined offset: 0 in
>> > */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *276*
>> >
>> > *Notice*: Undefined offset: 2 in
>> > */var/www/html/phpESP/admin/include/where/crosstab.inc* on line *280*
>> >
>> > Is there something wrong with my survey?
>> >
>> > Please help.
>> > Renate
>> >
>> >
>>
>> First of all: what is the version you're using?
>> Second of all: php notices are *not* errors, you see them on the screen
>> because your php.ini file is configured to do so, this has nothing to
>> do with phpESP. I agree, they shouldn't be there in the first place,
>> but first configure your php correctly for this (log them to apache
>> logfiles or so).
>>
>> Franky
>>
>
>
>
>

Hi Renate,

(sorrt for the late reply, busy busy ..)
it is in fact a bug you encountered. Try changing line 203 in 
admin/include/where/crosstab.inc from:

$sql1 = "SELECT count(*) FROM
".$GLOBALS['ESPCONFIG'][$tbl[0].'_table']." r1,
".$GLOBALS['ESPCONFIG'][$tbl[1].'_table']." r2

to:

$sql1 = "SELECT count(*) FROM ".$tbl[0]." r1, ".$tbl[1]." r2

that should do the trick ...

Franky

> From: Franky Van Liedekerke <lie...@te...>
> Date: Mon, Jun 23, 2008 at 1:41 PM
> Subject: Re: [phpesp-general] Error when cross tabulating
> To: php...@li...
> 
> 
> Hi,
> 
> please mail the version of phpESP you're using.
> 
> Franky
> 
> On 6/23/08, Renate Morgenstern <rmo...@un...> wrote:
> >
> > Hi,
> >
> > Sorry for the wrong words I used. I am a user of phpESP and not a
> > programmer. ;-)
> > I am using PHP version 4.2.2
> > Before I upgraded to the latest phpESP the cross tabulation was
> > working. Thanks
> > Renate
> >
> >
> >
> >  > Hi again,
> >> > I tried to cross tabulate the results of a survey.  After
> >> > selecting a blue tab on one question, I selected a red one on
> >> > another question. But then I get the following error message:
> >> > *Notice*: Undefined index: phpesp_response_single_table in
> >> > */var/www/html/phpESP/admin/include/where/crosstab.inc* on line
> >> > *203*
> >> >
> >> > *"Which of the following best describes your main role or
> >> > function? Select your response from the following drop-down
> >> > list."vs "Are you involved in the planning or creation of
> >> > digital library collections?"*
> >> >
> >> > *Notice*: Undefined offset: 0 in
> >> > */var/www/html/phpESP/admin/include/where/crosstab.inc* on line
> >> > *276*
> >> >
> >> > *Notice*: Undefined offset: 2 in
> >> > */var/www/html/phpESP/admin/include/where/crosstab.inc* on line
> >> > *280*
> >> >
> >> > Is there something wrong with my survey?
> >> >
> >> > Please help.
> >> > Renate
> >> >
> >> >
> >>
> >> First of all: what is the version you're using?
> >> Second of all: php notices are *not* errors, you see them on the
> >> screen because your php.ini file is configured to do so, this has
> >> nothing to do with phpESP. I agree, they shouldn't be there in the
> >> first place, but first configure your php correctly for this (log
> >> them to apache logfiles or so).
> >>
> >> Franky
> >>
> >
> >
> >
> >

Franky Van Liedekerke <liedekef <at> telenet.be> writes:

> 
> 
> Hi,
>  
> well, since they use php, I assume they have *some* knowledge about it, be it
enough to know the website to look for answers concerning php  And for those who
don't know: http://www.php.net and for the ini file:
http://www.php.net/manual/en/ini.php
> 
> 
> But anyway, I did already agree on the fact that these errors shouldn't be
there, so that's why I asked about the version used as well ...
>  
> Franky 
> 
> On 6/18/08, Rob de Santos <rdesantos <at> afana.com> wrote:
> You may be technically correct that these are not "errors" but to the user
ifthe a) program fails to work as could be reasonably expected and b) you get
> unexplained messages on the screen then those are "errors" so far as the user
isconcerned.  You and I might appreciate the semantic distinction but the
userwon't.It might be more useful to point them to places they can get a better
> understanding of how to work with php (and that assumes the user is not on
ashared hosting arrangement where they have no control over
php.ini).---Rob-----Original Message-----From: Franky Van Liedekerke
[mailto:liedekef <at> telenet.be]
> Sent: Wednesday, June 18, 2008 4:55 PMTo: Renate MorgensternCc: phpesp-general
<at> lists.sourceforge.netSubject: Re: [phpesp-general] Error when cross
tabulatingOn Wed, 18 Jun 2008 19:56:13 +0100Renate Morgenstern <rmorgenstern
<at> iway.na> wrote:> Hi again,> I tried to cross tabulate the results of a
survey.  After selecting a
> > blue tab on one question, I selected a red one on another question.> But
then I get the following error message:> *Notice*: Undefined index:
phpesp_response_single_table in>
*/var/www/html/phpESP/admin/include/where/crosstab.inc* on line *203*
> >> *"Which of the following best describes your main role or function?> Select
your response from the following drop-down list."vs "Are you> involved in the
planning or creation of digital library collections?"*
> >> *Notice*: Undefined offset: 0 in>
*/var/www/html/phpESP/admin/include/where/crosstab.inc* on line *276*>>
*Notice*: Undefined offset: 2 in>
*/var/www/html/phpESP/admin/include/where/crosstab.inc* on line *280*
> >> Is there something wrong with my survey?>> Please help.> Renate>>First of
all: what is the version you're using?Second of all: php notices are *not*
errors, you see them on the screen
> because your php.ini file is configured to do so, this has nothing todo with
phpESP. I agree, they shouldn't be there in the first place,but first configure
your php correctly for this (log them to apachelogfiles or so).Franky

My version of handler.php does not show a version number but I have made the
adjustments Franky identified in http://bit.ly/R9ODBy

I am in a shared server environment and cannot access php.ini to change
settings. And I know almost nothing about php anyway.

My public surveys include the following:
Notice: Undefined offset: 3 in
/home/pagecrft/public_html/phpESP/public/handler.php on line 385
Notice: Undefined offset: 4 in
/home/pagecrft/public_html/phpESP/public/handler.php on line 388
Notice: Undefined offset: 3 in
/home/pagecrft/public_html/phpESP/public/handler.php on line 385
Notice: Undefined offset: 4 in
/home/pagecrft/public_html/phpESP/public/handler.php on line 388

Don't know what it means but sure would like to hide it.

Thanks.