Check out the LimeSurvey source code on GitHub!

SQL error using mysql

5 years 3 months ago #68329 by rmbraun
Help please. I am getting error messages like this. I am using Version 1.91+ Build 11232. My mysql version is 5.0.22. My php version is 5.3.8.

Many thanks. Rob

UPDATE lime_survey_13791 SET lastpage = '4', datestamp = '2011-11-03 13:06:23',`13791X22X266` = '5',`13791X22X267` = 'C1E',`13791X22X267comment` = '',`13791X22X296` = '[{"title":"Applying Neural network Analysis on Heart Rate variability Data to Assess Driver Fatigue","comment":"","size":"979.194","name":"ESWA2011_Applying_NNA_on_HRV_data_to_Assess_Driver_Fatigue.pdf","filename":"fu_zdmr546q9v28j9a","ext":"pdf"}]',`13791X22X296_filecount` = '1',`13791X22X268` = 'E1E',`13791X22X268comment` = '',`13791X22X297` = '[{"title":"","comment":"","size":"308.199","name":"ACRA2010_Probabilistic_Models_versus_Discriminate_Classifiers_for_Human_Activity_Recognition_with_an_Instrumented_Mobility-Assistance_Aid.pdf","filename":"fu_5szrjshw3ddac25","ext":"pdf"}]',`13791X22X297_filecount` = '1',`13791X22X269` = 'E1E',`13791X22X269comment` = '',`13791X22X298` = '[{"title":"u2019Dynamic Bayesian Network for Learning Interactions Between Assistive Robotic Walker and Human Users","comment":"","size":"24

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 'Designing SANDRA: An Autonomous Tour Guide Robot for the University of Technolog' at line 1

Please Log in to join the conversation.

5 years 3 months ago #68345 by Mazi
Hmm, it seems like the query isn't shown complete above. There should be some more code following. Can you have a look and check if you can provide the whole SQL statement?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form