Re: [phpesp-general] Fwd: Error when cross tabulating

[Franky V. L. <lie...@te...>]

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
> >>
> >
> >
> >
> >