Back to limesurvey.org

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
3 years 4 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
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 4 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?
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
3 years 4 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 support - Plugins, theme and 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
3 years 4 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 & Official Partner
  • LimeSurvey Community Team & Official Partner
More
3 years 4 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 support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source