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
|
