Welcome, Guest
Username: Password: Remember me

TOPIC: sql error after update to 1.91+ Build 10486

sql error after update to 1.91+ Build 10486 3 years 4 months ago #63387

  • waitz
  • waitz's Avatar
  • OFFLINE
  • Gold Lime
  • Posts: 171
  • Thank you received: 1
  • Karma: 3
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: 3 years 4 months ago by waitz.
The administrator has disabled public write access.

Re: sql error after update to 1.91+ Build 10486 3 years 4 months ago #63388

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
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: 3 years 4 months ago by mdekker.
The administrator has disabled public write access.

Re: sql error after update to 1.91+ Build 10486 3 years 4 months ago #63389

  • waitz
  • waitz's Avatar
  • OFFLINE
  • Gold Lime
  • Posts: 171
  • Thank you received: 1
  • Karma: 3
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 |
The administrator has disabled public write access.

Re: sql error after update to 1.91+ Build 10486 3 years 4 months ago #63390

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
Subversion... i can post an updated file here later today need to check some stuff first
---
Menno Dekker
The administrator has disabled public write access.

Re: sql error after update to 1.91+ Build 10486 3 years 4 months ago #63398

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 819
  • Thank you received: 116
  • Karma: 93
New version was released. Please update.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

[SOLVED] Re: sql error after update to 1.91+ Build 10486 3 years 4 months ago #63399

  • waitz
  • waitz's Avatar
  • OFFLINE
  • Gold Lime
  • Posts: 171
  • Thank you received: 1
  • Karma: 3
Yepp, it works. Thanks ;)
Version 1.91+ Build 11232 | PHP 5.3.9 | MySQL 5.1.56 |
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.154 seconds
Donation Image