Re: [phpesp-general] interesting small bug with multipage surveys

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

On Mon, 18 Aug 2008 15:27:03 -0400
"Jerry B. Altzman" <jb...@gm...> wrote:

> Hi,
> 
> I've seen an interesting bug, and I'm not sure if it is just me (i.e.
> pilot error) or if it's something systemic, and if maybe there's a
> bugfix I've missed. We're using phpESP 2.0.2.
> 
> We've got a number of surveys that are multi-page that allow you to go
> back and forth from page to page. When we go to examine the data and
> associated with this survey, only the last page of survey data is
> available.
> 
> I've tracked this down to the following: each page gets entered with
> its own 'id' in the response table, but only the last page's ID has
> the 'complete' column set to 'Y'. So we'll see things like:
> mysql> select * from response where username='dking123';
> +-----+-----------+---------------------+----------+----------+--------------+
> | id  | survey_id | submitted           | complete | username |
> ip           |
> +-----+-----------+---------------------+----------+----------+--------------+
> | 185 |        25 | 2008-08-18 14:57:10 | N        | x| z| | 186
> |        25 | 2008-08-18 14:57:35 | N        | x| z| | 187 |
> 25 | 2008-08-18 14:57:40 | N        | x| z| | 188 |        25 |
> 2008-08-18 14:58:04 | Y        | x| z|
> +-----+-----------+---------------------+----------+----------+--------------+
> 4 rows in set (0.00 sec)
> 
> (I've done just the tiniest bit of sterilization on my data here.)
> 
> Has anyone else seen this behavior? Is there a fix already, or should
> I go out and write it and submit it back in?
> 
> Thanks 1.e6!
> 
> //jbaltz

That's something I've not seen before.
I just tested it with a 2 page survey here and it seems to work ok.
Please try upgrading to 2.1.2 and test again.

Franky