Re: [phpesp-general] more on the ADODB Bug?

[Matt M. <jma...@gm...>]

Here's how I fixed the problem:

One of the servers I used has a PHP debugger on it, and it shows you the
stack trace leading up to the error.  The adodb error is just the result of
the problem, not the problem itself.  The problem, for me was an SQL error
embedded somewhere.  I suspect that there is a DIFFERENT sql error,
somewhere else, that is causing your problem.

Go to about line 858 in adodb.inc.php and add the following line:

echo "$sql<br/>";

this will force the sql statement that is causing the error to be displayed
to the browser.  you can then track down that sql statement that is causing
the problem, and fix it.

-Matt Miller

On 10/23/06, Christopher Kolar <ck...@im...> wrote:
>
>  Hi Everyone (and Matt).  I am seeing some of the same error messages that
> Matt reported last week.  I put in his fix but it did not help me out when
> using the view response report feature.  It is mixed likert and open text
> data.  When I try to look at an individual response I see the text answers
> but no likert items.  Here is a segment of the results page, it continues
> this way all the way down.
>
> Section One: Teaching
> *1.* *What do you see as the strengths of this teacher's approach to
> teaching?*
> *Notice*: Only variable references should be returned by reference in */home/.nana/imsarese/imsaresearch.org/survey/admin/include/lib/adodb/adodb.inc.php
> * on line *859
> *#Response
> *2.* *What suggestions do you have to improve the teaching in this course?
> *
> *Notice*: Only variable references should be returned by reference in */home/.nana/imsarese/imsaresearch.org/survey/admin/include/lib/adodb/adodb.inc.php
> * on line *859
> *#Response
> *3.* *The teacher has clearly communicated the learning objectives and
> expectations of this course.
> Notice*: Only variable references should be returned by reference in */home/.nana/imsarese/imsaresearch.org/survey/admin/include/lib/adodb/adodb.inc.php
> * on line *859
>
> *Running php5.x  mysql 4.1 (dreamhost).  Note it was working earlier in
> the morning and just started throwing the errors all of sudden.  Any
> suggestions?  Thanks,
>
> --chris
>
>
> At 03:54 PM 10/16/2006, you wrote:
>
> Hello, I just fixed the issue I reported 2 hours ago.
>
> On about line 203 of where/crosstab.inc
>
>                 $sql1 = "SELECT count(*) FROM
> ".$GLOBALS['ESPCONFIG'][$tbl[0].'_table']." r1,
> ".$GLOBALS['ESPCONFIG'][$tbl[1].'_table']." r2
>                 WHERE (r1.question_id = ${qids[0]} AND r1.choice_id =
> '${xx}')
>                 AND (r2.question_id = ${qids[1]} AND r2.choice_id =
> '${yy}')
>
>
> I added the single quotes around ${xx} and ${yy}
>
> The lack of single quotes was throwing an error, thinking I was looking at
> columns named Y or N as opposed to looking at the value within the column.
>
> -Matt Miller
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>  http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> phpESP-general mailing list
> php...@li...
>  https://lists.sourceforge.net/lists/listinfo/phpesp-general
>
>  /////\\\\\/////\\\\\
> Christopher G. Kolar
>    Coordinator of Research and Evaluation
>    Illinois Mathematics and Science Academy
>  ck...@im...  --  staff.imsa.edu/~ckolar<http://staff.imsa.edu/%7Eckolar>--  PGP Public Key ID: 0x43879C9B
>