How did you add the condition? Via the condition editor or by entering your own expression at the "Relevance equation field" at the question?

If the later, you need to use question codes instead of SGQA identifiers, e.g.:
((questioncode.NAOK == "1")), assuming that "questioncode is the code of the previous question.

hi dr. minke.
[5:13:45 PM] Mark Mirasol: with regards to http://bugs.limesurvey.org/view.php?id=8117
[5:14:22 PM] Mark Mirasol: we are working with a survey that was exported from limesurvey 1.92 and imported into lime 2.0
[5:15:37 PM] Mark Mirasol: we have the same survey on both instances of lime
[5:15:53 PM] Mark Mirasol: but we are getting the error when we are trying to view the conditions in lime 2.0

limesurvey_survey_88752.lss [^] (3,116,311 bytes) 2013-09-03 11:22

• this is the survey we exported from 1.92.
  steps to replicate are as follows:
  1. import .lss file in lime 2.0.
  2. select survey 130604.
  3. select group SV1:Q8_Q9.
  4. select question Q8 and click conditions editor (this should work).
  5. select question Q9 and it will give you the error shown.

I have imported survey #88752 (seem to be the one designed at LS2) and I am able to view the conditions of question Q9 without any problems, see attached screen shot.

1. Are you sure about the PHP version being used? Because Limesurvey 2 requires a higher version if I remember correctly.

2. Does the problem show up at the original survey as well or only when importing the 1.92 survey at Limesurvey 2?

3. Please also run the logic file check to see if there are any problems with question codes or the like.

Hello Dr. Minke, is the screenshot you posted from lime 1.92 or lime 2.0? Please see my answers to your questions below.

1. Yes. we are using 5.1.6

2. We don't have this problem in 1.92. only in lime 2.0

3. We run the integrity check and it showed no issues.

hi dr. minke.
[11:14:19 PM] Mark Mirasol: we're just trying to set the attribute to the connection object directly.
[11:15:08 PM] Mark Mirasol: can you tell us where the connection object to the database is?
[11:15:55 PM] Mark Mirasol: we're trying to do something like this to fix the error.
[11:15:56 PM] Mark Mirasol:
try {
$conn = new PDO("mysql:host=$hostname;dbname=esma", $username, $password);
$conn->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, 1);
}
[11:16:17 PM] Mark Mirasol: can you tell us where the $conn object is defined in lime.

Menno, this is the issue we talked about at the last dev meeting. Can you please check if the following fix sounds appropriate and if so, apply it to the current 2.0 branch:

At /framework/db/CDbConnection.php line 437 add:
$pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, 1);

I am not that familiar with these DB details so I'd be happy if you can check and apply this small fix.

Thanks!

This is a workaround, not a solution. The workaround states that 'if your code is only going to run against mysql you can...' but we also support mssql, pgsql so this is not a fix. But only when we can reproduce this using the latest version, we will be able to fix the problem.

Most of the time it is due to leaving a query open and then performing another one. We used to have a lot of this errors when we moved to Yii but I think most of them were fixed. Maybe some files of the installation are old or some rare condition with the php version causes some other program flow. Only way to find out is by having the reporter(s) enable debug mode level 2 and not use the workaround.

Thanks for your feedback, Menno.

I will close this one since it is solved for the user but unable to reproduce on any of my systems.