Welcome, Guest
Username: Password: Remember me

TOPIC: [mysql error] CDbCommand failed to execute the SQL statement

[mysql error] CDbCommand failed to execute the SQL statement 2 years 5 months ago #80146

  • pawciak
  • pawciak's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
Hey Guys,

first of all - amazing piece of work! But i have a tiny problem. While on localhoest for first time everything went ok, after moving script to server i get following error (after trying to start filling the survey)
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'datestamp' in 'field list'. The SQL statement executed was: INSERT INTO `lime_survey_585565` (`startlanguage`, `datestamp`, `startdate`, `ipaddr`) VALUES (:startlanguage, :datestamp, :startdate, :ipaddr)

This is the rest of error page: http://justpaste.it/z2a
If you need screenshot just let me know

Any ideas how to fix it manually? Im working on the newest version of LS. Thanks!
Last Edit: 2 years 5 months ago by pawciak.
The administrator has disabled public write access.

Re: [mysql error] CDbCommand failed to execute the SQL statement 2 years 5 months ago #80202

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
It looks like you are using Limesurvey version 2 which isn't stable yet.

When does the error show up?

Please open a ticket at the bugtracker and...
  1. Give as much information as possible
  2. Attach your survey. You can mark your ticket "private" so that only the developers will be able to take a look at it.
  3. Provide step-by-step instructions how to reproduce the problem.
  4. If possible/helpful please provide screenshots

Afterwards please post the link to the bugtracker so we can follow the progress.

Thanks!

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.136 seconds
Donation Image