Hi all ..
when i make a new survey and copy from another survey
the answer types are out of sequence in the new survey.
I have not figured out this mystery.
Any suggestions are greatly appreciated.
Thx
K Ellis

Sorry I can't help here. I too, have a problem with survey question order. Seems questions spontaneously go out of order. Sometimes "page breaks" are spontaneously inserted. Occasionally 3 one after another.

My client is getting a bit peeved at me about this.

SM

Oh, I just saw this. How convenient! I just posted a similar question. So, my customers are not crazy, at least as crazy as I think they are.

Is this an issue that has any resolution. John, are you out there?

Christopher Adams

Hi all thanks for your reply,
yesterday we discovered that if a new survey is created and copied from a first generation original survey,
the answer types remain in order.

If a new survey from the second generation survey is copied, answer types reverse order from do not like ---- to love very much .. in reverse.

Hopefully this is a symptom to an apparent solution.
again thanks for looking and repliing
k

I think this is the result of a mySQL "feature" (e.g bug). The behavior of the "order" clause has changed with newer mySQL releases. When I get some free time, I'll try to pinpoint the specific statements and provide fixes. A very similar problem occurred a while back with some of my other php/mySQL apps and slightly changing the query fixed the problem. Since there was another big layoff at the shop where I work, I've not had much free time to do much of anything beyond learning several unfortunate co-workers job duties.

I also ran into this problem and my simple fixed was to alter main.class.php lines 370,375 & 411
so that the order by reads as :

ORDER BY aid ASC, numeric_value ASC

By doing this it forces the Question Values to display in the order of their numeric_value which fixed it for my needs.

Now the real issue is and I've not had time to track it down (new to PHP & UCCASS) is that the Insert / Select needs an order by on it, and since it is not there or not correct the database is ordering on just the primary index is my guess which is just the AID, the primary Index probably needs to be AID, AVID so it will follow the original order.

Mike