Welcome to the LimeSurvey Community Forum

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

Syntax error or access violation: 1064

  • molungus
  • molungus's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 8 months ago #186919 by molungus
Syntax error or access violation: 1064 was created by molungus
Hi,

all of a sudden my surveys don't work anymore and the participants get the following error:

Code:
Interner Serverfehler
CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42000]: Syntax error or access violation: 1064 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=462472 AND questions.l' at line 1

Any idea what's going wrong and how to solve this?

Thanks in advance!

Thomas
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
4 years 8 months ago #186921 by LouisGac
Replied by LouisGac on topic Syntax error or access violation: 1064
how did you update?
The topic has been locked.
  • molungus
  • molungus's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 8 months ago #186942 by molungus
Replied by molungus on topic Syntax error or access violation: 1064
Hi Louis,

Thank you for your reply and sorry for not sharing the information of my version.

The version is 2.73.0+171219. The installation is hosted by our university computing centre and I suspect there hasn't been an update for a long time :/
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
4 years 8 months ago - 4 years 8 months ago #186954 by LouisGac
Replied by LouisGac on topic Syntax error or access violation: 1064
Hi, I'd suggest you export your survey in lss or lsa format, and upload it here in a free installation. If it fails again: it's a problem with the survey itself.
Last edit: 4 years 8 months ago by LouisGac.
The topic has been locked.
  • molungus
  • molungus's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 8 months ago #186956 by molungus
Replied by molungus on topic Syntax error or access violation: 1064
Thanks again. The imported survey (lsa) works.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
4 years 8 months ago #186957 by LouisGac
Replied by LouisGac on topic Syntax error or access violation: 1064
So I would suggest you import again the survey in your LimeSurvey installation, without deleting the buggy one.

It will generate new ids for surveys, questions and groups, and could solve your problem.
The topic has been locked.
  • molungus
  • molungus's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 8 months ago #186958 by molungus
Replied by molungus on topic Syntax error or access violation: 1064
Unfortunately I immediately get the same error message when I try to import the survey. I just noticed that I get this error message when I click on any survey in my survey list.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
4 years 8 months ago #186962 by LouisGac
Replied by LouisGac on topic Syntax error or access violation: 1064
so it's clearly a problem on your server side. You should contact your sysadmin to ask him if they recently changed something on the server, like the mysql server
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 8 months ago - 4 years 8 months ago #186979 by holch
Replied by holch on topic Syntax error or access violation: 1064

The version is 2.73.0+171219. The installation is hosted by our university computing centre and I suspect there hasn't been an update for a long time :/


Yes, since the 19th of December 2017 to be exact... ;-)

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

Last edit: 4 years 8 months ago by holch.
The topic has been locked.
  • molungus
  • molungus's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 8 months ago #187008 by molungus
Replied by molungus on topic Syntax error or access violation: 1064
Indeed there have been changes made to the myqsl server and the sysadmin reverted them. No everything works fine again.

I hope I'll see an update for LimeSurvey soon ;b

Thank you guys!
The following user(s) said Thank You: LouisGac
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
4 years 8 months ago #187009 by LouisGac
Replied by LouisGac on topic Syntax error or access violation: 1064
I bet it was the "ONLY_FULL_GROUP_BY" parameter.
The topic has been locked.
More
4 years 8 months ago #187010 by cdorin
Replied by cdorin on topic Syntax error or access violation: 1064
Hello Molungus, please get in touch with the IT team and recommend them to upgrade asap. As holch underlined above, that's quite an old version and it is a shame for students not to use the newest version of LimeSurvey. If they need help or have further questions, you may send them to us :) .

Manual: manual.limesurvey.org/LimeSurvey_Manual
Bugs tracker: bugs.limesurvey.org/my_view_page.php
If you self-host and need help, contact one of our partners: limesurvey.com
Please do not contact me via PM - thank you.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose