Syntax error or access violation: 1064

More
1 year 3 weeks ago #186919 by molungus
Hi,

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

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.
LimeSurvey Partners
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
1 year 3 weeks ago #186921 by LouisGac
Replied by LouisGac on topic Syntax error or access violation: 1064
how did you update?
The topic has been locked.
More
1 year 2 weeks ago #186942 by molungus
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
1 year 2 weeks ago - 1 year 2 weeks 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: 1 year 2 weeks ago by LouisGac.
The topic has been locked.
More
1 year 2 weeks ago #186956 by molungus
Thanks again. The imported survey (lsa) works.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
1 year 2 weeks 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.
More
1 year 2 weeks ago #186958 by molungus
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
1 year 2 weeks 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.
More
1 year 2 weeks ago - 1 year 2 weeks ago #186979 by holch

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: 1 year 2 weeks ago by holch.
The topic has been locked.
More
1 year 2 weeks ago #187008 by molungus
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
1 year 2 weeks 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
1 year 2 weeks ago #187010 by cdorin
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 :) .
The topic has been locked.

Start now!

Just create your account and start using Limesurvey today.

Register now