Check out the LimeSurvey source code on GitHub!

sql error after update to 1.91+ Build 10486

More
5 years 7 months ago - 5 years 7 months ago #63387 by waitz
Oh sh##t... After I updated from the may release of 1.91+ to 1.91+ Build 10486 I get an error in the survey:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE c.cqid=q.qid AND c.qid=76 AND c.language='en' AND c.cfieldname NOT LIKE '{' at line 1:SELECT c.qid, c.scenario, c.cqid, c.cfieldname, c.value, q.type, q.sid, q.gid, c.method, q.gid as srcgid FROM lime_conditions c, lime_questions q,WHERE c.cqid=q.qid AND c.qid=76 AND c.language='en' AND c.cfieldname NOT LIKE '{%' ORDER BY c.scenario, c.cqid, c.cfieldname
The error appears here in the second question: (answer yes to the first question) www.humaniversity.com/apply/index.php?la...bujq6w9tv74r3n397c3d

Anyone know what is this about..?

Version 1.91+ Build 11232 | PHP 5.3.9 | MySQL 5.1.56 |
Last Edit: 5 years 7 months ago by waitz.

Please Log in to join the conversation.

More
5 years 7 months ago - 5 years 7 months ago #63388 by mdekker
I found the error too and fixed it... waiting for project leader to do a file release... you could check svn for a fixed qanda.php

---
Menno Dekker
Last Edit: 5 years 7 months ago by mdekker.

Please Log in to join the conversation.

More
5 years 7 months ago #63389 by waitz

mdekker wrote: I found the error too and fixed it... waiting for project leader to do a file release... you could check svn for a fixed qanda.php

Ahh, good I am not alone :-)

What do you mean by svn..?

Version 1.91+ Build 11232 | PHP 5.3.9 | MySQL 5.1.56 |

Please Log in to join the conversation.

More
5 years 7 months ago #63390 by mdekker
Subversion... i can post an updated file here later today need to check some stuff first

---
Menno Dekker

Please Log in to join the conversation.

More
5 years 7 months ago #63398 by c_schmitz
New version was released. Please update.

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
5 years 7 months ago #63399 by waitz
Yepp, it works. Thanks ;)

Version 1.91+ Build 11232 | PHP 5.3.9 | MySQL 5.1.56 |

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form