Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Urgent! Help needed on an error in SQL syntax

Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54378

  • Shirley
  • Shirley's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
I am new to limesurvey and I am not a programmer. I just created the survey, and tested it before i activated the survey. Everything was fine then, until I activated it and started clicking on the first question.

The question is very simple:

Which city are you living in?

1. Beijing
2. Shanghai
3. Guangzhou
4. Others
Only the ones that have chosen Shanghai (2) are supposed to pass.

This is what I get when I click on any of the options.

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 ') AND submitdate IS NOT NULL' at line 2:SELECT id FROM `survey_81264` WHERE (`81264X7X50` = 'A1' ) AND (`81264X7X50` = 'A3' ) AND (`81264X7X50` = 'A4' ) AND ( ) AND submitdate IS NOT NULL

Version 1.90+ Build 9290

I don't know what to do. I don't even know where to check..I have spent hours and hours working on designing the survey and it is supposed to be live now! Please, can someone help me with it?

Thanks so much!

Shirley
The administrator has disabled public write access.

Re:Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54381

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2838
  • Thank you received: 356
  • Karma: 123
So I assume you used conditions to let only those pass that have chosen Shanghai, right?
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re:Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54397

  • Shirley
  • Shirley's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Yes, I used conditions. Every other question will only show up when Shanghai is selected. I didn't do anything about Beijing, Guangzhou or Others.

Did I do something wrong?

Thanks for your help!
The administrator has disabled public write access.

Re:Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54399

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2838
  • Thank you received: 356
  • Karma: 123
I am not a developer, so the error messages doesn't say much to me.

What happens if you export the survey and import it again as a new survey? This should be something quick to do.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re:Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54404

  • Shirley
  • Shirley's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
I tried. It's really weird. I exported as a .lss file and imported. it doesn't recognize the file type.. So I tried .xml, and it said imported successfully, but I can't find any new survey in my survey list...
The administrator has disabled public write access.

Re:Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54407

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2838
  • Thank you received: 356
  • Karma: 123
It didn't recognize the own file? Then there must be something seriously wrong in your survey. I can understand that a file might not work when it is from another application, but from the same one? hmm....
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re:Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54410

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6429
  • Thank you received: 839
  • Karma: 249
Can you trye to use the database inspector with LimeSurvey ?

At the top toolbar.
The administrator has disabled public write access.

Re:Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54411

  • Shirley
  • Shirley's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
That's what I thought, but this is the error message I get when I try to import:

This is not a valid LimeSurvey survey structure XML file.

Which doesn't make much sense as I exported it as an .lss file and was under the impression that you could upload .lss files.

Is there anyone I can talk to about this?
The administrator has disabled public write access.

Re:Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54419

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5331
  • Thank you received: 296
  • Karma: 249
Make a backup of your survey and then delete the conditions you have set. Test again if there still is an error shown.

I suppose there is a wrong/invalid/incomplete condition at your survey which causes the SQL error.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re:Urgent! Help needed on an error in SQL syntax 3 years 9 months ago #54433

  • Shirley
  • Shirley's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Thank you all for the help... The survey seems fine now... I didn't really do anything and somehow it fixed itself I think!! magic!
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.168 seconds
Donation Image