- Posts: 2
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
SQL error in the survey
- jgarciafdc
- Topic Author
- Offline
- New Member
Less
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?
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
- Away
- LimeSurvey Community Team
Less
More
- Posts: 11656
- Thank you received: 2742
2 years 6 months ago #220411
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic SQL error in the survey
What happened last week? Any update?
Update of the server?
Update of Limesurvey?
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13643
- Thank you received: 2491
2 years 6 months ago #220441
by DenisChenu
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.
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 0
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
www.estrategiasensalud.com.co/encuestas/...hp?sid=76837&lang=es
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13643
- Thank you received: 2491
2 years 6 months ago #220485
by DenisChenu
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.
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
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.