Syntax error or access violation: 1064

Mehr
2 Monate 3 Wochen her #186919 von 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

LimeSurvey Partners
Mehr
2 Monate 3 Wochen her #186921 von LouisGac
how did you update?

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her #186942 von 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 :/

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her - 2 Monate 3 Wochen her #186954 von LouisGac
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.
Letzte Änderung: 2 Monate 3 Wochen her von LouisGac.
Folgende Benutzer bedankten sich: cdorin

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her #186956 von molungus
Thanks again. The imported survey (lsa) works.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her #186957 von LouisGac
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.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her #186958 von 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.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her #186962 von LouisGac
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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her - 2 Monate 3 Wochen her #186979 von 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'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
Letzte Änderung: 2 Monate 3 Wochen her von holch.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her #187008 von 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!
Folgende Benutzer bedankten sich: LouisGac

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her #187009 von LouisGac
I bet it was the "ONLY_FULL_GROUP_BY" parameter.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
2 Monate 3 Wochen her #187010 von 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 :) .

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha