Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: MYSQL error when trying to view last 50 responses

MYSQL error when trying to view last 50 responses 2 Jahre 3 Tage her #88598

  • liamh121
  • liamh121s Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 3
  • Karma: 0
Hi all,
Receiving the following error when trying to view the last 50 responses or an overview of all responses:

"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 'SELECT * FROM lime_surveys WHERE sid=61547 ORDER BY `lime_survey_61547`.id DESC' at line 1:SELECT * FROM `lime_survey_61547` WHERE 1=1 AND submitdate IS NOT NULL AND SELECT * FROM lime_surveys WHERE sid=61547 ORDER BY `lime_survey_61547`.id DESC"

The data is still exportable but we would like to be able to see results online. We recently changed our cookie settings mid way through so have a feeling this may be the root. Any ideas on how we can fix this?

Many thanks,

Liam
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Aw: MYSQL error when trying to view last 50 responses 1 Jahr 11 Monate her #89002

  • jelo
  • jelos Avatar
  • OFFLINE
  • Platinum Lime
  • Beiträge: 470
  • Dank erhalten: 52
  • Karma: 16
Which Version of Limesurvey are you using? Which MySQL Version are you using?
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.122 Sekunden
Donation Image