Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

SQL error in the survey

  • jgarciafdc
  • jgarciafdc's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 6 months ago #220408 by jgarciafdc
SQL error in the survey was created by jgarciafdc
I`m working 5 years without problem, but the last week appears this error
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 'groups WHERE questions.gid=groups.gid AND questions.sid=76837 AND questions.la' at line 5:SELECT *, (SELECT count(1) FROM `lms_conditions` c WHERE questions.qid = c.qid) AS hasconditions, (SELECT count(1) FROM `lms_conditions` c WHERE questions.qid = c.cqid) AS usedinconditions FROM `lms_questions` as questions, `lms_groups` as groups WHERE questions.gid=groups.gid AND questions.sid=76837 AND questions.language='es' AND questions.parent_qid=0 AND groups.language='es' ORDER BY group_order, question_order

Anybody can help me?
The topic has been locked.
  • holch
  • holch's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months ago #220411 by holch
Replied by holch on topic SQL error in the survey
What happened last week? Any update?

Update of the server?
Update of Limesurvey?

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months ago #220441 by DenisChenu
Replied by DenisChenu on topic SQL error in the survey
And where this error happen ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • jgarciafdc
  • jgarciafdc's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 6 months ago #220482 by jgarciafdc
Replied by jgarciafdc on topic SQL error in the survey
When I go to the link the error appears, the link is the next

www.estrategiasensalud.com.co/encuestas/...hp?sid=76837&lang=es
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months ago #220485 by DenisChenu
Replied by DenisChenu on topic SQL error in the survey
Seems too be a very old (and hacked) version.
Can not help
www.estrategiasensalud.com.co/encuestas/admin/admin.php

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose