Welcome, Guest
Username: Password: Remember me

TOPIC: SQL error using mysql

SQL error using mysql 2 years 10 months ago #68329

  • rmbraun51
  • rmbraun51's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
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

SQL CODE THAT FAILED:
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

ERROR MESSAGE:
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
The administrator has disabled public write access.

Re: SQL error using mysql 2 years 10 months ago #68345

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
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)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.094 seconds
Donation Image